Hi,

if you wanna mix SPT and Remote View updates in one transaction,
you can use this

USE your_remote_view IN 0 CONNSTRING poSqlConn
REPLACE someField IN your_remoteview
IF SQLEXEC(poSqlConn,'UPDATE someTable SET ....') = 1 AND ;
   TABLEUPDATE(.T.,.F.,'your_remote_view')
   SQLCOMMIT(poSqlConn)
ELSE
   SQLROLLBACK(poSqlConn)  
ENDIF

The connection must be created with the shareable flag set in SQLCONNECT()/SQLSTRINGCONNECT() function.

Regards
Christian