At 06:52 PM 05-01-01 -0700, you wrote:

>On Saturday 06 January 2001 00:56, you wrote:
> > At 05:32 PM 05-01-01 -0700, you wrote:
> > >On Friday 05 January 2001 23:40, you wrote:
> > >
> > >I've read the DevGuide Working with Transactions many times and tried all
> > > the options in there. The "SET TRANSACTION" will likely be talking about
> > > ODBC isolation levels and locking but I'm a layer below that.
> >
> > You must be joking!

Well, just that if you had read the Language Ref, you would realise that
it's part of IB's (and many other databases') SQL language; and that
isolation levels are not a feature of ODBC drivers but of databases; and
that IB's isolation levels and lock resolution settings are discussed in
the entry for SET TRANSACTION.

>I don't think so...??? I'm using the isc_dsql routines which you could of
>course use to create an ODBC driver

or Delphi components
or various utility programs
or whatever you need to use the API function calls for...

I didn't take your question to be about programming, that's all. You
seemed to be asking about how to find out about the locking strategy. I
was trying to tell you where to find out about it...it didn't even occur to
me that you were attempting to write a db application using only direct
function calls.

<sigh>

H.
All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________