Zeoslib Portal

Thank you Jan, to clarify.
Attila

Hi

Could somebody tell me what is the difference between

ZQuery + Readonly=True and ZReadOnlyQuery ?

Mainly speed ? or somthing else ? (FireBird SQL)

Thank you Attila

Hello Jan
Thank you

Maybe i found a solution :

ZConnection.Autocommit:=false;

and i use

manual commit and rollback :

ZConnection.Commit or ZConnection.Rollback


Thnak you Attila

Thank you miab3

But i edit table1 in dbgrid.

After post a record in the grid , i would like to made some changes in table2, in table1.afterpost eventhandler.

If there is something wrong happen in table1.afterpost i would like to rollback all changes in table2 and table1.

thank you
Attila

Sorry I use FireBird SQL 2.5

Hello I have two table : table1 and table2 ZQuery1 = table1 ZQuery2 = table2 After post a new record in ZQuery1 (table1) i'd like to modify something in ZQuery2 (table2) in ZQuery1.afterpost event. Is it possible to do it in one transaction ? And rollback the changes in ZQuery1 and ZQuery2 if someth...

Thank you Sir.
Ok. I Understand.

Hello

I use special collate (PXW_HUN) for a varchar field. (codepage WIN1250)

Why do i get different resultset order if i use

ZTable SortFields-SortType properties or

ZQuery normal "select * form ...... order by ...."

Thnak you Attila Kovács

Thanks

Yes i found too, that it is the only possibility.

Attila

Dear Michal

Thanks for your answer

But i don't how it can solve the above problem.

i need : when i only watch data in a DBGRID, i don't want that the firebird is intransaction. (only while firebird load all data into a grid, and exit from transaction)

Attila

Thanks for your answer my problem with it : I have a grid only on a form and i just look at one table of my database (no edit, no insert, no delete) ONLY SELECT statment Zeos/firebird alway keep the system in transaction, because DBGRID need an opened dataset. So the firebird internal SWEEP can't cl...

Dear Sergiomaster

Thanks for your patience


So, then - i used ZSQLMonitor - i can't run a simple readonly query (select * from ...) without transaction

Zeos is always keep in transaction Firebird Server. (or firebird need transaction for select, update , insert, delete .... always)


Attila

So exactly, i want only a simple readonly query (SQL= select * from...) (nothing special) and i call .open SQLDB : after .open the sqldb start automatically a transaction an keep this state until .close and .commit But i don't want this, i want to open a readonly query, but without transaction ? Can...

Hi I have a simple question. I use lazarus sqldb and zeos too from freepascal. if i use sqldb it is always in transaction even if i open a readonly simple query. (.open method start a transaction) And how does it work in zeos ? Or it depends on the state of the Connection.AutoCommit property. if Aut...

Thank you very much for the fast action.

Attila