Hi,

For the following two transactions and the initial table values as shown complete the missing blanks in the transaction log below:

Part_ID	Desrption	OnHand	OnOrder
57	Assembled Foo	5	0
987	Foo Fastener	12	7
989	Foo Half	7	0

BEGIN TRANSACTION;

UPDATE Part SET OnHand = OnHand + 7, OnOrder = OnOrder 7 WHERE Part_ID = 987;

COMMIT;

BEGIN TRANSACTION;

UPDATE Part SET OnHand = OnHand - 4 WHERE Part_ID = 987;

UPDATE Part SET OnHand = OnHand - 2 WHERE Part_ID = 989;

UPDATE Part SET OnHand = OnHand + 1 WHERE Part_ID = 57;

COMMIT

TRL_ID	TRX_ID	PREV_PTR	NEXT_PTR	OPERATION	TABLE	ROW ID	ATTRIBUTE	BEFORE VALUE	AFTER VALUE
1787	109	NULL		START	****
1788	109	1787		UPDATE	PART	987	OnHand	12
1789	109			UPDATE	PART	987	OnOrder	7
1790	109		NULL	COMMIT	****
1791	110	NULL		START	****