Thanks much for your consideration. Perhaps of small value let me explain how this one example may happen.
A tech builds a laser product and before packaging it is manually given a unique serial number used as the unique key. The serial number is composed of up to 16 alphanumeric encoded digits based on a scheme where each positional set is unique to the date, time, tech, etc. When the serial number is entered into the certification table, along with test results, the serial number can be easily transposed where it breaks the SQL insert. Should this happen all of FoxWeb crashes hard causing a manual stop/restart.
I hope this might be helpful.
Sent by FoxWeb Support on 01/30/2013 01:50:37 PM:
Joe, I will need to research this one a bit. I expect to post a response by the end of the week.
FoxWeb Support Team
Sent by Joe Goldsmiith on 01/29/2013 10:08:47 PM:
There are times when I would like to use On Error to more smoothly handle an error. For one example, under some circumstances, such as with a unique key violation, all of FoxWeb crashes causing a manual stop and restart.
If I were to use my own On Error to handle an error how do I pass On Error control back to FoxWeb?