> Well, at least we understand why you don't understand.
> After you have filled yourself in on the difference between the default
> transaction (gds_trans) which interbase starts for you if it doesn't get
> any other instructions...and...an explicit (named) transaction, which you
> create using SET TRANSACTION, I'm sure you will find a transaction setting
> that suits what you need to do.

Man I really think we are not talking the same language! I don't understand
what you mean by named transactions and SET TRANSACTION stuff. I'm calling
the routine isc_start_transaction to start the transaction and passing in a
isc_tpb buffer with how the transaction should work (isolation level,
read-only or read/write, ...). I then pass the ib_tr_handle to the isc_dsql
routines that need it. Are you saying thats not enough and I need to do an
isc_dsql_execute of "SET TRANSACTION"?

> You can set up the default transaction with the parameters you want and
> actually it's recommended.
>
> I guess you have the Embedded SQL Guide there...?

Yes I do though I've not been reading it since I'm not using Embedded SQL.

> >I'm not sure what SNAPSHOT isolation is. Remember I'm using the low level
> >API of isc_* calls. I didn't see anything about SNAPSHOT in the API
> > manual.
>
> Hmmm....are pp. 59 - 72 missing from your API guide?

I have those pages but there is no snapshot isolation method listed. I've
also looked in the ibase.h include file and its not mentioned there either.
The manual I have says its the "Interbase 6 API Guide" from Borland and the
pages you mention are regarding transactions (though 72 isn't the end of the
chapter). Could I perhaps have an old manual? In the ibase.h file there are
some isc_tpb things that aren't documented like isc_tpb_ignore_limbo,
isc_tpb_autocommit, isc_tpb_restart_requests, and isc_tpb_no_auto_undo. Are
these documented anywhere?

I'm fairly confused now both about whether we know what the other is talking
about, whether I have old manuals, or if I'm completely clueless! Off to do
the example program which will hopefully clarify exactly what I'm doing.

--
Brad Pepers
brad@...