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.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)