Hi Debra,
There is a known issue with UNLOCK in vfp9, I don't know if it is the same bug, but you could try the workaround that is in that thread:
Thread#
981159Message with the workaround:
Message#
981278>I have stepped through the code again with the debugger and it is not the RLOCK that is failing. It appears to be the UNLOCK that fails. When I hit the UNLOCK command, I go to the ON ERROR routine, but VFP does not throw up an error. The code just continues on as if all is ok until I return from the RI_INSERT code then I get the "trigger failed" error.
>
>As I have stated before, this only happens on a handful of my tables and when I step through the code with the debugger, I do NOT get "trigger failed". I only get "trigger failed" when I let the code run without stopping. Could this be a timing issue?
Regards,
Frank Camp