Most of it is in Stored procedures, the data returned is sent down a socket
to another process.
Myles.
> -----Original Message-----
> From: Neven MacEwan [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, 7 April 2000 17:27
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: Am I asking too much of SQL7?
>
> 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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
