Add Query / Add Data Source wizard won't generate Update() query

[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?

 

[Guest]

Forgot to mention, I am using VS 2005 and SQLEXPRESS..

 

[Cor Ligthert [MVP]]

Va,

I had this when I had temporaly installed VB6, do you have this installed?

(I am not sure anymore if that was the reason but after that I deinstalled
that the update was created)

Cor

 

[Guest]

When you say VB6 I assume yyou mean the development environment. I don't
have VB6 installed. I do have .NET 2.0 only, C#, etc..