>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.
BTW, I know you are familiar with this situation, but responded for those who may not have heard of a "deadly embrace."
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.