| Subject | Re: [firebird-support] s in single select |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-05-26T06:24:50Z |
At 06:08 AM 26/05/2004 +0000, you wrote:
in singleton select". It means you used a SELECT statement that required a
single value or a single-row set but it actually returned multiple rows.
Typically, you will get this when you are using a subquery to obtain an
output field, and the subquery can not return a unique value. You will
also get it when you try to perform a positioned update or delete using a
WHERE clause that can not identify a unique target row.
/heLen
>Hi all,It's the right-hand side of a complete message that reads "Multiple records
>I am working on a web application project with c# and using Firebird.
>I am getting a message saying "s in Singleton Select" in a particular
>field and no other error message is thrown.
>Help would be useful and appreciated.
in singleton select". It means you used a SELECT statement that required a
single value or a single-row set but it actually returned multiple rows.
Typically, you will get this when you are using a subquery to obtain an
output field, and the subquery can not return a unique value. You will
also get it when you try to perform a positioned update or delete using a
WHERE clause that can not identify a unique target row.
/heLen