Hi!

Forget to tell that you require to use sqlsetprop ( connobj.handle, “TRANSACTIONS”, 1 ) to use these T-SQL commands. What don't work? Didi you received error messages, or just got more than one transaction level? You can see how many levels of transaction are opened using @@TRANCOUNT SQL Server variable. To commit all levels of transactions at once (both opened by you and VFP automatically), you can run following script by SQLEXEC():

WHILE @@TRANCOUNT > 0
BEGIN
  COMMIT TRANSACTION
END

HTH.


>Thanks Vlad!!!
>
>The problem was there are several different handles. I modify my database to define that the remote views use the same handle (advanced options), and correct with this code:
>
>handl = sqlgetprop ( "connecthandle", "vpredios" )
>sqlsetprop ( handl, "transactions", 2 )
>..
>
>Also, i try the use of the TSQL instructions "BEGIN TRANSACTION", "COMMIT TRANSACTION" and "ROLLBACK TRANSACTION" but don't work!!!.