At 06:11 AM 1/03/2003 -0400, you wrote:

>Hi,
>
>This problem is puzzling me. I'm using FB 1.0 Windows. And, I'm only
>getting this problem with one of my client's database.
>
>The error message is:
>"Multiple rows in singleton select"
>
>And, here's the puzzling statement, that is generating the error:
>UPDATE CLIENTS
>SET GARANTOR_NO=CLIENTNO,
> GUARANTOR_SELF='T'
>WHERE (GUARANTOR_SELF IS NULL)
> OR (GARANTOR_NO IS NULL)
> OR (GARANTOR_NO<1)
>
>Any insight to the problem would be appreciated.

Does this happen to be an EditSQL statement associated with a dataset
(cached or not)?

heLen