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!

Eamonn (newbie)