> Jason;
>
> I have uploaded a test project to the files area of this group. File name
> is ibotest.zip.
>
> If you run this using FB 2.1.3 on Windows 7 it works. If you run it using
> FB2.0.? on Linux (version reported by IB_SQL = LI-V6.3.5.13206 Firebird
> 2.0) it will fail.
>
> To run the project you will have to change the server and path properties
> of the TIB_Connection to point to the place where you put the test
> database on your system, compile the project and run it. First click the
> Insert button. Then click the update button. It will fail when you click
> Update.

What I found that I can safely do is avoid putting a relation alias on the
statement when it is the same as the table name. It really serves no useful
purpose and it triggers this bug in Firebird 2.0.

So, it used to submit this to the server:

UPDATE CT_GRID_COLUMNS CT_GRID_COLUMNS
SET CT_GRID_COLUMNS.CGC_USER_ID = ? /* CGC_USER_ID */
, CT_GRID_COLUMNS.CGC_GRID_NAME = ? /* CGC_GRID_NAME */
, CT_GRID_COLUMNS.CGC_COLUMN_PROPERTIES = ? /* CGC_COLUMN_PROPERTIES */
WHERE CURRENT OF C1965632087517113

Now it will submit this to the server:

UPDATE CT_GRID_COLUMNS
SET CT_GRID_COLUMNS.CGC_USER_ID = ? /* CGC_USER_ID */
, CT_GRID_COLUMNS.CGC_GRID_NAME = ? /* CGC_GRID_NAME */
, CT_GRID_COLUMNS.CGC_COLUMN_PROPERTIES = ? /* CGC_COLUMN_PROPERTIES */
WHERE CURRENT OF C1965632087517113


So, as of the next version of IBO, this problem will be safely avoided.

Thanks for your help in getting this situation resolved.

Jason