Myles
Silly question but why not server side it in TransactSQL
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 16:22
Subject: RE: [DUG]: Am I asking too much of SQL7?
> Yep, with the SQLOLEDB provider.
>
> > -----Original Message-----
> > From: Neven MacEwan [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, 7 April 2000 17:06
> > To: Multiple recipients of list delphi
> > Subject: Re: [DUG]: Am I asking too much of SQL7?
> >
> > 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
> --------------------------------------------------------------------------
-
> 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
