How To Wrap Remote Views into One SQL Transaction

MORE INFORMATION

Step-by-Step Example

1. Create a connection to your back end data and name it Myconnection.
2. Create two updateable remote views named Myview1 and Myview2.
3. Make the views share the connection by modifying the remote view. From the Query menu choose Advanced Options. This displays a dialog box that contains the Shared Connection check box. Select the check box and click OK.
4. In the Command window or in code issue the following commands:

         USE Myview1
         USE Myview2 in 0
         m.Handle = CursorGetProp('ConnectHandle','Myview1')
         =SQLSETPROP(m.Handle,'Transaction',2)
   							

   This code gets the connection handle from the cursor and sets the Transaction property to two (2), which is manual mode. This mode allows you to use the SQLCOMMIT or SQLROLLBACK functions.
5. Modify some data in the views and issue the following code:

         =Tableupdate(1,.t.,'Myview1')
         =Tableupdate(1,.t.,'Myview2')
         =SQLCommit(m.Handle)
         =Requery('Myview1')
         =Requery('Myview2')
   							

   You can replace the SQLCommit with SQLRollback and see the data go back to its original value.