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
IF SQLEXEC(,'BEGIN TRAN;write command;COMMIT')>0
END TRAN
ELSE
IF SQLEXEC(,'ROLLBACK')<1
ENDIF
ROLLBACK
END