>Hi all
>
>Can you suggest me how to issue the "BEGIN TRANSACTION" and "END TRANSACTION" using VFP 7.0 SQL Passthrough functions. How do I ensure that the transactions are safe and secure
>
>Thanks
>
>Raoshan

hi Raoshan,

Something like

sqlexec(han,"begin transaction")
sqlexec(han,"select * from .....","mycursor")
Select Mycursor
browse && make changes
* make the cursor updatable
if Tableupdate(2,.t.,"mycursor")
sqlexec(han,"IF trancount > 0 Commit")
else
*trap error
sqlexec(han,"IF trancount > 0 Rollback")
tablerevert("mycursor")
endif


HTHs
suhashegde