Hello,

I've got some problems with FB 1 and _some_ IB_Queries / IB_Cursors.
Some of them refuse to work, ie I can't post any data with them.

I do always get the SQL-error -104 (ISC ...44569) and it's always
"Token unknown, line 2 char xx '.'", no matter what the Query/Cursor's
trying to Post.



The database was rebuilt from the scratch.

Inserting from IBConsole or another app is working okay. IB_Monitor
doesn't show anything unusual.

The only thing I found out is:

the generated SQL looks like:

INSERT INTO MYTABLE
( MYTABLE.MY_ID
, MYTABLE.MY_INTEGER)
VALUES
( 1 /* MYTABLE.MY_ID */
, 2 /* MYTABLE.MY_INTEGER */ )

this statement fails.


If I change it to:

INSERT INTO MYTABLE
( MY_ID
, MY_INTEGER)
VALUES
( 1
, 2 )

it works okay.

So the problem seems to be the table alias.



Anyone else out there having a similar problem - and even better any
solution?

IBO 4.2Eg, mybe it's outdated???


Luc.