Are database transactions supported?

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
NancyM
Pro Scripter
Posts: 66
Joined: Mon Jul 18, 2016 7:01 pm

Are database transactions supported?

Post by NancyM » Fri Oct 07, 2016 9:54 pm

I'm looking a doing something with record locking and it looks like they recommend using transaction versus auto-commits. Just curious if that is supported in any form?

User avatar
Marcus Tettmar
Site Admin
Posts: 7395
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: Are database transactions supported?

Post by Marcus Tettmar » Mon Oct 10, 2016 10:41 am

I guess this would depend on the ODBC driver you are using. Macro Scheduler's database functions are little more than conduits. They allow you to make a connection using your chosen driver, and then pass SQL statements through. It's the driver that decides how these are handled, not Macro Scheduler.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts