Re: Paste no closeField

It only works with fields whose name begins with "fld" (damn you spell correct!) Bob S > On Mar 10, 2022, at 14:53 , Bob Sneidar via use-livecode > wrote: > > It only works with fields whose name begins with "old" ___ use-livecode mailing list us

Paste no closeField

hi all. I have been seeing that when pasting text into a field then exiting the field, closeField is not getting sent to that field. Here are a couple handlers for your frontScript to deal with that. It only works with fields whose name begins with "old" otherwise this would trigger the script

Re: use-livecode Digest, Vol 222, Issue 8

jacqui jawed, > filter tHugeDict without regex pattern "[qkxyz]” I expect that would be faster. But it will also bring words that are too long, although I have no idea whether or not there would be enough to matter. ___ use-livecode mailing list u

Re: revOpenDatabase over SSH tunnel?

Danke. ;) > Am 10.03.2022 um 23:00 schrieb Niggemann, Bernd via use-livecode > : > > There are two sentences in german: > > Folgenden Befehl in der Kommandozeile des Win10 PCs ausführen: > > Run the following command on the command line of the Win10 PC: > > > > Bei dem „Vordergrund“ Befeh

Re: revOpenDatabase over SSH tunnel?

There are two sentences in german: Folgenden Befehl in der Kommandozeile des Win10 PCs ausführen: Run the following command on the command line of the Win10 PC: Bei dem „Vordergrund“ Befehl, sieht man nur einen blinkenden Cursor. Bei dem „Hintergrund“ Befehl erscheint ein neuer Prompt. With

Re: revOpenDatabase over SSH tunnel?

Here's a link to the english version of the instructions. If you find wrong expression or wrong grammar please let me know, so i can fix it. https://dl.qck.nu/?dl=SSH_Port_Forwarding.pdf Regards, Matthias > Am 10.03.2022 um 16:51 schrieb matthi

Re: Speed up a slow loop

On 3/9/22 5:09 PM, Alex Tweedly via use-livecode wrote:  - you can reuse the same tile later in a word (e.g. Y  L  A X  E  T would allow "lately" as a word. OR - you can double-up on a tile (e.g. M I L would allow 'mill') (more important if you're British than if you're American :-) That's

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

On 3/10/22 08:26, Ben Rubinstein via use-livecode wrote: Thanks Panos, that gave me the clues I needed to get the other ones as well. Can confirm the app is now running on Ubuntu 18.04.2 LTS. Wow... woke up to a lot of emails this morning. I'm running the latest LC builds on the latest linux

Re: use-livecode Digest, Vol 222, Issue 8

On 3/9/22 3:42 PM, doc hawk via use-livecode wrote: Something like ^[manl]\{2,5\}$ which matches all strings of length 2 to 5 composed exclusively of the letters m, a, n, & l ? I want to eliminate all words contains any of the letters in the group. I didn't get confirmation that my regex i

Re: revOpenDatabase over SSH tunnel?

bob blipped, > Livecode currently can only send one statement per query to *any* sql server, > at least that is what I have come to understand. Trust me, I send a single transaction of several hundred SELECT every time I open a debtor “file”. Not being able to do updates as a block, though,

Re: revOpenDatabase over SSH tunnel?

I do not think this is a mySQL issue. Livecode currently can only send one statement per query to *any* sql server, at least that is what I have come to understand. But I do not think issuing many queries from livecode is the bottleneck, but rather the ability of the SQL server to respond. When

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

Gosh, I never got *any* version of 6 to work well enough to use! :) There’s still switches in my code for 5, but there are enough other uses of later features of 7+ that it’s a non-issue. ___ use-livecode mailing list use-livecode@lists.runrev.com Pl

Re: revOpenDatabase over SSH tunnel?

I dropped mysql after the first run with my software—I don’t know if mysql could have handled it at the time, but LiveCode could only send a single command per transaction (afaik, this is still the case). And with several hundred transactions to start a session . . . (there were also issues abo

Re: revOpenDatabase over SSH tunnel?

This is very interesting. My issue with mySQL is that I am running on a Windows 7 box, and there is no support for SSH in the Oracle version (or there wasn't last time I checked.) There *are* builds that do support it, but the weeds in that swamp are thick, and after several days of trying to ge

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

(P.S. I already employ new features or syntax only supported in v9.x and up, but that means maintaining a small bit of branched 6/9 code. Like to move beyond that eventually, but no rush; whatever people need!) Best wishes, Curry K. === Richmond: What do you mean when you write "I'm still

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

Richmond: > What do you mean when you write "I'm still supporting LC 6.7"? Bob: > I believe he means that utilities he creates will still function > when used with 6.7, but wouldn't if he employs new features > or syntax only supported in v9.x and up. Correct! "I'm still supporting LC 6.7" for

Re: revOpenDatabase over SSH tunnel?

You are right. You invoke the SSH in a terminal on that machine that shall communicate with the MySQL database on a remote server. LC then connects to itself (127.0.01) using the port you've used in the command for ssh connection, in my example 6102. That's it. As more and more servers do not

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

Aha. Thick types like me need things to be made explicit. Richmond. On Thu, 10 Mar 2022, 20:51 Bob Sneidar via use-livecode, < use-livecode@lists.runrev.com> wrote: > I believe he means that utilities he creates will still function when used > with 6.7, but wouldn't if he employs new features or

revOpenDatabase - ODBC - on Ubuntu - failing with empty error

Thanks to everyone who's responded to my woes over the last few days. I'm making progress, but have hit a new hurdle. I know have the LC-built app running in a Docker container on Ubuntu 18. It's set up with an ODBC connection to an Oracle database. I can test the connection on the command l

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

I believe he means that utilities he creates will still function when used with 6.7, but wouldn't if he employs new features or syntax only supported in v9.x and up. Eventually he would consider ONLY supporting 9.x and up, and wants to get an idea of how many people would still need 6.7 support.

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

What do you mean when you write "I'm still supporting LC 6.7"? On 10.03.22 20:25, Curry Kenworthy via use-livecode wrote: To plan addon development for the next few years, I would like to know if some people still need LC 6.7. If you're a Lurker, that's OK! If shy: offlist is fine. (Regulars w

Re: [ANN] SpreadLib ordering is back online

Bob: > I'm really looking forward to this update Curry. > I have a current need for parsing excel spreadsheets. Thanks, I'm excited about this one too! Best wishes, Curry Kenworthy SpreadLib: Excel files to LC fields in 1 script line! "Excel-lent spreadsheet import and export for LiveCode"

Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

To plan addon development for the next few years, I would like to know if some people still need LC 6.7. If you're a Lurker, that's OK! If shy: offlist is fine. (Regulars welcome too, of course.) Currently I'm still supporting LC 6.7 too, but as LC 9 matures on bugs/stability and performance,

Re: What version of Ubuntu does LiveCode (9.6.6) support?

To record an answer to my own question, for completeness: it appears that standalones built from LiveCode 9.6.6, at least, seems to work fine on Ubuntu 18.04.2 LTS, at least. You may need to install some additional libraries. Phew! Ben On 10/03/2022 15:29, Ben Rubinstein via use-livecode wrot

Re: What version of Ubuntu does LiveCode (9.6.6) support?

Here's a few observations: https://forums.livecode.com/viewtopic.php?f=20&t=36784 Best, Richmond. On 10.03.22 17:29, Ben Rubinstein via use-livecode wrote: Just read the release notes (for 9.6.6, but also for 10.0.0.dp2) which say LiveCode supports the following Linux distributions, on 32-

Re: revOpenDatabase over SSH tunnel?

Yes, my case is that the database is on a hosted platform which only supports access over SSH. My reading of your document, Matthias, is that we simply invoke SSH in a terminal, and then LiveCode/revOpenDatabase uses that tunnel automatically because the database host is at the same address. C

Re: [ANN] SpreadLib ordering is back online

I'm really looking forward to this update Curry. I have a current need for parsing excel spreadsheets. Bob S > On Mar 9, 2022, at 12:53 , Curry Kenworthy via use-livecode > wrote: > > > The SpreadLib order page is back up: > > http://livecodeaddons.com/spreadlib.html > http://livecodeaddo

Re: LC and SqlLite Question

As mentioned, only for reads, only one for write. But why not create a server agent that is responsible for handling multiple connections from clients, and the server agent can be the single connection to the sqLite database? Bob S > On Mar 10, 2022, at 08:34 , Paul Dupuis via use-livecode >

Re: revOpenDatabase over SSH tunnel?

Yes, the server agent part resides on the same device that the SQL Server is on. The server agent communicates directly with the SQL server, and is responsible for making and storing connection specifics. The client agent can request a list of connections from the server agent when it connects t

Re: LC and SqlLite Question

And finally. https://sqlite.org/wal.html On Thu, Mar 10, 2022 at 11:55 AM Tom Glod wrote: > sorry about the double paste. :) > > On Thu, Mar 10, 2022 at 11:54 AM Tom Glod wrote: > >> For writing its only ever 1, but it can have multiple readers if you use >> the write ahead log . >> >> PRAG

Re: LC and SqlLite Question

sorry about the double paste. :) On Thu, Mar 10, 2022 at 11:54 AM Tom Glod wrote: > For writing its only ever 1, but it can have multiple readers if you use > the write ahead log . > > PRAGMA journal_mode=WAL; > > run that when creating database.never tested, but based on documentation. > n

Re: LC and SqlLite Question

For writing its only ever 1, but it can have multiple readers if you use the write ahead log . PRAGMA journal_mode=WAL; run that when creating database.never tested, but based on documentation. never tested, but based on documentation. let me know if you test it successfully. On Thu, Mar 10

Re: revOpenDatabase over SSH tunnel?

There is nothing wrong with your method. But there might be situations where you need direct access to the MySQL database, e.g. you are using 3rd party software (in my case SQLPro Studio) or libraries. I have a customer who is using a special Delphi library that only supports direct connections.

Re: revOpenDatabase over SSH tunnel?

Google translate is pretty capable and can do whole web pages. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com On March 10, 2022 9:54:47 AM Ben Rubinstein via use-livecode wrote: Hi Matthias, That is (a) good news and (b) very kind!

LC and SqlLite Question

Can a sqlLite database file on disk be accessed by more than 1 LiveCode app at the same time? A server hosted mySql database can be accessed by any number of client LC apps at the same time as the serve side mySql does the record locking necessary, but what about a sqlLite file? Obviously, I

Re: revOpenDatabase over SSH tunnel?

Great, thank you. Ben On 10/03/2022 16:07, matthias rebbe via use-livecode wrote: Ben, i've sent it to you. If there are questions regarding macOS, just ask. I will post a link to the updated english version here in the list. Regards, Matthias Am 10.03.2022 um 16:52 schrieb Ben Rubinstein

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

Thanks Panos, that gave me the clues I needed to get the other ones as well. Can confirm the app is now running on Ubuntu 18.04.2 LTS. Thanks again, Ben On 10/03/2022 16:03, panagiotis m via use-livecode wrote: Hello Ben, For libfreetype, I think you should do: sudo apt-get install libfreet

Re: revOpenDatabase over SSH tunnel?

I am not sure what SSH tunneling is, but I did a proof of concept where I had an LC client app communicating with an LC server app that encrypted the data at the client end before sending it, and the server end decrypted it. I just used non-secured sockets. I used AES encryption with a key only

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

Might be worth trying this as well: sudo apt-get install libexpat1 Cheers, Panos On Thu, 10 Mar 2022 at 18:03, panagiotis m wrote: > Hello Ben, > > For libfreetype, I think you should do: > > sudo apt-get install libfreetype6-dev > > Also, yes, the "official" supported Ubuntu distros for LC a

Re: revOpenDatabase over SSH tunnel?

Ben, i've sent it to you. If there are questions regarding macOS, just ask. I will post a link to the updated english version here in the list. Regards, Matthias > Am 10.03.2022 um 16:52 schrieb Ben Rubinstein via use-livecode > : > > Hi Matthias, > > That is (a) good news and (b) very kind

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

Hello Ben, For libfreetype, I think you should do: sudo apt-get install libfreetype6-dev Also, yes, the "official" supported Ubuntu distros for LC are 14 and 16 LTS. However, LC standalones built from 9.6.6 should run on Ubuntu 18 and above as well. Tomorrow I'll try to set up an Ubuntu 18 VM a

Re: revOpenDatabase over SSH tunnel?

Hi Matthias, That is (a) good news and (b) very kind! Or if it's easier, I have a German colleague - less technical skills, but excellent language skills - if you sent me the guide in German, I could ask her to have a go at translating it. (I'd still be very interested in the macOS additional

Re: revOpenDatabase over SSH tunnel?

Yes of course. I will post a link to it here in the list. If time allows i will also create a Livecode Lesson. Matthias > Am 10.03.2022 um 16:45 schrieb Glen Bojsza via use-livecode > : > > I would be interested in this guide if possible. > > Will you be willing to share? > > regards, > > G

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

Thanks Panos. I'd just got part of the way there from your comment on this https://quality.livecode.com/show_bug.cgi?id=23163 report. (I'm a complete Linux noob.) So now I know about 'ldd' I was able to execute: # ldd CB304 linux-vdso.so.1 (0x7ffed1b36000) libdl.so.2 => /lib/x8

Re: revOpenDatabase over SSH tunnel?

I would be interested in this guide if possible. Will you be willing to share? regards, Glen On Thu, Mar 10, 2022 at 10:32 AM matthias rebbe via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi, > > I've used SSH tunneling in the past to connect SQLPro Studio with remote > MySQL datab

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

Hello all, I think libexpat.so.1 is a system lib required by LC apps, so it might be worth installing it. I have not done any research, but I would expect that it would be enough to do something like: sudo apt-get install expat or sudo apt-get install libexpat Kind regards, Panos On Thu, 10

Re: revOpenDatabase over SSH tunnel?

Hi, I've used SSH tunneling in the past to connect SQLPro Studio with remote MySQL databases, but never with LC. And although i was pretty sure that it will work with LC, i just did a quick test with LC to be 100 percent sure. Yes it's possible. I have created a small quick start guide for W

What version of Ubuntu does LiveCode (9.6.6) support?

Just read the release notes (for 9.6.6, but also for 10.0.0.dp2) which say LiveCode supports the following Linux distributions, on 32-bit or 64-bit Intel/AMD or compatible processors: Ubuntu 14.04 and 16.04 Fedora 23 & 24 Debian 7 (Wheezy) and 8 (Jessie) [server] CentO

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

Hi Stephen, Built on Mac. I didn't zip it because I've got a folder shared with the Docker container, so I just dragged it in. But sensing something behind your question... I just zipped up the original build folder, dragged that in, and then in the shell unzipped it, invoked that binary...

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

Hi Ben, Did you make the standalone on mac or win and zip the file before uploading ? -- Stephen Barncard - Sebastopol Ca. USA - mixstream.org On Thu, Mar 10, 2022 at 6:50 AM Ben Rubinstein via use-livecode < use-livecode@lists.runrev.com> wrote: > > I'm trying to develop an app which will run

Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

I'm trying to develop an app which will run headless on Linux (actually in a docker container). I've done this before... so long ago that I can't remember... with an earlier version of this app. Normally I run this on Mac and Windows. So (under LiveCode 9.6.6) I simply checked the Linux 64

revOpenDatabase over SSH tunnel?

I need to access a (MySQL) database on a remote service - which has to be done over an SSH tunnel. Has anyone done this in LiveCode? Is it trivial/possible/impossible? TIA, Ben ___ use-livecode mailing list use-livecode@lists.runrev.com Please vi