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 - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php