November 24th, 2012, 03:19 PM
Singleton query has multiple rows
This error is preventing display of results of my select query. Has some setting changed on my system? Not aware of this response in the past.
November 24th, 2012, 04:44 PM
You forgot to post the error message.
Where do you receive error ? e.g. which application is running the code?
November 24th, 2012, 07:29 PM
Singleton Query has Multiple Rows
Sorry I'm still quite new to this forum. Posted a summary of the error message in subject of this thread.
Running IB_SQL: interface to Firebird database. When query result is a single row, all is well. But if the result contains more than one row, I get the following message:
ISC ERROR CODE 335544652
ISC ERROR MESSAGE:
multiple rows in singleton select
Is there a way to get all rows in this situation, without generating the error?
November 24th, 2012, 09:38 PM
Doing a search on google for the error code, I found the comment below which may be helpful:
Originally Posted by http://tech.groups.yahoo.com/group/firebird-support/message/39878