Re: mySQL and primary key

2023-04-30 Thread Monte Goulding via use-livecode
If you can connect remotely to the server then try using MySQL workbench (available from Oracle) if not then you will need to SSH to the server, login to mysql on command line and do it there. > On 29 Apr 2023, at 9:40 pm, jbv via use-livecode > wrote: > > Hi list, > > I have a mySQL table w

RE: mySQL and primary key

2023-04-30 Thread Ralph DiMola via use-livecode
JBV, This looks like a server timeout. There is a mySQL server ini file parameter "ExecTimeLimit" There is also a phpMyAdmin ini file "LoginCookieValidity" timeout parameter. If you can't get those changed(especially "ExecTimeLimit" so you can do it by script) you will be forced to create a new ta

Re: mySQL and primary key

2023-04-30 Thread Mike Kerner via use-livecode
is this a local table? the 504 sounds like you're connecting via an api On Sat, Apr 29, 2023 at 7:41 AM jbv via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi list, > > I have a mySQL table with 1350 entries that weights > almost 20 Gb. > I need to create a primary key on the "id"

Re: Creating 'read only' text files

2023-04-30 Thread Paul Dupuis via use-livecode
I don't know of a Livecode syntax per se to do this (i.e some syntax like: set the permissions of file tFile to read-only) You can do this in Livecode using the shell() function (see the dictionary) to issue applicable mac or win command lines. For eample a Google search shows the command line

Re: Weird window behavior

2023-04-30 Thread David V Glasgow via use-livecode
Only just catching up with this (been walking in Scotland)… Probably not tremendously informative now, but I’m not using Levure, I am using backdrop, and on Ventura. I’ll check the state of RaiseWindows when I can - would it be expected to change depending on backdrop use? Best Wishes, David

Creating 'read only' text files

2023-04-30 Thread David V Glasgow via use-livecode
Hi folks, Really simple question that I can’t see having been asked before, so here goes… I have a stack that outputs small text files. Each includes a hash value referencing part of itself that can be checked subsequently, so any change to the text can be flagged. Is there a way I can easi