Configuration of DataAdapter

[Oriane]

Hi,

When configuring a simple "Client" Sql table sqlDataAdapter, with one single primary key, I can't generate the Delete and Update command, although the Insert and Select command are generated.

The message is (translated from french...) : Impossible to determine the columns identifying uniquely the rows for "Client".

I don't understand

some ideas ?

 

[Guest]

Hi,

Usually the message would appear incase, if there is no primary key present
in the connected table. Make sure you've a primary key for your table.

Cheers,

Jerome. M

 

[Oriane]

I've got a primary key for sure.

Hi,

Usually the message would appear incase, if there is no primary key present
in the connected table. Make sure you've a primary key for your table.

Cheers,

Jerome. M

 

[Oriane]

I had to re-create the table from scratch, and ... it works again.


"Oriane" <[email protected]> a écrit dans le message de news: (e-mail address removed)...
Hi,

When configuring a simple "Client" Sql table sqlDataAdapter, with one single primary key, I can't generate the Delete and Update command, although the Insert and Select command are generated.

The message is (translated from french...) : Impossible to determine the columns identifying uniquely the rows for "Client".

I don't understand

some ideas ?