Subject Re: [IBO] Separated transaction for DML with IBO?
Author Thomas Steinmaurer
Hello Carlos,

> Does anybody knows if there is a way to have separated transactions
> used only with the DML instructions generated by a
> TIB_Query/TIBOQuery?

Like in FIBPlus? AFAIK no.

I'm using a query component for browsing and another one for editing.
Each component can have it's own transaction component with different
isolation levels, read-only/read-write. I like that way, because it
allows me to access different tables/views in these two components.

For example, my browsing dataset is usually based on a VIEW which might
be a join over several tables. This allows me to e.g. sort by any field
via the TIB_Grid component, even if it is joined field like e.g.
customer name in a relationship between orders and customers.

I'm also able to close the browsing dataset and leave to editing dataset
open ...



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/