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: [email protected] > To: How to use LiveCode <[email protected]> > Subject: FYI: Cause found for LC crashing to desktop when Browser > widget opens PDF > Message-ID: <[email protected]> > 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 <[email protected]> > To: How to use LiveCode <[email protected]> > Subject: Re: SQL(ite) question > Message-ID: <[email protected]> > 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 >> <[email protected]> wrote: >> >> Hi Sean, >> >>>> Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode >>>> <[email protected]>: >>> >>> 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 >>>>> <[email protected]> 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 <[email protected]> > To: How to use LiveCode <[email protected]> > Subject: Re: Embarrasssing old bugs > Message-ID: <[email protected]> > 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 >> <[email protected]> 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 <[email protected]> > To: How to use LiveCode <[email protected]> > Subject: Re: SQL(ite) question > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8 > > Hi Bob, > >> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode >> <[email protected]>: >> >> 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 >>>>>> <[email protected]> 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 > [email protected] > > > > > ------------------------------ > > Message: 10 > Date: Tue, 14 Jan 2020 18:07:03 +0000 > From: Bob Sneidar <[email protected]> > To: How to use LiveCode <[email protected]> > Subject: Re: SQL(ite) question > Message-ID: <[email protected]> > 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 >> <[email protected]> wrote: >> >> Hi Bob, >> >>>> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode >>>> <[email protected]>: >>> >>> 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 <[email protected]> > To: How to use LiveCode <[email protected]> > Subject: Re: Embarrasssing old bugs > Message-ID: <[email protected]> > Content-Type: text/plain; charset=us-ascii > > Hi Bob, > >> Am 14.01.2020 um 19:04 schrieb Bob Sneidar via use-livecode >> <[email protected]>: >> 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 >>>> <[email protected]> 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 > [email protected] > > > > > ------------------------------ > > Message: 12 > Date: Tue, 14 Jan 2020 19:09:29 +0100 > From: Jjs <[email protected]> > To: How to use LiveCode <[email protected]>, Klaus major-k > via use-livecode <[email protected]> > Subject: Re: Embarrasssing old bugs > Message-ID: <[email protected]> > 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 <[email protected]> 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 >> [email protected] >> >> >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> 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" <[email protected]> > To: How to use LiveCode <[email protected]> > 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 < > [email protected]> 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 <[email protected]>, 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 >>> [email protected] >>> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> 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" <[email protected]> > To: How to use LiveCode <[email protected]> > 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 | [email protected] > HyperActive Software | http://www.hyperactivesw.com > On January 14, 2020 11:38:06 AM Kaveh Bazargan via use-livecode > <[email protected]> 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 < >> [email protected]> 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 >>> [email protected] >>> 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 >> [email protected] >> 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 <[email protected]> > To: How to use LiveCode <[email protected]> > 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 < > [email protected]> 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 | [email protected] >> HyperActive Software | http://www.hyperactivesw.com >> On January 14, 2020 11:38:06 AM Kaveh Bazargan via use-livecode >> <[email protected]> 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 < >>> [email protected]> 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 >>>> [email protected] >>>> 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 >>> [email protected] >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> >> >> >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> 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 <[email protected]> > To: [email protected] > Subject: Re: encrypting script-only stacks > Message-ID: <[email protected]> > 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 <[email protected]> > To: [email protected] > Subject: Re: Changing extention on script only stack > Message-ID: <[email protected]> > 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 > ____________________________________________________________________ > [email protected] http://www.FourthWorld.com > > > > ------------------------------ > > Message: 18 > Date: Tue, 14 Jan 2020 11:16:01 -0800 > From: Richard Gaskin <[email protected]> > To: [email protected] > Subject: Re: SQL(ite) question > Message-ID: <[email protected]> > 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 > ____________________________________________________________________ > [email protected] http://www.FourthWorld.com > > > > ------------------------------ > > Message: 19 > Date: Tue, 14 Jan 2020 19:53:16 +0000 > From: Sannyasin Brahmanathaswami <[email protected]> > To: How to use LiveCode <[email protected]> > Subject: Re: Embarrasssing old bugs > Message-ID: <[email protected]> > 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 > [email protected] > http://lists.runrev.com/mailman/listinfo/use-livecode > > > ------------------------------ > > End of use-livecode Digest, Vol 196, Issue 15 > ********************************************* _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
