Gary W's Q&A profile

• Visual FoxPro Primary key + delete....

  General Design Question…. Suppose I have a table (Table1) with a primary key (PKId), if a user deletes a record then wants to add a record with the same PKId value there is a Primary key violation because the table has not yet Been packed. What is the best solution to this I have Considers the Following… 1) Indexing on PKId+!deleted() , but this would only solve the problem if he delete the record once, what happens if he deletes the second records he created The Delete will fail( ), or a primary key violation. 2) When deleting, replace the primary key with a value from a counter table. This will work but I ...Show All

• SQL Server SQL Management Studio integration with SourceSafe

  Hi, as I've read from msdn threads there is a way, to source control Stored Procedures through Management Studio, but I haven't found a step-by-step guide how to do this. What I've done is selected SourceSafe as a source control program in Management Studio, but still I don't have any "Add to source control" option on Stored procedures. Can somebody help me with this stuff You should genarate separate script files for each of your sp or function or any other object by Enterprise Manager or any third party tool (SSMS doesn't have such feature, unfortunately). Then create SSMS project specifying A ...Show All

• Visual FoxPro Help

  I have developed a FOX PRO 2.6 Version application which has developed the following error message when updating the cashbook receipting module.The message is " TOO MANY FILES OPEN".The application is on WINDOWS XP PROFESSIONAL it is running well on WIN 98 with the modification of config.sys " FILES = 100".I have done the same to XP but in config.nt and it still gives the error message what could be the problem . The total cashbook module prgs and database files are 69 in total. Which config.nt did you modify You must do it in C:\WINDOWS\system32 folder. ...Show All

• Windows Forms Display Text in TextBox at Cursor Position

  Hi,   I want to display the text which is dragged from a TreeView at the cursor position in the TextBox. I don't how to get the text from the textBox till the cursor Position. Can u suggest me someways to do it Thank you for consideration, Lakshmi. Thanks! I tried that and found out that SelectionStart gives the Cursor position in&nb ...Show All

• Visual C++ unable to add any item to the toolbox

  The environment: VS2005 (final version). Win2K. I just started working with this new VS2005 in bits and pieces. Today I realized that the toolbox was empty and it does not allow anything to be added to it. According to HELP, The Choose Toolbox Items dialog box displays tabbed panes listing components that are recognized on your local computer. You can use the Choose Toolbox Items dialog box to select or remove components, and to add items to the Toolbox or remove items from it. To open this dialog box, select Choose Toolbox Items from the Tools menu, or right-click on the Toolbox and select Choose Items from its shortcut menu And I ...Show All

• Visual C++ Directx missing file problem

  Hi folks, Sorry if this has already been put up. I'm getting far too annoyed by this. I'm trying to get started with 2D graphics programming in Directx, and I'm trying to work with the samples in the June SDK. Absolutely nothing will compile. These tutorial projects all come up with the following error: ------ Build started: Project: CreateDevice, Configuration: Debug Win32 ------ Compiling... CreateDevice.cpp c:\program files\microsoft directx 9.0 sdk (june 2005)\include\d3d9.h(40) : fatal error C1083: Cannot open include file: 'objbase.h': No such file or directory Build log was saved at "file://c:\Temp\Real Blank proj\CreateDevice\D ...Show All

• Visual Studio Team System New Team Project Error.

  I installed TFS on a clean machine. and it looks very successful. when I open my vs.net 2005 and create new team project use team explorer.it prompt a error: Project creation failed with error:"Initializaton failed for plugin(s):'Microsoft.Pcw.wss','Microsoft.Pcw.currituck'" and this is the log content 07/15/2005 10:38:37.781 | Module: ELeadServiceMediator | URL for eLead web service retrieved as " http://jay:8080/bisserver/EleadWebService.asmx " from the registration service | Completion time: 0 seconds 07/15/2005 10:38:37.781 | Module: ELeadServiceMediator | eLead web service proxy constructed | Completion time: 0 seconds 07/15/2005 ...Show All

• Windows Forms DataGridVeiw Control(columns)

  Hey, I am trying to amke it so when you clcik on button1 then on datagridveiw1 it will add another column, and the header text of the column will be whatever text you have put in textbox1... I can do all of this except for the adding colums part, I tryed different ways of code to do this but I cant figure out how without getting errors, so can someone help me out Thanks :) EDIT: oh, and I am using Visual Basic 2005 express Hi there, I have found that the below way works for me (& it seems to work with bound and unbound DataGridViews). Basically I have copied and pasted the event handler for a but ...Show All

• Windows Forms MaskedTextBox and the Decimal Type

  Hello All, I'm hoping someone can help me with this one. I have a model object that represents a stock part. This part has a price. The price is stored on the database as type money. The price on the object is stored as type decimal. I have a binding source that has this object as it's datasource and it is bound to serveral controls on the stock part view. The bound control for the price is a MaskedTextBox. When I input a price, say 2.35, and tab out of the control it is stored properly in the object but the bound control displays 235.__ I have tried the following masks, none of which work... 999.00 ###.00 000.00 Can someone clue ...Show All

• Windows Forms What's the purpose of 'PreviewKeyDown ' event?

  What's the purpose of new 'PreviewKeyDown' event The doc doesn't say much. Is the only difference that it occurs before the 'KeyDown' event If everyone start using this instead, won't it simply replace 'KeyDown' When should I use one or the other This event is fired before the KeyDown event is fired. It only gives your an preview and you can't set the Handled flag. Use this event for logging logic, shortcut logic because this will be allways fired and can't be stopped by setting a Handled flag. ...Show All

• Visual Studio Express Editions VB 2005 Beta 2 Indepenent of .NET

  Is there any way to compile a program (in VB2005 Beta2) and make it run independently of .NET Framework ...Show All

• Visual Studio Express Editions Problem writing to database

  I have a problem writing data to a database that I hope someone here can help me with. I have a program whose main function is to record daily measurements. The measurements are saved in a database. This piece works just fine. Another piece I am working on is the ability to add new users with passwords etc to the program. When I open the window I can add a new user and then review all users with the new user shown. However, if I close this window - not the whole application - and then reopen the add user window the new user is no longer there. The user's names, passwords etc are saved in a second database. Any help will be greatly appreci ...Show All

• SQL Server sp_dropsubscription, article

  Hi There I needed to change a column definition for a published table. I did the following. sp_dropsubscription for publication specifying the one article. sp_droparticle for the specific publication/artcile BOL is not very clear here, i presume this drops the subscription ONLY for the 1 article , correct Secondly i then altered the table accordingly then ran sp_addarticle for the publication/article then sp_addsubscription for the newly defined article. This seems to have worked fine. But i now see there are 2 distribution agents for this publication to this subscriber. What exactly has happended Is the 1 distribution agent now simply dedi ...Show All

• Visual Studio Express Editions SQl Server 2005 Express with VS.NET 2003?

  Can I use SQL Server 2005 express edition with VS.NET 2003 www.putyourlogoontheweb.com Can I debug a stored procedure written in sql server 2005 Express using VS.Net 2003 ...Show All

• Software Development for Windows Vista Long run and threading- are they related?

  When I'm working on Lab5 , it concerns me again, -- probably just I'm not the person always think threading when I'm writing the business logic. To call a long run local service, I have to call ThreadPool .QueueUserWorkItem(..) . Also remember the default coding for workflow console app -- waitHandle.waitone()... Well , first I don't see the relation between business flow and threading--For long-run/heavy service I think it's safer to scale to separate appdomain,even on separeated box;second isn't nice if all these can be handled by runtime without giving a change to developer to screw up;third, is there any white-paper re: t ...Show All