Al,

Thanks for the response...

It seems to only happen if you follow the steps I outlined and modify the table via the Browse window.

If you put this in a PRG and run it, the TABLEUPDATE() doesn't fail, so I guess this is just one of those "bizarre" behaviors you some times run into.

The original problem that sparked this investigation, turned out to be a corrupt table.

Thanks,

- Aaron.

>>Using VFP 6.0 SP5:
>>
>>I'm trying to troubleshoot something quite odd...
>>
>>I am trying to add a record to a table which is using Optimistic Table Buffering (5), within a Transaction.
>>
>>When I use the TABLEUPDATE() command, it returns False, and when I check AERROR(), I find the 1887 error message.
>>
>>The reason this is odd, is because I've gone through the table and removed all field rules/defaults and the trigger expressions (for the RI)
>>
>>So I'm at a loss as to how I could be getting a recursion error?
>>
>>Here are the steps if anyone wants to try and reproduce this:
>>
>>USE Tablename
>>CURSORSETPROP('Buffering', 5)
>>BEGIN TRANSACTION
>>BROWSE && Insert New Record At This Point through Browse Window
>>? TABLEUPDATE(.T., .T.) && Have tried various parameter combinations.
>>AERROR(cErr)
>>? cErr[1]
>>? cErr[2]
>>ROLLBACK
>>USE
>>
>>"any" feedback, welcomed.
>
>Have you tried stepping through this in the debugger?