Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Begin transaction & sqlsetprop(handle,transactions,2)
Message
From
24/02/2004 12:58:59
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
To
24/02/2004 12:47:14
Suhas Hegde
Dental Surgeon
Sirsi, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Begin transaction & sqlsetprop(handle,transactions,2)
Miscellaneous
Thread ID:
00880173
Message ID:
00880371
Views:
32
This message has been marked as a message which has helped to the initial question of the thread.
Until VFPT not fix this bug,
( read my other message, and Aleksey VFPT member comment )
you must to use:
Sqlsetprop(m.han,"transactions",1)
SqlEXEC(m.han,"Begin Transaction")
SqlEXEC(m.han,"IF @@trancount > 0 COMMIT")
SqlEXEC(m.han,"IF @@trancount > 0 ROLLBACK")
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform