K kwokv616 Registered User. Local time Today, 13:50 Joined Nov 10, 2008 Messages 46 Nov 28, 2008 #1 I need to append a number of records into an existing table of records. I would like it to delete the existing record when on error. What code should I write to delete a record?
I need to append a number of records into an existing table of records. I would like it to delete the existing record when on error. What code should I write to delete a record?
H hellind Registered User. Local time Tomorrow, 05:50 Joined Nov 17, 2008 Messages 21 Nov 28, 2008 #2 Use SQL. If record exists, then Update the record. If it doesn't then Insert the record. If you want to delete the record then use SQL to delete the record.
Use SQL. If record exists, then Update the record. If it doesn't then Insert the record. If you want to delete the record then use SQL to delete the record.