Hi all,

How does TRANSACTIONS work? Is this the correct usage for updating a parent/child data?

* Buffering = 5

select vw_parent
update vw_parent set parentdata = "Parent" where pkfld = 1

select vw_child
for i = 1 to 5
update vw_child set dtldata = sys(2007,transform(i)) && sample data
where fkfld = 1 and childline = i

begin transaction
  select vw_child
  if !tableupdate(.t.,.t.)
     rollback
  else
     select vw_parent
     if !tableupdate(.t.,.t.)
        rollback && vw_parent
        select vw_child
        rollback && is this necessary?
     endif
  endif
end transaction