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.
>
> This sounds like an issue in regard to how Firebird handles statements. It's
> rather awkward for me to be swapping versions of Firebird on my current
> system. I wonder if you would do a test for me and see if it is submitting
> the exact same statement to each different version or if IBO produces a
> different statement depending on the version of server it is connecting to.

You can easily run several Firebird instances side-by-side as an
application. The client application then simply needs to provide the
proper port information in the connect string to connect to right instance.

Regards,
Thomas