Subject Re: [firebird-support] Multiple Rows in Singleton Select
Author Lester Caine
george.elton197 wrote:
> Can anyone suggest what I may have done wrong?
> Firebird 1.5
> I'm using a SQL insert into a table which returns the error 'multiple rows in singleton select'.
> The table has a primary key, the values being inserted are unique.
> I am formatting the SQL statement for use via an IBObjects Query and the debugger shows a valid statement prior to the ExecSQL() statement.
> There are no duplicate entries in the table and I'm confused.
> To make matters worse, the code used to work fine so I'm leaning towards a database problem. Does anyone have any thoughts?

Copy of the SQL may be of help ....

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Firebird -