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

16 Feb 2007 8:42 AM

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.

16 Feb 2007 12:03 PM

Earl

Hint: primary keys.

<olympus_m***@gmx.de> wrote in message
Show quote

news:1171615324.310199.56340@q2g2000cwa.googlegroups.com...
> 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.
>

16 Feb 2007 2:15 PM

olympus_mons

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

Show quote

On 16 Feb., 13:03, "Earl" <briks...@newsgroups.nospam> wrote:
> Hint: primary keys.
>
> <olympus_m***@gmx.de> wrote in message
>
> news:1171615324.310199.56340@q2g2000cwa.googlegroups.com...
>
>
>
> > 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.- Zitierten Text ausblenden -
>
> - Zitierten Text anzeigen -