Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to transactions with Cursoradapters and ms sql
Message
From
20/11/2006 11:57:46
Vojislav Cvejic
SPL
Novi Sad, Serbia
 
 
To
20/11/2006 01:07:44
Aleksey Tsingauz
Microsoft
Seattle, Washington, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Re: How to transactions with Cursoradapters and ms sql
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01171075
Message ID:
01171210
Views:
6
Hi Aleksey,

I have (example):
...
SQLSETPROP(nrucka , 'Transactions', 2) && manual
IF TXNLEVEL() < 5
BEGIN TRANSACTION
ENDIF
lcSQLStr = 'BEGIN TRANSACTION'
SqlExec( nrucka,lcSQLStr)

lok = TABLEUPDATE() && lok = .t.

SqlRollback(nrucka)
ROLLBACK

That's not working.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform