Subject | Re: [IBO] Separated transaction for DML with IBO? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2008-12-09T14:51:37Z |
Hello Carlos,
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/
> Does anybody knows if there is a way to have separated transactionsLike in FIBPlus? AFAIK no.
> used only with the DML instructions generated by a
> TIB_Query/TIBOQuery?
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/