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

Luiz.