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 ?

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" wrote:

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

I've got a primary key for sure.

"DotNetJerome" <reachjerome@_yahoo.com-remove-the-underscore-after@> a écrit dans le message de news: 18F6BE3A-7F0D-4A80-AAAC-(E-Mail Removed)...
> 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" wrote:
>
>> 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 ?
>>

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


"Oriane" <(E-Mail Removed)> a écrit dans le message de news: (E-Mail 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 ?