DataAdaptor Bug!

[marcmc]

When I configure the dataAdaptor i get "Could not determine which columns
uniquely identify the rows for TableName" and so the update and delete
statements are not built.

[Chris]

Re: DataAdaptor Bug!

marcmc wrote:[color=blue]
> When I configure the dataAdaptor i get "Could not determine which columns
> uniquely identify the rows for TableName" and so the update and delete
> statements are not built.[/color]

Do you have a primary key set?

Chris

[Kerry Moorman]

RE: DataAdaptor Bug!

marcmc,

Does the table have a primary key defined?

Kerry Moorman


"marcmc" wrote:
[color=blue]
> When I configure the dataAdaptor i get "Could not determine which columns
> uniquely identify the rows for TableName" and so the update and delete
> statements are not built.[/color]

[Cor Ligthert [MVP]]

Re: DataAdaptor Bug!

Marc,

What do you mean by bug, is that to let the Microsoft people not look
anymore to these messages. You hide now real bugs with your message. So
please write only about a bug when you sure it is.

I will spare you how most active persons in this newsgroup call your
question.

Cor

"marcmc" <marcmc@discuss ions.microsoft. com> schreef in bericht
news:0825DCB0-D219-4EAC-BF96-B3864D7BB5D2@mi crosoft.com...[color=blue]
> When I configure the dataAdaptor i get "Could not determine which columns
> uniquely identify the rows for TableName" and so the update and delete
> statements are not built.[/color]

[marcmc]

RE: DataAdaptor Bug!

yep and a unique clustered index

[marcmc]

RE: DataAdaptor Bug!

i dropped the unique clustered index and now the message is "There were
errors configuring the data adapter."

[marcmc]

Re: DataAdaptor Issue!

Cor,
I apologise if I have broken any of the guidelines or rules regarding my post.
I have changed the title to DataAdaptor Issue.
I'll be honest I was hoping that the title would encourage more people to
look at it.
I've been using Microsoft.publi c on a number of different technologies for
many years and am unaware of any rule about this. Maybe you can clarify? Is
it a known issue? Is there a recommendation to solve?

[marcmc]

Re: DataAdaptor Issue!

anyway, does anyone know how to solve this?

[coen]

Re: DataAdaptor Issue!


marcmc wrote:[color=blue]
> anyway, does anyone know how to solve this?[/color]

I also think you must configure your DATABASE to have a primary key.

[Cor Ligthert [MVP]]

Re: DataAdaptor Issue!

Most likely is the key not a part of your select statement.

Cor

"marcmc" <marcmc@discuss ions.microsoft. com> schreef in bericht
news:BBC8EC13-D856-4478-B6B7-A6DF0C16E2A7@mi crosoft.com...[color=blue]
> anyway, does anyone know how to solve this?
>[/color]