HOWTO: generate update/delete command using data adapter wizzard?

  • Thread starter Thread starter olympus_mons
  • Start date Start date
O

olympus_mons

Hi,

I'm just beginning my VS.NET 2005 adventure in C#, so maybe I'm
missing something obvious...

I created a dataset containing 3 tables, one "main" table and two
lookup tables connected by a relation to the main table. Only for one
of the lookup tables the wizzard generated update and delete commands.
For the others only the select and insert commands are generated. Even
when I right-click these tables adapters, choose "configure" and step
through the wizzard with option "generate insert, update, delete
statements" under "Advanced options" set, after clicking "Finish" I
still have no update and delete.

So why does it work for one of the lookup tables but not for the other
two in my dataset?
Any hint for me?

TIA,
Stefan

P.S.: my backend DB is Oracle10g i case this is important. I have VS-
SP1 installed on my WinXP machine.
 
Earl,

yes, just found a hint in another newsgroup. I had a primary key index
defined, but not a primary key constraint. This is why it worked for
one of the lookup tables. I have to tweak ERwin to generate the
correct DDL script.

Thanks anyway,
Stefan
 
Back
Top