mysqlDataAdapter Preview Data error during Update.

mysqlDataAdapter Preview Data error during Update.

Postby AceEmbler » Wed 09 Aug 2006 09:51

When i change some data in DataAdapter Preview Data.
(I can add data but cennot modify)
and press Update
I have got this error.
"Dynamic SQL generation for UpdateCommand in not supported against a SelectCommand that does not return any key column information"

Can you please explain this to me ?? Is this problem somehow similar to my previous post with exceptions during updating changes made to datagrid ??
AceEmbler
 
Posts: 26
Joined: Fri 04 Aug 2006 09:45

Postby AceEmbler » Wed 09 Aug 2006 10:23

I didn't have primary key in my table .
AceEmbler
 
Posts: 26
Joined: Fri 04 Aug 2006 09:45

Postby Serious » Wed 09 Aug 2006 11:35

Open MySqlDataAdapter editor, go to "Generator" tab page, press "Get Table Fields", then select all items in "Key Fields" listbox. Then press "Generate Commands". INSERT/UPDATE/DELETE commands will be generated to handle table without key columns.
Serious
 


Return to dotConnect for MySQL