General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
*IF* the 2 different applications in question both lock more than the log table to do their work, then you may be encountering a 'deadly embrace'.
A 'deadly embrace' happens when app#1 locks (record(s) of) fileA, then fileB and another app locks in fileB then FileA. A single app most likely always locks all records in the same sequence, thus no problem. But if some other app uses some other sequence then you stand a chance of a deadly embrace. App#1 has a lock on fileA and needs fileB but app#2 has fileB locked and needs fileA.
good luck
>Hi
>
>I have an application where several instances of a program may be running at the same time. They all write to the same log table. If another executable, which also has the log table open ,is also running on the computer at the same time, inserts a record into the log table are somehow stopped until I exit that program.
>
>The strange thing is that I can open the table via the VFP IDE and add/delete records as I like. I have put debug messageboxes in the program and they show that the table is not locked yet the program hangs at the insert command (The problem doesn't happen if I am using the debugger)
>
>Has anyone any idea why this might be occuring?
>
>Regards
>Geoff Scott
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only