noel 55's Q&A profile

• SQL Server One to Many Join distilling the Many to two columns.

  I have a one to many relationships each claim we bill for a client has many status. Things like claim sent, claim received by insurance company, claim rejected. There are 80 different statuses all stored in tbl_status and I need to distill into three columns. I currently have the query below that returns only accepted claims and the date claim was released to insurance company. I am struggling with how to have multiple columns released; paid, rejected each column can be represented by one or more of the 80 status in the status table. So I want something like this Select Case status ‘135’ or ‘111’ then Y else N AS Accepted Select Case status ‘123’ or ‘444’ then Y else N AS Released Select Case status ‘435’ o ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Has anyone been able to run an XNA Game?

  I've seen many people sharing code and talking about Space Wars but no one really talking about running XNA Games. I do however see many people having problems running an XNA Game. People like me, have everything needed to run the game, a high Graphics card, and yet the game will not run. Those of you that are running games, do you know why DodgingRain wrote: I believe, and feel free to correct me if I'm wrong, that some of dx9 can be software emulated if the hardware doesn't support the feature, doesn't seem true with XNA. Some features, not all e.g. hardware lighting and transformation. But even the older cards do this in hardware now. This is a DirectX not a XNA restriction. For things l ...Show All

• .NET Development FileStream in Visual Studio 8

  Hello everybody, Today is my very first day with Visual Studio 8, I was working on Visual Studio 6 before. I have an application that is using "fstream.h" and "ofstream" but they are not valid anymore in Visual Studio 8. Can anyone advice what have replaced these old functions or how to handle files input/output in Visual Studio 8 Thanks in advance. I replaced the old { #include "fstream.h" } by the new { #include <fstream> } but when I try to define { ofstream MyFile ; } it gives an error! Can you please provide some more details about the new fstream definition in Visual C++ 8 and how to open/read/write/close a file. Thanks in advance. ...Show All

• Visual Studio Team System 'Custom' parameters in queries

  Hello, Is there a way to add a custom parameter to a query so it will be prompted to the user when he/she double-click the query to open it. To give you more details, we are looking for creating a query that will accept a list of work item IDs and return all the issues that matches these IDs. A convenient way will be for us to specify this kind of condition when building the query: ... And ID In @myIDList ... We tried that, but it seems to be not supported. Thanks for your help, Gaetano. I'd like to vote for this feature too. The first and foremost use of this for me would also to be to type in a work item ID (although, I'd be happy with entering just one ID - ...Show All

• Community Chat Free Online Visual Basic 2005 book

  I have recently made my book free, sponsored by AdSense of course. The book is designed for non-programmers. After many hours of tweaking javascript I have finally completed most of the design of the page, so that it works with google and also so that there are no frames. If anyone would like to help with the book, ie: make it better, then feel free to contact me here or at the site. You can find the book link in my signature... Thilakavathy wrote: Is this available in the pdf format Yeah errr no. Not yet. I still have to redo all the code snippets in propery colour codes and add C# code. It will be a while. I'm also still 50/50 on doing the pdf thing. Google adsense is sponsoring it you know... What d ...Show All

• Visual Studio Express Editions Get the currently selected control in a panel

  I have a panel and there is a feature that adds controls at runtime. I need them to select on click or do something else that allows my to control the active control The control that has the focus jumps to mind. You can retrieve a reference to it in the form's code with its ActiveControl property. It is however important that you don't use a control (like a button) that can receive the focus itself or ActiveControl will just return a reference to that control instead of the one that was previously selected. A toolbar button qualifies. Or a keystroke that you catch in the form's KeyDown event. ...Show All

• Visual C++ Some DLLs load, others won't

  Hello. I've been trying to display dialog boxes from two different DLLs. AfxLoadLibrary() loads the first DLL fine; with the other DLL, I get an error that says the DLL cannot be found. The thing is that I know the paths to both DLLs are correct, because they're both in the same place. Also, a resource-hack program I have loads both DLLs fine. Any ideas Here's my code, sans all the error-checking: p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman';} h1 {margin-top:12.0pt;margin-right:0in;margin-bottom:3.0pt;margin-left:0in;page-break-after:avoid;font-size:16.0pt;font-family:Arial;} p.ListingHead, li.ListingHead, div.ListingHead {margin:0in;margin-bo ...Show All

• Visual Basic How to switch to another application from mine

  Hi, I want to be able to switch to another already running application when a user presses a button on a main form. I can enumerate the running processes and see that the one I want is running, I can get its Window Handle. How can I switch to it. ahmedilyas wrote: you could also use the SetForegroundWindow API, I think they both do the same job Thanks for pointing that out.. you should use the SetForegroundWindow to activate another application. SetActiveWindow only works for applications in the foreground. My mistake. ...Show All

• Visual Studio Printing problem for custom page

  Hi fr. I have a problem with printing using Crystal reports. The problem is i want to print some data on custome page of 5" X 5" using a dot matrix printer and the printer should stop printing there itself it should not roll down to end of the page. Any idea how to do this.. Thanks Puneet Minda ...Show All

• Visual Studio Express Editions Can't find compiled program

  I compiled the Hello World program with no erors, but i can't find the .exe file for the program Use the windows search function. In this case, search for files named hello*.exe, or maybe just hello. It will find all files with the work "hello" in the name. I suspect there are not very many of those. Let it search all of your drives and eventually it will find your file. ...Show All

• Windows Forms Populating a treeview recursively

  Hello, I have a self joined table named: Category. It contains 3 columns only: CAT_ID, PARENT_CAT_ID and Title. I'm using a data reader to get the categories from the database as follow: while (dbReader.Read()) { Title = (string)dbReader["Title"]; CAT_ID = (int)dbReader["CAT_ID"]; PARENT_CAT_ID = (int)dbReader["PARENT_CAT_ID"]; // MessageBox.Show(Title); <- Working!!! } Can anyone please tell me how can I populate a treeview recursivley with the data I pulled from the database Please note: 1. PARENT_CAT_ID = 0 for the root records. 2. Child records doesn't always follow parent record in the database query result, they can be mixed. I would appreciate any help. ...Show All

• .NET Development How can I adapt any DBF file to SQL Server 2005，there are any Provider ?

  Now I develope some application with VB.NET 2005，and I need some database fome .DBF file to be my database，I wish to join these database to my SQL server.How to do mingch06 Hi ! You can download the FoxPro and Visual FoxPro OLE DB data provider from msdn.microsoft.com/vfoxpro/downloads/updates. You can use it to connect to your DBFs in VB or set up a linked server to the data in SQL Server. ...Show All

• Windows Search Technologies How to open an outlook item from the searched result (mapi url)

  Hi Everyone !!! I am totally new to WDS development. I have downloaded WDS SDK and sample application. Using that sample application i learnt a lot but have problem in opening outlook item from the search result's mapi url. Mapi url is like mapi://LocalHost/Default/Mailbox – Some User ($484efb89)/0/Inbox/ /at= :somefile.txt Some part of this mapi url is encoded i.e. store entry id (Hashnumber) and EntryID (encoded as Unicode string). For detail please check http://blogs.msdn.com/stephen_griffin/archive/2006/05/10/594641.aspx . In this article i found the decoding algorithms to calculate store hash and to calculate encoded entry id. These algorithms are in c++ but i wanted it in c#.net, can anyone please do for me ...Show All

• Visual C# Why cant we execute the same SQL script in Visual Studio?

  Hi All, I tried to execute one of my SQL scripts (that executes perfectly in SQL Server 2005 Express Edition) in Visual Studio 2005 Professional edition using a SQL Server Database project but it gives errors. Is there a syntax difference in this case Best regards, Imesh Hi Imesh, Given the format you've used, yes, I believe the VS IDE parses queries differently, but I'm not really an expert on VS. I'm not sure where you're trying to run this query in VS, it might help to know what exactly you have open in VS when you're trying to do this. Management Studio and Visual Studio are two different products, created by two different groups designed to do two different things. It's not surprising tha ...Show All

• Visual C++ Designing OCX

  Hello All, I am designing an ocx control in vc++ 6.in this class i want to write a member function which calls functions in dll files. I just tried the thing but when i am adding the ocx control to my application in vb.net its giving error as self registration failed. How can i solve this problem ,Please help me. Hello Re: Designing OCX Questions on VC++6.0 are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All