Oh BTW I use autoincrement on all my tables for the primary key. 

Bob S


> On Oct 9, 2018, at 14:50 , Bob Sneidar <bobsnei...@iotecdigital.com> 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 your code where you expect to update, and it's inserting 
> instead. 
> 
> I wrap my database commands in a series of commands and functions, all of 
> which put the current user name (I have a login system in place) and the 
> datetime the update was made. Something like that might help you determine 
> when the updates were made. 
> 
> Bob S
> 
> 
>> On Oct 9, 2018, at 14:13 , jbv via use-livecode 
>> <use-livecode@lists.runrev.com> wrote:
>> 
>> 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 140000 entries.
>> I have searched the web for more info and have found a few posts on
>> stackoverflow and some other blogs mentioning problems with autoincrement,
>> but the symptoms are slightly different...
>> I was wondering if anyone had experienced similar issues ?
>> 
>> Thanks in advance.
>> Best,
>> jbv
> 


_______________________________________________
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

Reply via email to