> 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.

I was able to see this error in the embedded version of Firebird 2.0.

The error appears to be a bug in the Firebird engine because there was
absolutely nothing wrong with the SQL statement being attempted. It seems
that adding in the clause WHERE CURRENT OF is what triggered the problem.

Since this works in Firebird 2.5 it is safe to assume that it has been
fixed. This leaves me not knowing what to do here. I could possibly detect
the 2.0 version of Firebird and omit putting on the alias qualifiers and see
if that helps.

Stay tuned.

Jason