Hi.
I have a program that updates/inserts a bunch of records. At the beginning
I
Selec table1
Begin transaction
if !tableupdate()
failflag = .T.
endif
Selec table2
scan for table2.key = table1.key
if !tableupdate(.t.,.t.)
failflag = .T.
endif
if not failflag
change stuff
insert into table 3
insert another record into table 3
endif
endscan
IF failflag
ROLLBACK
revert ...
else
end transaction
endif

My problem is that the second insert into table 3 happens then rolls back or reverts because once the whole transaction is done, I only have one record.
I am using row buffering. So my question is how do I use row buffering and use INSERT-SQL....

THanks for the help

Sandi Cassidy