Hello Matthias, Macbook Pro with LC 9.5, Catalina, Acrobat DC, pdf on browser widget works in developer mode. Not tested as standalone.
Richard. > Message: 6 > Date: Tue, 14 Jan 2020 18:56:43 +0100 > From: matthias_livecode_150...@m-r-d.de > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: FYI: Cause found for LC crashing to desktop when Browser > widget opens PDF > Message-ID: <2f2113ee-3f78-4219-9e79-622023264...@m-r-d.de> > Content-Type: text/plain; charset=utf-8 > > Hi, > > maybe this is of use for the one or the other. > in any case LC crashes on Mac to desktop when opening a PDF in the Browser > Widget and your are getting crazy because of that, then check if Acrobat > software is installed on your system. > > ... > Matthias > > > > > > > ------------------------------ > > Message: 7 > Date: Tue, 14 Jan 2020 18:00:06 +0000 > From: Bob Sneidar <bobsnei...@iotecdigital.com> > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: SQL(ite) question > Message-ID: <daf1e6dd-a1cd-4d92-95c9-6f898e18e...@iotecdigital.com> > Content-Type: text/plain; charset="utf-8" > > The only problem I see here is that it is possible to get a match with the > last part of one column and the first part of the next, especially with > numerical data, which would be a false positive. > > Bob S > > >> On Jan 14, 2020, at 01:15 , Klaus major-k via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> Hi Sean, >> >>>> Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode >>>> <use-livecode@lists.runrev.com>: >>> >>> Even easier: >>> >>> SELECT * FROM MyTable WHERE ((col1+col2+aCol1+aCol2) LIKE >>> ?%mysearchtermhere%?) >> >> aha, thank you very much, I had no idea this is possible! :-) >> >>> Sean Cole >>> Pi Digital Prod Ltd >>> >>>>> On 13 Jan 2020, at 23:03, Bob Sneidar via use-livecode >>>>> <use-livecode@lists.runrev.com> wrote: >>>> ?Actually I do this all the time. >>>> SELECT * from MyTable where >>>> COLUMN1 like "%mysearchtermhere%" OR >>>> COLUMN2 like "%mysearchtermhere%" OR >>>> COLUMN3 like "%mysearchtermhere%" >>>> I loop through a list of columns I want to search to build the query. >>>> >>>> Bob S >>>> >> > > > ------------------------------ > > Message: 8 > Date: Tue, 14 Jan 2020 18:04:03 +0000 > From: Bob Sneidar <bobsnei...@iotecdigital.com> > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: Embarrasssing old bugs > Message-ID: <844bd184-2c38-4b85-aa78-61f878d7b...@iotecdigital.com> > Content-Type: text/plain; charset="us-ascii" > > This is why I always convert dates to what I call SQL datetime (YY:MM:DD > HH:MM:SS). For display purposes I format as needed. Not sure this would help > on an Android though. > > Bob S > > >> On Jan 14, 2020, at 09:55 , Klaus major-k via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> And now I have to tell him that after 5 (FIVE!) years we still do not have >> "system date" etc. on Android!? >> <https://quality.livecode.com/show_bug.cgi?id=11726> >> As a result we cannot e.g. sort a datagrid by "sytem datetime" etc. > > > > > ------------------------------ > > Message: 9 > Date: Tue, 14 Jan 2020 19:05:29 +0100 > From: Klaus major-k <kl...@major-k.de> > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: SQL(ite) question > Message-ID: <b3cd9b41-2afa-4926-a2d5-3acbf6be9...@major-k.de> > Content-Type: text/plain; charset=utf-8 > > Hi Bob, > >> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode >> <use-livecode@lists.runrev.com>: >> >> The only problem I see here is that it is possible to get a match with the >> last part of one column and the first part of the next, especially with >> numerical data, which would be a false positive. > > AHA, so SQL treats this: > ... WHERE ((col1+col2+aCol1+aCol2) ...) > > Like this in LC: > ... WHERE ((col1 & col2 & aCol1 &aCol2) ...) > ? > >> Bob S >> ... >>>> Even easier: >>>> SELECT * FROM MyTable WHERE ((col1+col2+aCol1+aCol2) LIKE >>>> ?%mysearchtermhere%?) >>> aha, thank you very much, I had no idea this is possible! :-) >>>> Sean Cole >>>> Pi Digital Prod Ltd >>>>>> On 13 Jan 2020, at 23:03, Bob Sneidar via use-livecode >>>>>> <use-livecode@lists.runrev.com> wrote: >>>>> ?Actually I do this all the time. >>>>> SELECT * from MyTable where >>>>> COLUMN1 like "%mysearchtermhere%" OR >>>>> COLUMN2 like "%mysearchtermhere%" OR >>>>> COLUMN3 like "%mysearchtermhere%" >>>>> I loop through a list of columns I want to search to build the query. > > Best > > Klaus > > -- > Klaus Major > https://www.major-k.de > kl...@major-k.de > > > > > ------------------------------ > > Message: 10 > Date: Tue, 14 Jan 2020 18:07:03 +0000 > From: Bob Sneidar <bobsnei...@iotecdigital.com> > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: SQL(ite) question > Message-ID: <4c4cb887-daf8-432c-a82c-19d9e06f9...@iotecdigital.com> > Content-Type: text/plain; charset="us-ascii" > > Pretty sure + means concatenate, otherwise that SQL statement would not work > in any I can imagine. > > Bob S > > >> On Jan 14, 2020, at 10:05 , Klaus major-k via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> Hi Bob, >> >>>> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode >>>> <use-livecode@lists.runrev.com>: >>> >>> The only problem I see here is that it is possible to get a match with the >>> last part of one column and the first part of the next, especially with >>> numerical data, which would be a false positive. >> >> AHA, so SQL treats this: >> ... WHERE ((col1+col2+aCol1+aCol2) ...) >> >> Like this in LC: >> ... WHERE ((col1 & col2 & aCol1 &aCol2) ...) >> ? >> >>> Bob S > > > > > ------------------------------ > > Message: 11 > Date: Tue, 14 Jan 2020 19:07:59 +0100 > From: Klaus major-k <kl...@major-k.de> > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: Embarrasssing old bugs > Message-ID: <939d4592-643b-4ee2-979c-dab965573...@major-k.de> > Content-Type: text/plain; charset=us-ascii > > Hi Bob, > >> Am 14.01.2020 um 19:04 schrieb Bob Sneidar via use-livecode >> <use-livecode@lists.runrev.com>: >> This is why I always convert dates to what I call SQL datetime (YY:MM:DD >> HH:MM:SS). For display purposes I format as needed. > > sure, that's what we do in the moment, but something like this is not easily > worked around: > -> As a result we cannot e.g. sort a datagrid by "sytem datetime" etc. > >> Not sure this would help on an Android though. > > Not really. :-) > >> Bob S >> >>>> On Jan 14, 2020, at 09:55 , Klaus major-k via use-livecode >>>> <use-livecode@lists.runrev.com> wrote: >>> And now I have to tell him that after 5 (FIVE!) years we still do not have >>> "system date" etc. on Android!? >>> <https://quality.livecode.com/show_bug.cgi?id=11726> >>> As a result we cannot e.g. sort a datagrid by "sytem datetime" etc. > > Best > > Klaus > > -- > Klaus Major > https://www.major-k.de > kl...@major-k.de > > > > > ------------------------------ > > Message: 12 > Date: Tue, 14 Jan 2020 19:09:29 +0100 > From: Jjs <j...@krutt.org> > To: How to use LiveCode <use-livecode@lists.runrev.com>, Klaus major-k > via use-livecode <use-livecode@lists.runrev.com> > Subject: Re: Embarrasssing old bugs > Message-ID: <e4913906-8bd1-4599-af4c-d10a7ded6...@krutt.org> > Content-Type: text/plain; charset=utf-8 > > There are more things which are still not possible in LC concerning mobile. > It goes back to 2011 and that is get ads in your app. Or decent touch > possibilities like TUIO for all desktop platforms. > > Klaus major-k via use-livecode <use-livecode@lists.runrev.com> schreef op 14 > januari 2020 18:55:33 CET: >> Hi all, hi mothership, >> >> a customer of mine asked me to help him, he needs to deliver an >> update to his existing app. >> >> I hade been mentoring him, a complete newbie, about two years ago >> and after a couple of months he had an app in the iOS store and in >> the Google Paly store (or what this is called). Not too bad. :-) >> >> And now I have to tell him that after 5 (FIVE!) years we still do not >> have >> "system date" etc. on Android!? >> <https://quality.livecode.com/show_bug.cgi?id=11726> >> As a result we cannot e.g. sort a datagrid by "sytem datetime" etc. >> >> And that we still have no (LC typically easy) way of displaying a PDF >> on Android. >> >> How embarrassing is this in 2020? >> If we want to get an even higher ranking than 36 on TIOBE, this should >> be fixed as >> soon as possible. >> >> This is of course only my "not humble at all" opinion! :-) >> >> >> Best >> >> Klaus >> >> -- >> Klaus Major >> https://www.major-k.de >> kl...@major-k.de >> >> >> _______________________________________________ >> 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 > > -- > Verstuurd vanaf mijn Android apparaat met K-9 Mail. > > ------------------------------ > > Message: 13 > Date: Tue, 14 Jan 2020 13:26:30 -0500 > From: "Greg (Pink) Miller" <livec...@pink.guru> > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: Changing extention on script only stack > Message-ID: > <CAEKxixnCtfoO+=zjd7gvuheto46gqcj7oyd1q56r7h-u8ej...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > ScriptTracker was definitely the tool I needed. I didn't need an external > script for any reason other than faster editing. > > On Sat, Jan 11, 2020 at 10:43 PM Brian Milby via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> And if you want to edit scripts in an external editor, my tool may be >> useful to you: >> https://github.com/bwmilby/scriptTracker >> >> It would support putting the scripts themselves into a repository so you >> could track changes. It generates a consolidated diff every time it >> exports scripts. >> >> Thanks, >> Brian >>> On Jan 11, 2020, 10:34 PM -0500, Sannyasin Brahmanathaswami via >>> use-livecode <use-livecode@lists.runrev.com>, wrote: >>> No revision control. For people working in a "1 human silo" >>> >>> Is there a reason not to just put the script into a button and set the >>> stack behavior to that? That's what I do when I don't want extra files in >>> my build. >>> _______________________________________________ >>> 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 >> _______________________________________________ >> 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 >> > > > ------------------------------ > > Message: 14 > Date: Tue, 14 Jan 2020 12:29:12 -0600 > From: "J. Landman Gay" <jac...@hyperactivesw.com> > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: encrypting script-only stacks > Message-ID: > <16fa55114c0.27a5.5e131b4e58299f54a9f0b9c05d4f0...@hyperactivesw.com> > Content-Type: text/plain; format=flowed; charset="UTF-8" > > My thought was that you'd use the text files during development and then > save them as binary with encryption for the final build. > > -- > Jacqueline Landman Gay | jac...@hyperactivesw.com > HyperActive Software | http://www.hyperactivesw.com > On January 14, 2020 11:38:06 AM Kaveh Bazargan via use-livecode > <use-livecode@lists.runrev.com> wrote: > >> The benefits of SoS are so important that I would hate to have to go back >> to binary again. Nothing like having pure text files to version, back up >> etc. so I am also hoping for an elegant solution to encode these in >> standalone. >> >> On Tue, 14 Jan 2020 at 17:31, Richard Gaskin via use-livecode < >> use-livecode@lists.runrev.com> wrote: >> >>> Sure, and with the extra benefit that you wouldn't have to expose your >>> code to end-users. >>> >>> That is, unless there's a way to include SoS in a standalone that >>> includes encryption, such as an automated method in the Standalone Builder. >>> >>> I couldn't find one, but it seems like such a pervasive issue for the >>> class of devs most likely to use SoS (pros dependent on VCS) that I'm >>> hoping I just missed something. >>> >>> -- >>> Richard Gaskin >>> Fourth World Systems >>> >>> >>> Jacque wrote: >>> >>>> Wouldn't a binary script-only stack be the library stack we already >>>> have now? >>>> -- >>>> Jacqueline Landman Gay | jacque at hyperactivesw.com >>>> >>>> On January 14, 2020 9:55:01 AM Richard Gaskin wrote: >>>> >>>>> Since script-only stacks contain only a script with no properties, >>>>> they have no password property, and thus cannot be encrypted. >>>>> >>>>> I had thought that including them in the Stacks pane of the >>>>> Standalone Builder might convert them to binary substacks, where >>>>> the password could apply. No dice. >>>>> >>>>> Is it a bug that script-only stacks can't be imported into the >>>>> stackfile to become binary substacks? >>>>> >>>>> -- >>>>> Richard Gaskin >>>>> Fourth World Systems >>> >>> >>> >>> _______________________________________________ >>> 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 >>> >> >> >> -- >> Kaveh Bazargan PhD >> Director >> River Valley Technologies <http://rivervalleytechnologies.com/> ? Twitter >> <https://twitter.com/kaveh1000> ? LinkedIn >> <https://www.linkedin.com/in/bazargankaveh/> >> _______________________________________________ >> 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 > > > > > > > ------------------------------ > > Message: 15 > Date: Tue, 14 Jan 2020 18:55:37 +0000 > From: Kaveh Bazargan <ka...@rivervalleytechnologies.com> > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: encrypting script-only stacks > Message-ID: > <caj2r9phje6fhvicdrl-wfkifq7c0mzgdvnnfl3tdgob545a...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > That?s a great idea. :-) > > On Tue, 14 Jan 2020 at 18:30, J. Landman Gay via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> My thought was that you'd use the text files during development and then >> save them as binary with encryption for the final build. >> >> -- >> Jacqueline Landman Gay | jac...@hyperactivesw.com >> HyperActive Software | http://www.hyperactivesw.com >> On January 14, 2020 11:38:06 AM Kaveh Bazargan via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >>> The benefits of SoS are so important that I would hate to have to go back >>> to binary again. Nothing like having pure text files to version, back up >>> etc. so I am also hoping for an elegant solution to encode these in >>> standalone. >>> >>> On Tue, 14 Jan 2020 at 17:31, Richard Gaskin via use-livecode < >>> use-livecode@lists.runrev.com> wrote: >>> >>>> Sure, and with the extra benefit that you wouldn't have to expose your >>>> code to end-users. >>>> >>>> That is, unless there's a way to include SoS in a standalone that >>>> includes encryption, such as an automated method in the Standalone >> Builder. >>>> >>>> I couldn't find one, but it seems like such a pervasive issue for the >>>> class of devs most likely to use SoS (pros dependent on VCS) that I'm >>>> hoping I just missed something. >>>> >>>> -- >>>> Richard Gaskin >>>> Fourth World Systems >>>> >>>> >>>> Jacque wrote: >>>> >>>>> Wouldn't a binary script-only stack be the library stack we already >>>>> have now? >>>>> -- >>>>> Jacqueline Landman Gay | jacque at hyperactivesw.com >>>>> >>>>> On January 14, 2020 9:55:01 AM Richard Gaskin wrote: >>>>> >>>>>> Since script-only stacks contain only a script with no properties, >>>>>> they have no password property, and thus cannot be encrypted. >>>>>> >>>>>> I had thought that including them in the Stacks pane of the >>>>>> Standalone Builder might convert them to binary substacks, where >>>>>> the password could apply. No dice. >>>>>> >>>>>> Is it a bug that script-only stacks can't be imported into the >>>>>> stackfile to become binary substacks? >>>>>> >>>>>> -- >>>>>> Richard Gaskin >>>>>> Fourth World Systems >>>> >>>> >>>> >>>> _______________________________________________ >>>> 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 >>>> >>> >>> >>> -- >>> Kaveh Bazargan PhD >>> Director >>> River Valley Technologies <http://rivervalleytechnologies.com/> ? >> Twitter >>> <https://twitter.com/kaveh1000> ? LinkedIn >>> <https://www.linkedin.com/in/bazargankaveh/> >>> _______________________________________________ >>> 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 >> >> >> >> >> _______________________________________________ >> 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 >> > -- > Sent from MetroMail > > > ------------------------------ > > Message: 16 > Date: Tue, 14 Jan 2020 11:12:20 -0800 > From: Richard Gaskin <ambassa...@fourthworld.com> > To: use-livecode@lists.runrev.com > Subject: Re: encrypting script-only stacks > Message-ID: <33015fb4-a659-ea6a-f315-fe0313cec...@fourthworld.com> > Content-Type: text/plain; charset=utf-8; format=flowed > > Exactly. I was hoping the Standalone Builder would do that if you > choose to include external SoS in the standalone. > > What I found instead is that it doesn't being them into the standalone > stack file as substacks, nor even convert them to binary stack files in > place. It just refuses to allow a password to be set. > > For apps making rich use of SoS, it would seem tedious to do that > conversion by hand, or to expect every developer to write the same pair > of handlers to automate that before and after building the standalone. > > How do folks who use SoS frequently protect those SoS scripts? > > -- > Richard Gaskin > Fourth World Systems > > > J. Landman Gay wrote: >> My thought was that you'd use the text files during development and then >> save them as binary with encryption for the final build. >> >> -- >> Jacqueline Landman Gay | jacque at hyperactivesw.com >> HyperActive Software | http://www.hyperactivesw.com >> On January 14, 2020 11:38:06 AM Kaveh Bazargan via use-livecode >> <use-livecode at lists.runrev.com> wrote: >> >>> The benefits of SoS are so important that I would hate to have to go back >>> to binary again. Nothing like having pure text files to version, back up >>> etc. so I am also hoping for an elegant solution to encode these in >>> standalone. >>> >>> On Tue, 14 Jan 2020 at 17:31, Richard Gaskin via use-livecode < >>> use-livecode at lists.runrev.com> wrote: >>> >>>> Sure, and with the extra benefit that you wouldn't have to expose your >>>> code to end-users. >>>> >>>> That is, unless there's a way to include SoS in a standalone that >>>> includes encryption, such as an automated method in the Standalone Builder. >>>> >>>> I couldn't find one, but it seems like such a pervasive issue for the >>>> class of devs most likely to use SoS (pros dependent on VCS) that I'm >>>> hoping I just missed something. >>>> >>>> -- >>>> Richard Gaskin >>>> Fourth World Systems > > > > > ------------------------------ > > Message: 17 > Date: Tue, 14 Jan 2020 11:14:19 -0800 > From: Richard Gaskin <ambassa...@fourthworld.com> > To: use-livecode@lists.runrev.com > Subject: Re: Changing extention on script only stack > Message-ID: <83634d17-4eee-7a38-2402-6a221e3a9...@fourthworld.com> > Content-Type: text/plain; charset=utf-8; format=flowed > > Greg (Pink) Miller wrote: >> ScriptTracker was definitely the tool I needed. I didn't need an external >> script for any reason other than faster editing. > > If people are use SoS solely to get away from performance issues in the > Script Editor, rather than add a pile of other tools to make SoS > development simpler it would seem prudent to review and optimize the > Script Editor. > > -- > Richard Gaskin > Fourth World Systems > Software Design and Development for the Desktop, Mobile, and the Web > ____________________________________________________________________ > ambassa...@fourthworld.com http://www.FourthWorld.com > > > > ------------------------------ > > Message: 18 > Date: Tue, 14 Jan 2020 11:16:01 -0800 > From: Richard Gaskin <ambassa...@fourthworld.com> > To: use-livecode@lists.runrev.com > Subject: Re: SQL(ite) question > Message-ID: <9943928d-2b20-490a-69da-6186b520b...@fourthworld.com> > Content-Type: text/plain; charset=utf-8; format=flowed > > Bob Sneidar wrote: >> Actually I do this all the time. >> >> SELECT * from MyTable where >> COLUMN1 like "%mysearchtermhere%" OR >> COLUMN2 like "%mysearchtermhere%" OR >> COLUMN3 like "%mysearchtermhere%" >> >> I loop through a list of columns I want to search to build the query. > > Wouldn't that be a brute-force search rather than the efficiency of > SQLite's FTS index? > > -- > Richard Gaskin > Fourth World Systems > Software Design and Development for the Desktop, Mobile, and the Web > ____________________________________________________________________ > ambassa...@fourthworld.com http://www.FourthWorld.com > > > > ------------------------------ > > Message: 19 > Date: Tue, 14 Jan 2020 19:53:16 +0000 > From: Sannyasin Brahmanathaswami <bra...@hindu.org> > To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: Embarrasssing old bugs > Message-ID: <0b0c945a-d600-4cb1-b92b-ee7fb24c1...@hindu.org> > Content-Type: text/plain; charset="utf-8" > > Klaus wrote > "How embarrassing is this in 2020? If we want to get an even higher ranking > than 36 on TIOBE, this should be fixed as? > soon as possible." > > It is: embarrassing. The fact that the LC engine cannot does not produce > > ISO-8601 standard dates > > https://www.iso.org/iso-8601-date-and-time-format.html > > is one testimony of why the "Livecode Project" "regresses" as much as it > tries to "proceed forward" > > https://quality.livecode.com/show_bug.cgi?id=7833 > > https://quality.livecode.com/show_bug.cgi?id=4636 > > > There are several "convert date" libraries knocking around. That would help > you?. > > BR > > > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > http://lists.runrev.com/mailman/listinfo/use-livecode > > > ------------------------------ > > End of use-livecode Digest, Vol 196, Issue 15 > ********************************************* _______________________________________________ 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
