Hello,

we are having a problem with our database application. We are trying to
build an update command with
commandbuilder, and we get the error

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

The command we use is:

Dim _cmdb As Odbc.OdbcCommandBuilder = New
Odbc.OdbcCommandBuilder(m_adapter)
m_adapter.UpdateCommand = _cmdb.GetUpdateCommand

The adapters select command is a very simple "select customer_no, name from
customer;"

If I run the version 5.5 database through the ASA9 engine, and use ASA9 ODBC
connection, everything is fine. The tables all have key columns, but
for some tables it work, and for some tables it does not.

Can anyone help me?

Alf Kato

I don't believe that the v5.5 ODBC Driver (which will be celebrating it's
10th birthday this year in September) was ODBC 3.0 compliant, which is
probably why you are running into problems. I would suggest using an ODBC
driver that was compiled in this millennium to get around your problem.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


"Alf Kato Brandal" <alf (AT) satpool (DOT) no> wrote