That is very curious. I am running mySQL 5.6 not sure the minor version. I use
autoinc in all my tables without difficulty, but I also use sqlYoga, so I do
not craft the actual queries.
Bob S
> On Nov 28, 2018, at 24:58 , jbv via use-livecode
> wrote:
>
> I've been watching & checking the
Hi list,
This is a quick follow-up to my post from a couple of months ago.
After weeks of tweeking and testing, I am now 99.99% sure there's
an issue with auto-increment in the latest versions of mySQL, at
least with large tables with several indexes and complex scripts
that insert and update
Oh BTW I use autoincrement on all my tables for the primary key.
Bob S
> On Oct 9, 2018, at 14:50 , Bob Sneidar wrote:
>
> I use mySQL 5.6 running on a Windows server. I do not have this issue. The
> only way LC will add a record is with the insert command. I suspect there is
> someplace
I use mySQL 5.6 running on a Windows server. I do not have this issue. The only
way LC will add a record is with the insert command. I suspect there is
someplace in your code where you expect to update, and it's inserting instead.
I wrap my database commands in a series of commands and
Hi list,
I'm not 100% sure yet, but I think I'm experiencing some problems with
mySQL 5.6.41 and LC server, the most annoying one being random duplicate
entries in some tables, especially the biggest ones, for instance 71 Mb
and nearly 14 entries.
I have searched the web for more info and have