How to transactions with Cursoradapters and ms sql

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to transactions with Cursoradapters and ms sql

Message

20/11/2006 11:57:46

Vojislav Cvejic
SPL
Novi Sad, Serbia

20/11/2006 01:07:44

Aleksey Tsingauz
Microsoft
Seattle, Washington, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Client/serveur

Titre:

Re: How to transactions with Cursoradapters and ms sql

Versions des environnements

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

MS SQL Server

Divers

Thread ID:

01171075

Message ID:

01171210

Vues:

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.

Répondre

Fil

Voir

Click here to load this message in the networking platform