Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RollBack transaction doesn't work
Message
From
24/11/2009 08:52:50
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01436291
Message ID:
01436309
Views:
62
AError funtion do not get anithing


>You're not checking if any statement is executed correctly on SQL Server. Maybe "BEGIN TRANSACTION" failed.
>
>>
>>From VFP i'm persisting data into SQLServer, but roolback transaction dont work
>>
>>
>>objConexao.executar("BEGIN TRANSACTION")
>>objConexao.executar("Update TableName set fieldname = 11 where fieldkey = 289880")
>>objConexao.executar("ROLLBACK TRANSACTION") && dont work - in SQLServer fieldname was updated to 11
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform