Subject Re: [ib-support] FB 1 and INSERT INTO
Author Jason Wharton
I have been aware of this for a couple of days and already have it fixed and
am just needing to make a new sub-release. I plan to do so later today.

The quick fix in the IBO code is very simple. Here it is:

In the file IBA_UpdateSQL.IMP there is the place where it generates the SQL
for doing inserts. (Search for INSERT INTO and look above that. Around line
530.) There is a string variable 'ss' that is storing the text for the
columns in the list. It is using the table name and a period prefixing the
column name. Simply remove the two places where it is doing this. The
property being read for the table name is RelName.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


"Lucas Franzen" <luc@...> wrote in message
news:3C8F2C20.6F415F83@......
>
> Hello,
>
> thanks to everyone who was involved in releasing the final 1.
>
>
>
> I don't like to post the following one,
> but I've got a big problem with insert statements.
>
> Until now it was legal to have statements like:
>
> INSERT INTO MYTABLE ( MYTABLE.MY_ID, MYTABLE.MY_INTEGER )
> VALUES ( 1, 2 );
>
> Now this won't work unless I omit the MYTABLE in front of the
> fieldnames.
>
> Unfortunately the table name is added automatically by (for example)
> IBO...
>
>
> Luc.