On Tue, Dec 13, 2016 at 8:18 AM, Bob Sneidar <bobsnei...@iotecdigital.com> wrote: > That is odd. I recently did that very thing. I started a transaction and then > ran multiple updates in a repeat loop, then committed the transaction. Seemed > like all the data ended up in the tables. > That sounds like you did NOT do the very same thing. If you used a repeat loop it sounds like you were firing off updates one after the other - lets say 100 updates were handled as 100 executions. The good Dr is talking about COMPOUNDING all those 100 update statements into a single LC revExecuteSQL statement and firing just one off. This works for SQLite and postgreSQL but not mySQL.
Back to your original question; I've used both Navicat and Valentina Studio (free version) with success. Years ago Valentina was less stable and so I'd use Navicat if things went a bit flakey, but these days I find the Valentina UI more intuitive and screen space efficient so rarely every start up Navicat. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode