Re: Quick IDE question

2020-04-29 Thread dunbarx--- via use-livecode
Can you explicitly set the rect of the SE? I do this all the time because I have it located on a large vertically oriented monitor adjacent to my main screen, and the loc needs to be refreshed now and then depending on other stuff I use them for. Craig -Original Message- From: Graham

Re: Quick IDE question

2020-04-29 Thread Martin Koob via use-livecode
Hi Graham Try this in the message box set the rect of stack "revNewScriptEditor 1" to the screenrect; set the height of stack "revNewScriptEditor 1" to 750 Regards, Martin Koob > On Apr 29, 2020, at 9:11 AM, Graham Samuel via use-livecode > wrote: > > Since yesterday, running

Livecode HTML5 and SQL

2020-04-29 Thread Colin Kelly via use-livecode
Anyone got any insightful ways of READING/WRITING to a mySQL table using web-apps developed with Livecode HTML5? Thanks Col. -- Colin Kelly M 07951 920680 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url

Re: Best relational database for IOS / Android

2020-04-29 Thread doc hawk via use-livecode
Rick rejoined, > I have a preference for PostgreSQL. I recoded for Postgres from mysql a few years ago simply because, at the time at least, livecode can send a compound transaction to Postgres, and only single transactions to mysql. ___

Best relational database for IOS / Android

2020-04-29 Thread Skip Kimpel via use-livecode
Good morning, In your opinion, what is the best relational database to use for an IOS / Android application? Being a PC guy and always living in the Microsoft world, I always default to SQL, however, with my latest discoveries of the complexities involved and lack of support in LC I don't think

Re: Best relational database for IOS / Android

2020-04-29 Thread Mike Kerner via use-livecode
do you mean for c/s? if it's client-only, then sqlite and mysql are perfectly integrated into lc for ios. On Wed, Apr 29, 2020 at 9:55 AM Skip Kimpel via use-livecode < use-livecode@lists.runrev.com> wrote: > Good morning, > > In your opinion, what is the best relational database to use for an

RE: Best relational database for IOS / Android

2020-04-29 Thread Ralph DiMola via use-livecode
For a DB local on the device I use SQLite and it holds up well with very complex multi table queries. For a remote database I have had no problems with MySQL and it's open source brother MariaDB. Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -Original

Quick IDE question

2020-04-29 Thread Graham Samuel via use-livecode
Since yesterday, running either LC 9.5.1 or 9.6.0 dp4 on a Mac, every time I open the Script Editor window, it overfills my screen, so I can’t see the bottom of the window. There are no decorations, so I can’t resize or minimise the window; and dragging the window by the title bar doesn’t work

RE: Best relational database for IOS / Android

2020-04-29 Thread Clarence Martin via use-livecode
You may want to explore LiveCloud. It is a cloud based database by Canela Software that allows for both cloud and Local- to the device- database. http://canelasoftware.com/ I am developing and testing for a while. -Original Message- From: use-livecode On Behalf Of Skip Kimpel via

Re: Quick IDE question

2020-04-29 Thread Martin Koob via use-livecode
Hi Craig The script editor is a stack just like any other so what you can do to a stack you can do to it. To find the name of it you can type the following into the Message Box: put the openstacks That will show a list in the message box of all the stacks open including the stack you are

Re: Best relational database for IOS / Android

2020-04-29 Thread Rick Harrison via use-livecode
Hi Skip, I have a preference for PostgreSQL. https://www.postgresql.org Free - MIT-License, Open-source, and it works really well with LC. Good luck! Rick > On Apr 29, 2020, at 9:54 AM, Skip Kimpel via use-livecode > wrote: > > Good morning, > > In your

Re: Livecode HTML5 and SQL

2020-04-29 Thread Devin Asay via use-livecode
Colin, I haven’t tried it myself, but I would think you’d have to write an API layer using LiveCode Server scripting. All of the MySQL reads and writes would take place in your .lc scripts on LC Server. Then it would be simple, RESTful http calls from your HTML5 app. Of course, this all

Re: Livecode HTML5 and SQL

2020-04-29 Thread Devin Asay via use-livecode
That’s good to know, Matthias. So it seems that what you’d have to do is, still do the MySQL I/O in LC Server scripts, but also dynamically construct the HTML output in your LC server scripts, so that the calling HTML5 app could make sense of it. Am I interpreting the situation correctly,

Re: Livecode HTML5 and SQL

2020-04-29 Thread matthias rebbe via use-livecode
If "post... to url" and "put URL..." would work, then it should work with HTLM5. But currently only load URL is supported. But to be true, i am not sure about "load URL.." I´ve used load URL only for downloading files in the past. I am not sure if the command can also be used with

Re: Livecode HTML5 and SQL

2020-04-29 Thread matthias rebbe via use-livecode
I have to correct myself. The script works when i call an url that is on the same server as the html5 app is called from. And more important parameters can also be used. And as Sean already posted about a HTML5 library, it´s possible to use an HTML5 app with an api layer using LC Server or PHP

Re: Best relational database for IOS / Android

2020-04-29 Thread Rick Harrison via use-livecode
Nice! > On Apr 29, 2020, at 12:15 PM, doc hawk via use-livecode > wrote: > > I recoded for Postgres from mysql a few years ago simply because, at the time > at least, livecode can send a compound transaction to Postgres, and only > single transactions to mysql.

Re: Quick IDE question

2020-04-29 Thread Martin Koob via use-livecode
Hi Graham Glad it worked. Getting the decorations and dragability back is just a matter of getting the stack rect within the rect of the screen. LiveCode IDE parts sometimes get a mind of their own and set out a wanderin’ — who knows why. Setting their loc to the screenloc will put them

Re: Livecode HTML5 and SQL

2020-04-29 Thread Pi Digital via use-livecode
Hi Colin I have a library I’ve created for HTML5 and php for LiveCode Deployment. Pm me at s...@pidigital.co.uk Sean Cole Pi Digital Productions Ltd eMail Ts & Cs > On 29 Apr 2020, at 20:00, matthias rebbe via use-livecode > wrote: > > If "post... to url" and "put URL..." would work,

Re: Best relational database for IOS / Android

2020-04-29 Thread Alex Tweedly via use-livecode
Livecloud is indeed from Canela Software - but there's no obvious link from their own website for it. Go straight to livecloud.io to get the info about it. It does require Indy or above LC license Alex. On 29/04/2020 15:06, Clarence Martin via use-livecode wrote: You may want to explore

Corona Virus app idea

2020-04-29 Thread William Prothero via use-livecode
Folks: I had an idea for a Corona Virus app that Livecode is perfect for, and which could be coded up fairly quickly. I don’t have the time for doing it, but offer this idea just in case someone on the list wants a project for this. The idea is to solve the problem that is now being created as

Spell Checker

2020-04-29 Thread Trevor DeVore via use-livecode
Hi folks, FYI I've published a Github repo with a spell checker. The code is code I've been developing for a spell checker replacement in apps I develop for macOS and Windows. It uses NSSpellChecker on macOS and Hunspell on Windows. If some kind soul wants to compile a Hunspell 1.6.2 .so library

Google Drive or Dropbox integration

2020-04-29 Thread David Bovill via use-livecode
I’m looking to create some tools to automate / augment the work of volunteers working on the Sound Garden media archive we created for the radio station. I want to create desktop and mobile apps I can distribute to volunteers as the project moves forwards. At this early stage we have both

Re: Best relational database for IOS / Android

2020-04-29 Thread doc hawk via use-livecode
Rick remanded, > Nice! Not just nice, but necessary for consistency—if I have a variable change which also causes two more to change, it is absolutely critical that either all three change, or that the whole thing fail. You just can’t do that without begin/end, AFAIK, unless you have a

Re: Livecode HTML5 and SQL

2020-04-29 Thread matthias rebbe via use-livecode
I was also thinking about using LC Server or PHP scripts, but if i understand it correctly then "put URL" or "POST.. to URL" aren't currently supported in the LC HTML5 engine. Only "load URL" is supported and only for http / https. Matthias - Matthias Rebbe Life Is Too Short For Boring Code

Re: Quick IDE question

2020-04-29 Thread Graham Samuel via use-livecode
Stone the crows, it worked!! Even the decorations came back, and the ability to drag the window - neither of which are obviously related to the rect or height of the stack, as far as I can see. Thanks so much Martin. I wonder how just the Script Editor got so out of whack - but it’s just a

Re: Three very simple questions

2020-04-29 Thread Graham Samuel via use-livecode
OK, I’ll bite - how d’ya do it? Graham > On 28 Apr 2020, at 22:28, dunbarx--- via use-livecode > wrote: > > The user guide? > It certainly is searchable. I do it all the time. > Craig > > > -Original Message- > From: Graham Samuel via use-livecode > To: How to use LiveCode > Cc:

Re: Wildcard? replaceText, offset?

2020-04-29 Thread Ben Rubinstein via use-livecode
Not sure what 'previous post' referred to. Reg ex "[0-9]+" (or equivalently "\d+") would match one or more integers. Provided this is the first/only instance of the pattern, I would have thought that regex does provide the neatest solution, e.g.: put "(" & iNewNumber ")" into