General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem with buffering and tableupdate
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only