Trap dup key on rs.update, change key and re-try update ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some code that creates a key based on user first and last name and location. In the unlikely event this leads to a dup key my rs.update fails. Is it possible to trap this with 'on error' so I can change the key and retry the rs.update ?
Example code would be much appreciated.

Thanks for any help.
 
Hi somany:

Go to the thread "Delete a Record from a Table" which began on 6/8/2004...
in my note I handle error trapping in such situations. Let me know if you
can't find it.

Regards,
Al

somanybugssolittletimetofixthem said:
I have some code that creates a key based on user first and last name and
Click to expand...
location. In the unlikely event this leads to a dup key my rs.update fails.
Is it possible to trap this with 'on error' so I can change the key and
retry the rs.update ?
 
Back
Top