Hello Jason,

Using 4.2Ea

Created same table

CREATE TABLE TEST (
A INTEGER NOT NULL
, b INTEGER
, c INTEGER
, d INTEGER
,
PRIMARY KEY ( A )
)

Created a TIBOTable, TIBOQuery and TIB_Query

for each of the IB Objects

1. Emptied table TEST
2. Appended a record
3. TESTA.Value := 1; or equivalent method for the object
4. TEST.POST

5. TEST.Edit
6 TESTA.Value := 2;
7. TEST.Post;

All some on step 6 or simular

EXECUTE STATEMENT
TR_HANDLE = 32876440
STMT_HANDLE = 32871040
PARAMS = [ Version 1 SQLd 5 SQLn 5
TEST.A = 2
TEST.B = <NULL>
TEST.C = <NULL>
TEST.D = <NULL>
TEST.A[OLD_A] = 1 ]

Does this mean a single field update, results in an update of the
entire Row? For some reason I thought TIB_Query only issued
an update for Field A in prior versions.

How can I force the internal generation of a SQL update for
the changed/updated fields only ?

Best Regards,
Hans