General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only