Variants with same handle
Open Database DataDB Shared
SELECT 0
USE KingsReal!vwRemoteview
lhX = CURSORGETPROP("ConnectHandle",'vwRemoteview')
SQLSETPROP(lhX,"Transactions", 1) && tried 2 as well
SQLSETPROP(lhX,"DisconnectRollback", .t.) && tried w/o this line
CURSORSETPROP("Buffering",5,"vwRemoteview")
BROW
BEGIN TRANSACTION
SQLExec(lhX, 'BEGIN TRANSACTION')
llRetVal = TABLEUPDATE( .T., .T., "vwRemoteview")
SQLExec(lhX, 'ROLLBACK')
ROLLBACK
CLOSE TABLES ALL
SQLDISCONNECT(0)
____________________________________
*** or
Open Database DataDB Shared
lhX = SQLCONNECT('Connect1')
Open Database DataDB Shared
SELECT 0
USE KingsReal!vwRemoteview Use testdbc!empl CONNSTRING lhX
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.