At 08:57 PM 25/02/2003 +0000, you wrote:

>Hi,
>
>getting a weird error message when trying to insert using
>TIBOQuery. The message is 'Invalid INSERT statement: No columns'.
>
>SQL is:
>
>select "PIN", "NAME"
>from "FORMS"
>where "PIN" = :PIN
>
>KeyLinks is set to "FORMS".PIN and the code is basicaly this:
>
>query.insert
><set fields>
>query.post - error here
>
>i've used this approach before on my last project and it worked
>well. the only difference this time is that this table has a couple
>of BLOB fields, and i've just upgraded to firebird 1.0.2 from 1.0
>
>any suggestions greatly appreciated!

It looks as if you might be getting bitten somewhere by your quoted
identifiers. Your keylinks would need to be "FORMS"."PIN"

What's the code you are using for your <set fields>?

As for what else might or might not be happening, drop a TIB_MonitorDialog
onto your form, call its Show method in your FormCreate, and watch what
statement is going through to the API when Post is called on the Insert.

Helen