Subject Re: [IBO] Multiple rows / singleton select with IBOTable
Author Helen Borrie
At 02:02 PM 6/07/2004 +0000, you wrote:
>We have a weird problem that is only occuring with a IBOTable
>component. The Firebird 1.5 database is EMPTY. When we try to open
>a certain table from the database, we receive the following
>error : "Multiple rows in singleton select". Problem is, there are
>no records in that table. Afterwards we found out that it depends
>from GDB to GDB. Some is giving that error, others don't. We are
>using the latest version from IBO.

Two possibilities I can think of:
1) You have some COMPUTED BY column that is derived from a subquery that is
not scalar (a COMPUTED BY column must be able to return one and only one value)
2) You have the wrong firebird.msg file (check version numbers on the
property sheet against server version. If this is the case, then you do
have an error condition in the table, but not *that* error condition.

NB Make sure you check the *.msg files on clients as well.