| Subject | Multiple Rows in Singleton Select |
|---|---|
| Author | george.elton197 |
| Post date | 2010-02-24T16:40:19Z |
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?
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?