Helen,


Helen Borrie schrieb:

>
> At 11:38 AM 13-03-02 +0100, Lucas Franzen wrote:
>
> >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...
>
> No, Luc, I don't think so! Here is IBO monitor output:

I didn't include it.

I just had a cursor like:

SELECT * FROM MYTABLE

There was no join, nothing special about it.

>
> fwiw, I don't recall it *ever* being valid syntax to include the table
> identifier in the column list of an INSERT statement...

All I did was:

with myCursor do
begin
INSERT;
SetSomeFields;
POST;
end;

When having a look at the Monitor output the tablename was added in the
generated insert-statement. I didn't do so.

As stated in the IBO group I'm still at 4.2Eg, maybe the problem is gone
with the current version.

And I just tried that statement WITH the tablenames on RC2 (via
IBConsole) where it worked.

Luc.