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:
http://www.guacosoft.com/xmlwizard
==================================