I would like to change an existing program that uses several insert into and replace commands. Application is written for VFP 7, SDT 6.1, ,used private datasessions, uses optomistic buffering, is multi-user and runs on a novell server. General structure is

insert into ...
insert into ...
if rlock(.)
replace ...
endif

It has no error checking and what I which I want to add. After reading documentation I am not sure of best way to di this. Can I use begin end transcaction to encampulate the transactions, can I use tableupate to check if insert worked, etc.

Any suggestion appreciated. TIA