>I would like to learn the primary key value of successful SQL Insert command. The following syntax was
>picked up from (I think) a reliable source, cannot recall where. It generates an error at 'Output'.
>Could you please show me the correct syntax.
>
>'Insert into table( column set ) Values(value set)' Output inserted.pkImage

Assuming pkImage is the field name of the primary key:

Insert into table( column set ) Values(value set) returning pkImage

See http://www.firebirdsql.org/refdocs/langrefupd21-insert.html for definition.

HTH,
Set