Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RollBack transaction doesn't work
Message
De
24/11/2009 08:52:50
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01436291
Message ID:
01436309
Vues:
66
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
>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform