>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
