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 sever
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 in
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 function
