Ok John where gos a sample
this code will be put in a method of a object in the click of a button etc..
it only works if you are using tables belonging to a vfp database
LOCAL llret, locustomer, loaccount
locustomer = CREATEOBJECT(«your customer object»)
loaccount = CREATEOBJECT(«your account object»)
BEGIN TRANSACTION
llret = locustomer.Add(custID, custname)
llret = llret AND loaccount.Add(custid)
IF llret
END TRANSACTION
ELSE
ROOLBACK
ENDIF
Alexandre Palma
Senior Application Architect