SelectCommand that does not return any key column information

[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

[Val Mazur]

Hi,

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

--
Val Mazur
Microsoft MVP
"Shenc" <sh***@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl...

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

[Shenc]

Found the problem. Here is the link in case any one interested.

http://support.microsoft.com/?id=329794

ShenC

--

"Val Mazur" <gr******@hotmail.com> wrote in message
news:#I*************@tk2msftngp13.phx.gbl...

Hi,

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

--
Val Mazur
Microsoft MVP
"Shenc" <sh***@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl...

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