Think this is the problem, will mail you after solving the problem
thanks once again
prasanna
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 06:08 AM 26/05/2004 +0000, you wrote:
> >Hi all,
> >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.
>
> It's the right-hand side of a complete message that reads "Multiple

records

> 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