existing records in database

Results 1 to 2 of 2

Thread: existing records in database

  1. #1
    Join Date
    Dec 1969

    Default existing records in database

    how can i check for data existing in the database or not for avoiding duplication for data in my database

  2. #2
    Join Date
    Dec 1969

    Default RE: existing records in database

    before inserting the data into the table,<BR>you need to fire a select query on the table and<BR>compare the values entered in the form with the<BR>data in the table.<BR><BR>if the recordset returns nothing that means that the<BR>data is new and then you fire the insert<BR>otherwise just say that the data already exists and skip the insert statement.<BR><BR>if you can post the columns of the table in which the data<BR>should be unique then i can help u better.<BR>

Posting Permissions

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