Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automatic Transactions ????
Message
From
31/03/2005 11:02:59
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
31/03/2005 04:13:21
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MySQL
Miscellaneous
Thread ID:
00999687
Message ID:
01000351
Views:
30
>Hello Cetin !
>
>I found the solution myself !
>Immediately after connecting with sqlstringconnect at the beginning of my application i did
> =SQLSETPROP(connectnr,"Transactions",2)
>and now the unwanted "autocommit" behavior of the exe is stopped.
>
>Nevertheless thank you for your hints
>Best regards
>Albert

Oh my, you didn't set it to manual! Then be carefull about the bug (IOW I suggest not to use manual and explcitly use 'begin/commit/rollback tran').
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform