Subject Re: [firebird-support] Multiple Rows in Singleton Select
Author Milan Babuskov
Alan McDonald wrote:
>> 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.
> it'snot the insert statement, it's the re-query which is causing you an
> issue.

Or, most probably, there is some BEFORE INSERT or AFTER INSERT trigger
that does some select which produces the error.

Milan Babuskov

The easiest way to import XML, CSV
and textual files into Firebird: