Hi,

> Daniel Rail,

> ----- Original Message -----
> From: "Daniel Rail" <daniel@...>

>> 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)

> Do you have code on triggers of CLIENTS, updating others tables?
> If yes, I would give a look them.

Thanks. I didn't thought of that. I'll take a look.

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