G
Guest
I have a simple child table whose integer ID column contains the primary key
of its parent table - nothing unusual. While the Select, Insert and Update
will be generated with "Add Data Source" for the paarent table, only the
Select and Insert will be generated for the child table.
Even in the dataset designer, if I manually click on the child table and
select "Add Query", the wizard will setup a select or insert statement
complele with all fields and parameters - but it won't fill out or generate
anything for an update except the first command word "UPDATE" .
What prevents the wizard from generating an Update statement for a table?
of its parent table - nothing unusual. While the Select, Insert and Update
will be generated with "Add Data Source" for the paarent table, only the
Select and Insert will be generated for the child table.
Even in the dataset designer, if I manually click on the child table and
select "Add Query", the wizard will setup a select or insert statement
complele with all fields and parameters - but it won't fill out or generate
anything for an update except the first command word "UPDATE" .
What prevents the wizard from generating an Update statement for a table?