Hello, Paulo!
You wrote to <IBObjects@yahoogroups.com> on Tue, 8 Jan 2002 10:10:47 -0300:

PHA> I modify the field CODCLI from 10 to 1 and apply to update.

PHA> UPDATE CADCLI
PHA> SET CODEMP = ? /* CODEMP */
PHA> , CODCLI = ? /* CODCLI */
PHA> , NOMCLI = ? /* NOMCLI */
PHA> , DATA = ? /* DATA */
PHA> , CODGRU = ? /* CODGRU */
PHA> WHERE CADCLI.CODCLI = ? /* OLD.CODCLI */
PHA> AND CADCLI.CODEMP = ? /* OLD.CODEMP */

This is text of trigger? As I see - not. If not - you should use OLD and NEW
values ONLY in triggers... In client-side SQL it`s don`t work correctly...

WBR, Dmitry Beloshistov AKA [-=BDS=-]
e-mail: torin@...