Hi,
I basically have a job queue as a table, and two or more processes read the
same table, and then may attempt to update an entry - in essence I am
attempting to get an interleaved queue mechanism working, but it appears
SQL7 shared locking it stopping this.
In essence the select of the queue entries stops - or does not complete if a
second process is currently updating one of the entries in the queue.
What I want is to read the last committed change, but for the transaction
doing the select not to be held up until the other transaction completes.
I.e. I am doing my own update management with timestamp fields etc.
Currently I am using "ReadCommitted" Isolation level.
I currently run two connections - one for the select of the queue, the
second to do the processing and queue entry update, basically this is to
allow different transaction isolation levels for the different processes.
Is there anyway around this problem in SQL7?
(If you have not already guessed, I have just had to start using it the past
two weeks and SQL7 seems a right pain ...)
Thanks,
Myles Penlington
Advanced Management Systems Ltd
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
