Eric S. Johansson wrote:

if the insert fails (i.e. record exists), it triggers an exception which I use to trigger an update. I get many more updates than inserts of course but I haven't figured out how to trigger an exception on update if the record doesn't exist.

From the FWIW dept, would an update be attempted if a record doesn't exist?

Perhaps test to see if the record exists first, then choose the applicable query?



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to