Zeoslib Portal

Good day
I'm using version 6.6.6 with Zeos with ClientDataSet and my sql exists join with another table that is not what will be updated. I set up the key fields with the property providerflags pflnKeys, and pflnWhere pflnUpdate, other fields and pflnWhere pflnUpdate and fields of the table that made the junction, removed all the items providerflags. In time to insert a record and make the ApplyUpdates of an error saying that the field does not belong to the table, but this field is no setting in providerflags.
Could anyone help me?

tebosoftware,

Are you using a TZUpdateSQL component linked to your TZQuery to update the database? When the TZQuery contains a join, it's not possible to update it without TZUpdatSQL.

Unless ClientDatasets have an other way to update datasets, but I never understood how these components work exactly.

Mark