When it changes the value of the primary key IBO does not update the record.

Example:

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

SQL Monitor:

/*---
[ 08/01/2002 10:03:07 ]
PREPARE STATEMENT
TR_HANDLE = 14893916
STMT_HANDLE = 14893988

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

PLAN (CADCLI INDEX (RDB$PRIMARY29))

/*---
[ 08/01/2002 10:03:10 ]
EXECUTE STATEMENT
TR_HANDLE = 14893916
STMT_HANDLE = 14893988

PARAMS = [ Version 1 SQLd 7 SQLn 7
[CODEMP] = 4
[CODCLI] = 1
[NOMCLI] = 'Teste'
[DATA] = <NULL>
[CODGRU] = <NULL>

OLD.[CODCLI] = 1 =====> It should be 10 and not 1, OldValue is 10.

OLD.[CODEMP] = 4 ]
----*/
/*---

IBO 4.2.Fn
Delphi 6
Windows 2000 Professional
FireBird Beta2

PHA
Nova Odessa / SP - Brazil



[Non-text portions of this message have been removed]