Myles
Are you trying to do this in Delphi with ADO?
Regards Neven
N.K. MacEwan B.E. E&E
[EMAIL PROTECTED]
----- Original Message -----
From: Myles Penlington <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Friday, 7 April 2000 15:53
Subject: [DUG]: Am I asking too much of SQL7?
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
