Tryst's Q&A profile

• SQL Server Should I count on dimension fields or use a fact table (in this particular case)?

  Hello, I need to do counts of employees - active, on leave or terminated. I had a field for each in my fact table, that has a 1 or 0, in the appropriate field, and the counts work just fine. The problem is when I drilldown with the data. Let's say I have 10 active employees in a location. As I drilldown I see them but I also get the 2 terminated employees who are also in that location. So my drilldown results show 12 employees not 10. I thought a possible way around this was to have a dimension with the different statuses (Active, Leave, Terminated) and do a count on that. But that doesn't feel like the proper design to me (I could be and probably am wrong). Is there a way around this What am I doing incorrectly Thank you ...Show All

• .NET Development ODBC Access using Server Explorer gives TABLE_CAT error

  Hello I am having a problem accessing the ODBC tables from the Visual Studio .NET 2005 version I am trying to use the Server explorer (View a Server Explorer) option in VS 2005 to acce ss the data through one of our properiatiary database. I am able to successfully login and execute Select Queries in the Queries BOX. But when i try expanding the drop down of TABLES and VIEWS in the right pane after connecting through the system DSN, I am getting the following error. Microsoft Visual Studio Column 'TABLE_CAT' does not belong to table Tables. This method works fine with the VS .NET 2003 version. I was trying to find out if this could be a problem since couple of folks had reported this problem in ...Show All

• Visual Studio Express Editions Using WinForms and Console in VB.NET Project

  Hello, I am needing to use forms and console in my apps. I am making a web server right now, and I want the main UI in form type so they can edit things with a GUI, and then have the console show things like access form IP's and what p[ages are viwed etc. Any help is greatly appreciated. Thanks in advance. I don't think so unfortunately. Perhaps NoBugz knows a way of doing so but I believe this will always be launched since you changed the project type fo Console Application...which will show the Console screen at startup. Perhaps you can get a handle on it or something then hide it...not sure Looking at the Console class, the closest one is the SetWindowSize method, give it the x and y co-ordinates of setting the size of the conso ...Show All

• Software Development for Windows Vista Expired timers are processed very slowly

  We have a process where thousands of workflows are created within 30 min time. Most of these processes are awakened by a delay some hours later, invoke a web service and then end. This all works perfectly, except that the workflows that expired are processed sequentially, one after the other, making the process take several hours instead of the 30 min it would take if several workflows were processed in parallel, we tested it by removing the delay. Also, because of the sequential processing, the workflows that are run last are run much later that the expiry time. This is using ManualWorkflowSchedulerService and useActiveTimers=true. Is there a way to force ManualWorkflowSchedulerService to process several expired workflows in parallel Tha ...Show All

• Windows Forms Mgbox Function doesn't work in my windows Form ?

  hello guys: I have a windows application for EDI system,my platform is vs.net 2003 , and my application includes some children forms ,now I have a windows form to scan the sticker and save the barcode data in sql 2000 database,but when I scan the sticker I need to check the sticker is correct or not ,if the sticker is wrong,the system will show a warning message,my souce code as below: Private Sub txtScanTxt_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtScanTxt.TextChanged If Len(txtScanTxt.Text) = 12 Then Select Case UCase(Strings.Left(txtScanTxt.Text, 5)) Case Strings.Left(labBuyerPo.Text, 5) If AutoSelectCartonNo(Strings.Right(txtScanTxt.Te ...Show All

• SQL Server If Syntax in Report Builder

  I wanted to apply formula for the date field in my report created with Report Builder.I guess I need to use the functions which are available in the same. Basically I wanted a simple formula, if date exists says "Yes" if not 'No" If(rec_date isnull,"No","Yes") but is not taking. Please help me in getting the correct syntax. Thanks in advance. Praks Hi Praks Sorry for not reading your question correctley. I was thinking of BI Here is the solution : IF(rec_date = Empty, "no date", "a date") The 'Empty' keyword may need to be replaced by the 'Blank' keyword. This worked for me, but I didn't have time to test with a date field. ...Show All

• Visual FoxPro Copying from one sheet to another within the same book

  I am creating a workbook for a local company using excel. I've got most of the book worked out except that when information is input into the "main" sheet I need the same information - the entire row - copied over to another sheet within the same book depending on certain criteria. In other words, if the value in a column is 2 then copy the entire row to sheet 2, if it's 3 then copy to sheet 3, and so on. Is there a way I can accomplish this kind of automation You need to create a function (macro in excel) and apply it in each cell of column 2. Macro can be done with vb editor from excel using "if" and "copy" range from excel visual basic. ...Show All

• Visual Studio Express Editions Program to help read documents

  I am not very good at programing. How would I make a program to read microsoft word or text documents. What functions, libraries and things to i need If all you need is to open a Word Document in Word, then you can use Process.Start(). For details on Process.Start with a VB code snippet take a look at the following thread: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=77106 If you need to programmatically use the Word Object Model, read the following KB Article: http://support.microsoft.com/default.aspx scid=kb;en-us;316383 From VB you can open an instance of word with a document loaded using something like the following. Dim wordApp As Word.Application Dim wordDoc As Word.Document Try ...Show All

• Visual Studio Express Editions Please help VB.Net beginner....

  Hi.....I'm a VB.Net beginner.... I'm learning how VB access databases, including Oracle. I've type many code to trying to access databases....like this : Dim connstring as string="Provider........." Dim sqlstring as string="Select ........" Dim myadapter as OledbDataAdapter(sqlstring,connstring) Dim mydataset as newDataset("Tbname") myadapter.fill(mydataset,"Table1") and so on...... I typed the code in Form1 Load Events....Then I create a button...and, at the button click events I typed : mydataset.....or.... myadapter....it's errors because it's couldn't recognize those objects...... How to solve this problem.... Where I must put the code.... hope someb ...Show All

• Visual Studio Team System Trim down TeamBuild so it runs only the PostBuild Tasks

  Hello, we have investigated the following problem, and it seems, that we have found a solution for it. We use a third party auto-build solution to build and drop all our products. This solution is based on FinalBuilder ( www.finalbuilder.com ). We use Team Foundation Version Control to store our source code and use Tfs work items for bug tracking and project mangement, etc. This auto build gets, labels, builds our code and drops the result to a deployment server. That works good for us. So far so good. But in TeamBuild there is a one task its result we like and don't want to miss. Its the result of the GenCheckInNotesAndUpdateWorkItems task. This task searches for the changesets between to labels and the attached workitems. This informatio ...Show All

• Visual Basic Using web component problem

  Hi, I tried to create an pivot table in asp.net (2005).  The problem is I can't see the pivot table control in the tool box after I add the pivot table web component pivot table control to the tool box. Also, I tried to create an instance at code-behind for pivot table.  I tried to pass the dataset to the data source, but it looks like it can't accept it.  My data is in xml format.  Is there any way to pass xml data to the pivot table. Thanks, David Thanks for the info. Since it's a web control, I tried to add the web component pivot table and it doesn't show in the tool box. How could I create an UI in the aspx page Thanks, David ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Texture Filtering Problem

  I have just recently converted my MDX project over to XNA, now I have slowly ironed out most of my problems but one that remains is the texture quality. My game looks the same as the old MDX one does when mip filtering is not enabled. Is there anything special in XNA that would stop the mip filtering from working or any kind of problem that would cause a similar look on the textures. It's like something is overriding the setting, but I cant figure out what it is. Derek Nedelman wrote: A 1 is being passed, but it doesn't mean that only one mip level is created. When specifying ResourceUsage.AutoGenerateMipMap, all the mip levels are created. I know because this is what I use. In fact, passing 0 with ...Show All

• Visual Studio Installing VB 6.0 on Vista?

  I've got my Visual Basic 6.0 Disc, as well as my Visual Studio 6.0 msdn Library Disc, and I'm wondering how I install them on Vista. I put it in, and get a compatibility warning, so I want to see what I have to do before I actually try to install it. Can I just ignore the warning, or is there something I need to do first to install it properly I don't want to screw things up on my computer by just trying to install it. To install VS 6.0 on Vista RTM there are a few compatibility issues. One is VC++ is not officially supported because of several issues. I installed VS 6.0 on Vista RTM Ultimate just by running as Administrator and not installing the VC++ product. Turning the UAC off during the larger instal ...Show All

• SQL Server Remote connection issues

  My experience with SQL Server Express 2005 has been nothing short of a nightmare. It is installed correctly, and is running, I can connect through management studio express and have created a database, but only to instances running locally. If I try from another machine, it won't connect, saying that the problem may be due to the fact that by default, SQL Server does not allow remote connections. However, I have enabled remote connections (through TCP/IP and named pipes). I have added sqlserver as a firewall exception, to no avail, and disabled the firewall as well. Nothing seems to work. Ultimately, I want to connect to a database and execute queries from a VB program. I am a competent programmer but I am at my wits end. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 10-bits per component graphics

  I need to output 10-bits per component graphics but the System.Drawing.Color class only allow 8bits per component (0-255). Any idea What you're doing simply won't work - and I'd be amazed if you actually got anything close to what you intended Unless I'm much mistaken, the .NET class will generate the correct number of bits (32) and thus you won't get any errors, but D3D will be reading the 8-8-8-8 format as 2-10-10-10: AAAAAAAARRRRRRRRGGGGGGGGBBBBBBBB AARRRRRRRRRRGGGGGGGGGGBBBBBBBBBB Drawing it out like I have above should clearly illustrate that the raw binary data does not match and, for example D3D will read the lower 4 red bits and upper 6 green bits from .NET's form and interpret it as a s ...Show All