>>Deadly embrace? This is when two processes are waiting for one another two finish before continuing- how could you do this with VFP?
>>
>>SET REPROCESS TO AUTOMATIC has always done it for me- I have never had a problem. I use both INSERT INTO and APPEND BLANK depending on the situation, and have not been bitten with either one.
>
>I think the kind of scenario he's thinking of here is two users running the same application. User 1 locks record X, User 2 locks record Y, then User 1 tries to lock record Y while User 2 tries to lock record X creating a circular locking dilemma. I don't know if this is his exact situation since he seems to be dealing with INSERTs, but I assume this is what he is referring.
>

If this is really the problem, I have no solution except for to change this strategy. There is rarely a use for explicit locking in the first place, and VERY rarely a use for locking two records at a time. Seems this is a good candidate for transactions, instead of explicit record locking.