Zeoslib Portal

Hi, Jan

It should work as you say in the documentation, but it use all fields all the time (in update and in where).


How do you set ZQuery ?

UpdateMode = ? (My setting : umUpdateAll)
WhereMode = ? (My setting = wmWhereAll)

thank you
Attila

Hi

ZQuery can auto generate UPDATE,INSERT, DELETE staement from SELECT statement (ZQuery). It is OK.

But I don't think it takes into account the field -> providerflag -> pfInkey,pfInWhere,pfInUpdate property.

Always doing the same thing.

Thanks Attila

Hi I use zeos 7.2 and Lazarus 1.8 (Win10), Firebird 2.5-win1250 cp, but it is an old problem. It emerge very rarely, only some character combinaton cause this problem. Now i solved this problem, I pumped all data to an UTF8 database. I think the root of the problem is similar to http://zeoslib.sourc...

Hi

I try to use in my application FB2.5 with win1250 cp.

But in dbedit i have problem.
When i type the text everything is OK, but when i leave the dbedit something go wrong.
See attachments.

Any idea ? What is wrong ?

Thank you in advance.
Attila

Thank you FrOst, i will try it.

Hi No i have primary key, but i use WhereMode = wmWhereAll (with all fields ) (with wmWhereKeyOnly everything work fine) because i would like to detect all changes in a row for example : there is a table : country id -- int not null primarykey name -- varchar(30) not null state -- char(10) ---------...

Sorry, YES Because i have forgotten my password, and i can't find any way to come back to the forum again. Thnak you for your help. But i have an another question. I have a Firebird 2.5 table with some fileds. Some fileds nullanle , some not. Firstly i delete only one record with ZQuery.Delete ---> ...

Hi !


Before ZQUERY send a delete, update , insert SQL statement to the server (with .POST, .DELETE etc)
How can i get, read the composed SQL query (as a string) before ZQUERY send to the server ?

Thank you Attila

OS : Win10
SQL server : Firebird 2.5