| Subject | Re: [IBO] Multiple rows / singleton select with IBOTable |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-07-06T22:28:10Z |
At 02:02 PM 6/07/2004 +0000, you wrote:
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.
Helen
>Hi,Two possibilities I can think of:
>
>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.
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.
Helen