>>I am interfacing with a third party VFP app and am having the devil of a time figuring out the cause of a sporadic error. The error I receive is "record in use by another" eventhough I am the only one logged in (100% sure of that). The error comes from a REPLACE statement that updates the grandchild table after the tables have been updated and the transaction is closed. As I said, I am the only one in the system, no other datasessions using the tables are open.
>>
>
>If i understand correctly,
> you have a 3 table relationship setup
> you start a transaction
> you end the transaction
> you then try to do an additional REPLACE
>
>Have you tried closing the other 2 tables when you finish the transaction or turning off the relationships ?
No I havent. Something to consider, but I doubt that the time involved to close and re-open the table would give a satisfactory solution. I also sporadically get the error when I update the values in the gc table from a grid that has both c & gc fields in it.
The question of the day is..if I'm not locking it...then who/what is?