There is a primary key on the table and I have asked the driver
creator. I just thought someone here may have run into a similar
situation.


Christoph

--- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> Hi,
>
> > I am having trouble in Microsoft Visual Studio.NET with a VB.NET
> > program connecting to FireBase with the XTG ODBC driver.
> >
> > I can connect and read ok with the latest beta version but if I
try and
> > update a recordset I get the following error:
> >
> > Dynamic SQL generation for the UpdateCommand is not supported
against a
> > SelectCommand that does not return any key column information.
>
> Seems like you don't have a primary key or unique constraint at the
table...
>
> Right?
>
> (if not, ask the creators of the driver)
>
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase
> http://www.upscene.com
>
> Firebird Workbench - the developer tool for Firebird
> http://www.upscene.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."