Thanks for the reply, but I think this is already being addressed. The actual code used is:
unlock record pnParentRec in lcParentWkArea
Sorry I didn't include the actual code before.
>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#
981159>
>Message 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,