Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: using vb 6.0,please solve my problem

    i m using text box to save data in table of sql server 2000 ...when the data is getting save it is also adding to the list box......i want the data not to be saved again at the back end in sql server 2000 if it is present in list box once

  2. #2
    Join Date
    Mar 2004

    Re: using vb 6.0,please solve my problem

    The easisest way is to make that field a unique identifier or primary key, that way when you try to save to SQL it will raise an error. Otherwise you will have to add code to check your listbox before sending the insert query to SQL.

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts