Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Begin transaction & sqlsetprop(handle,transactions,2)
Message
From
24/02/2004 13:20:41
Bob Archer
Tampa, Florida, United States
 
 
To
24/02/2004 12:32:48
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:
00880381
Views:
33
>

>Sqlsetprop(han,"transactions",2)
>if tableupdate(2,.t.,"abc") and tableupdate(2,.t.,"xzy") && first returned .t. and second .f.
>** Now manually disconnect to test .
>SQLdisconnect(han)

You have NO call to SQLRollBack() here! If a table update fails you have to rollback. That's what "MANUAL" transactions means. I think the disconnect is doing a commit.

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform