Subject | Re: [ib-support] FB 1 and INSERT INTO |
---|---|
Author | Jason Wharton |
Post date | 2002-03-13T16:51:15Z |
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@......
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.