Hi all

Can you suggest me how to issue the "BEGIN TRANSACTION" and "END TRANSACTION" using Visual FoxPro 7.0 SQL Passthrough functions. How do I ensure that the transactions are safe and secure

Thanks

Raoshan


Use SQL manual transaction within the VFP transaction:

BEGIN TRAN && open vfp TRANSACTION
IF SQLEXEC(,'BEGIN TRAN;write command;COMMIT')>0
    END TRAN
ELSE
     IF SQLEXEC(,'ROLLBACK')<1
        * panic
     ENDIF
     ROLLBACK
END