Data Adapter Wizard problem!!

[Mike Lambert]

I have a table with a row set as UniqueIdentifier, RowGuid = Yes, and the
row is set as the primary key, but when I try to use the Data Adapter Wizard
it give me an error that it can't create the Update and Delete command
because it can not determine unique columns in the table. If a create a
test table with a column set the same way it work fine. How can the wizard
have a hard time determining a unique column when the primary key is
set?????

Thanks,
Mike

 

[Guest]

Does your SELECT statement retrieve the primary key? All the other statements are based on the SELECT Statement so that if you are not selecting the primary key (frequently done when it has no inherent meaning) the generation of the update statements can't use it to identify each row

Also, if you include it in you SELECT Statement to get around this problem, you may encounter a problem wherein the wizard tries to gen a statement that wants to update the primary key (I am getting that problem with Timestamp).