>
> 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?
>

it'snot the insert statement, it's the re-query which is causing you an
issue.
Use the SQL monitor in IBO to see what the attempted re-query is.
Alan