Is the column in SQL Server set as the primary key or is it just unique? The CommandBuilder requires the primary key to be set.
>Hi !
>
>I Create a simple data form using SqlDataAdapter to connect to the users table.
>
>It works if I connect to the users table itself - Great BUT...
>
>If I do the same to connect to a view of the table I get the following error message when configuring the dataAdapter:
>
>Generated UPDATE statement.
>Could not determine which columns uniquely identify the rows for "v_AB6_IPs"
>
>Generated DELETE statement.
>Could not determine which columns uniquely identify the rows for "v_AB6_IPs"
>
>Very simple View select which DOES include the primary key !
>
>The primary key is the UserID, it is unique and does NOT allow Null values.
>
>Are views not audatable this way ?
>
>Thanks,
>
>Pierre
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi