SelectCommand that does not return any key column information

S

Shenc

I am using the CommandBuilder to auto-build the insert/update/delete
commands. My select command is very simple like "Select * From MyTable".
where MyTable is a synonym created for a real table Owner.MyTable in an
Oracle DB. But I got an runtime error when it comes to any of the
GetUpdateCommand or GetDeleteCommand:

Dynamic SQL generation for the UpdateCommand is not supported against a
SelectCommand that does not return any key column information

I have checked Owner.MyTable, it does have a primary key defined. So I am
confused. I was wondering if any body has any suggestion on this. Maybe it's
the problem of synonym that when select will not return any key column info.
help..

ShenC
 
V

Val Mazur

Hi,

What kind of database are you using? What is your code, which generates that
error?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic SQL generation - How do I set the key column information manually? 2
Writing Update Back to SQL Server 2
can't generate update command 1
Problem deleting data from SQL table. 2
Dynamic SQL generation is not supported against a SelectCommand that does not return any base table 2
DataAdapter fails to update the server database 9
Dynamic SQL generation for the UpdateCommand is not supported ... 5
Updating Datagridview 7

Top