>You can simply Copy the ON ERROR example on VFP help!
>Then, add further control on Error number.
>
The trouble is, for SQL statements and REPLACE and DELETE (and I'm sure others), no error is generated, a dialog box is opened, demanding that the user find some file that the user has no idea about. What's more the open dialog doesn't even say what file it wants you to find! A very ungraceful way to handle an unexpected situation.
The bad part is, if this ever happens in code running on a web server in response to a hit, this 'find' dialog is equivalent to a hang. THere's no way around it, no matter how good you error handler is.
Erik Moore
Clientelligence