TSQLQUERY : automatically generated update,insert delete statement

[k1attila12]

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

[marsupilami]

Hello Attila,

as far as documentation goes, Zeos doesn't use pfInKey. As for pfInUpdate and pfInWhere this is what the documentation says:

Fields that don’t have the pfInUpdate flag set will not get updated by Zeos.
Fields that don’t have the pfInWhere flag set will not get used for constructing the where clause of an DML statement.

Do you think Zeos should behave differently? Or do you think, Zeos doesn't behave as documented?

Best regards,

Jan

[k1attila12]

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