ZupdateSQL demanding unnecessary columns

[gaspo]

Hi,

I've noticed that ZUpdate demands fields from all tables involved in a query and not the fields informed on custom SQLs.

Example:

TQuery.SQL = 'SELECT a.*, b.* FROM a INNER JOIN b USING(id)';

I create custom SQLs on a zupdate related to this query to chage only the table "a".

When I try to Insert in the table "a" using the Zupdate, it return an error, demanding fields from table "a" AND "b".

I believe that is a bug. On prior versions the behavior was different.

Thanks for your job creating zeos.

(Sorry for my poor english)

[mdaems]

Gaspo,

Thanks for reporting, but this doesn't really tell us much. Can you please teel us more?
We need to know at least the database you use, the table structures and the sql statements in the TQuery and TSQLUpdate.

To avoid we forget about this post you should file a bug report at http://zeosbugs.firmos.at/ . When you're busy there, please attach a sample project including a database creation script. Binary programs are not necessary.

Mark