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
