Re: encrypting script-only stacks

[Trevor DeVore via use-livecode]

On Tue, Jan 14, 2020 at 10:36 PM Mark Wieder via use-livecode <
use-livecode@lists.runrev.com> wrote:

> On 1/14/20 9:46 AM, Richard Gaskin via use-livecode wrote:
>
> > Beyond backup across versions (since that's widely available in most
> > cloud storage for even binary files), that Git features do you find most
> > valuable?
> >
>
> As in Trevor's description, the advantage of being able to create new
> branches for experimental work can't be overstated.
>
> Consider: you have a working project and want to try making some changes
> that may or may not work. And that may or may not stop existing things
> from working. Or maybe you just want to try some A-B testing and be able
> to create two different versions. Or create a new version and be able to
> do some performance benchmarking.
>
> All without messing with your existing product code.
>
> If it works you can merge the branch into the main code. If not then
> just dump the branch and you haven't lost anything except some time.
>
> I also use tagging in git to set release values, so that I can easily
> see what's changed from one release to the next.
>

I'll toss in an amen to both of these points (testing optimizations, etc.
and tagging releases). I use Tower as my Git GUI with Kaleidoscope for
diffs. I can easily see a diff of all files that have changed between two
releases because I tag the commit that was current at release time of each
version.

-- 
Trevor DeVore
ScreenSteps
www.screensteps.com
___
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

Re: encrypting script-only stacks

[Trevor DeVore via use-livecode]

On Tue, Jan 14, 2020 at 4:14 PM Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Thanks, Trevor.  That's a helpful outline.
>
> I haven't had a business case to support so many branches, but I can see
> where it might be useful down the road.
>
> Any opinions on Github vs Gitlab?
>

I've only used Github so I can't offer up a comparison. I've been happy
with Github for the most part and my company has been working with it for a
number of years.

-- 
Trevor DeVore
ScreenSteps
www.screensteps.com
___
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

Re: encrypting script-only stacks

[Richard Gaskin via use-livecode]

Mark Wieder wrote:

> On 1/14/20 7:52 AM, Richard Gaskin via use-livecode wrote:
>
>> Is it a bug that script-only stacks can't be imported into the
>> stackfile to become binary substacks?
>>
>
> They can, but it's a one-way operation. Once you've done that the
> substack and the script-only text file are two different entities.
> Editing one won't affect the other.

For building standalones that would be fine.  Is that in the Standalone 
Builder, or something every one of us needs to write our own script for?


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com


___
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

Re: encrypting script-only stacks

[Mark Wieder via use-livecode]

On 1/14/20 2:13 PM, Richard Gaskin via use-livecode wrote:


Any opinions on Github vs Gitlab?



SCaLE is coming up soon. Gitlab always has a table set up.
They're good at answering the hard questions.

--
 Mark Wieder
 ahsoftw...@gmail.com

___
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

Re: encrypting script-only stacks

[Mark Wieder via use-livecode]

On 1/14/20 9:46 AM, Richard Gaskin via use-livecode wrote:

Beyond backup across versions (since that's widely available in most 
cloud storage for even binary files), that Git features do you find most 
valuable?




As in Trevor's description, the advantage of being able to create new 
branches for experimental work can't be overstated.


Consider: you have a working project and want to try making some changes 
that may or may not work. And that may or may not stop existing things 
from working. Or maybe you just want to try some A-B testing and be able 
to create two different versions. Or create a new version and be able to 
do some performance benchmarking.


All without messing with your existing product code.

If it works you can merge the branch into the main code. If not then 
just dump the branch and you haven't lost anything except some time.


I also use tagging in git to set release values, so that I can easily 
see what's changed from one release to the next.


--
 Mark Wieder
 ahsoftw...@gmail.com

___
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

Re: encrypting script-only stacks

[Mark Wieder via use-livecode]

On 1/14/20 7:52 AM, Richard Gaskin via use-livecode wrote:

Is it a bug that script-only stacks can't be imported into the stackfile 
to become binary substacks?




They can, but it's a one-way operation. Once you've done that the 
substack and the script-only text file are two different entities. 
Editing one won't affect the other.


--
 Mark Wieder
 ahsoftw...@gmail.com

___
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

Re: Embarrasssing old bugs

[Sannyasin Brahmanathaswami via use-livecode]

https://quality.livecode.com/show_bug.cgi?id=4636

Klaus:

Ouch! :-/

> There are several "convert date" libraries knocking around. That would help 
> you….

Thank you, but after now more than 20 years using of MC/RR/R/LC I know how to 
do that. __

HA! Maybe would can add comments to that "enhancement" 
And thus we have a 13 year old feature request __

Well, are least in says something for Livecode Longevity/Stability. 

Meanwhile I know an "associate" who jumps for Angular, to React, to Gatsby and 
finally settles for (you won't believe this) for Word Press. There's something 
to be said for

 "now more than 20 years using of MC/RR/R/LC I know how to do that." 




___
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

Re: Embarrasssing old bugs

[Richard Gaskin via use-livecode]

Kalus major-k wrote:


Am 14.01.2020 um 20:53 schrieb Sannyasin Brahmanathaswami via use-livecode 
:
There are several "convert date" libraries knocking around. That would help 
you….


Thank you, but after now more than 20 years using of MC/RR/R/LC I know how to 
do that. :-D


The irony here is that in the DB file itself the date is stored as an 
integer, which LC could hand off to it quite easily, were it not for the 
SQL interface that demands a specific textual representation.


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com

___
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

RE: Cause found for LC crashing to desktop when Browser widget opens PDF

[Ralph DiMola via use-livecode]

FYI: I'm not seeing this. PDF display OK.

1) New stack
2) Create Browser widget
3) Put https URL to a PDF into the Property inspector.

LC 9.5.1
LC 9.6dp2
Win 10 1709
Acrobat DC 2019.021.20061

Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net

-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of 
Matthias Rebbe via use-livecode
Sent: Tuesday, January 14, 2020 5:14 PM
To: How to use LiveCode
Cc: matthias_livecode_150...@m-r-d.de
Subject: Re: Cause found for LC crashing to desktop when Browser widget opens 
PDF

Hm,
i am working with Mojave 10.14.6 and the most current version of Acrobat DC.
Maybe this also depends on the os. Anyway i can replicate it on a newly 
installed Mac.

We´ll see what LC´s Dev Team does say.



> Am 14.01.2020 um 22:16 schrieb Richard Hillen via use-livecode 
> :
> 
> 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 
>> 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 +
>> From: Bob Sneidar 
>> To: How to use LiveCode 
>> Subject: Re: SQL(ite) question
>> Message-ID: 
>> 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 
>>>  wrote:
>>> 
>>> Hi Sean,
>>> 
> Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode 
> :
 
 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 
>>  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 +
>> From: Bob Sneidar 
>> To: How to use LiveCode 
>> 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 
>>>  wrote:
>>> 
>>> And now I have to tell him that after 5 (FIVE!) years we still do 
>>> not have "system date" etc. on Android!?
>>> 
>>> 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 
>> To: How to use LiveCode 
>> Subject: Re: SQL(ite) question
>> Message-ID: 
>> Content-Type: text/plain;charset=utf-8
>> 
>> Hi Bob,
>> 
>>> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode 
>>> :
>>> 
>>> 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 
>>>  wrote:
>> ?Actually I do this all the time. 
>> SELECT * from MyTable where
>> COLUMN1 like "%mysearchtermhere%" OR
>> COLUMN2 like "%mysearchtermhe

Re: Changing extention on script only stack

[Bob Sneidar via use-livecode]

I'll pitch in for lunch but I can't fund the whole project. 

Bob S


> On Jan 14, 2020, at 14:08 , Richard Gaskin via use-livecode 
>  wrote:
> 
> Bob Sneidar wrote:
> 
> > Let's remember this is just Windows we are talking about. I have no
> > issues whatsoever with the OS X version of LC Script Editor...
> 
> While performance issues are most evident on Windows, there's some noticeable 
> lag on Mac too.  Most who use external editors here are on Mac.
> 
> And then there are oddities that affect all platforms, like the line numbers 
> getting out of sync with the text when scrolling.
> 
> 
> > ...but the few times I really needed to code and debug in Windows
> > it was like scratching my eyes out with a toothpick.
> 
> Yeah, that.
> 
> I'll throw in a debugger for free if someone takes me up on by editor offer.
> 
> -- 
> Richard Gaskin
> Fourth World Systems
> Software Design and Development for the Desktop, Mobile, and the Web


___
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

Re: Embarrasssing old bugs

[Klaus major-k via use-livecode]

Hi Swami,

> Am 14.01.2020 um 20:53 schrieb Sannyasin Brahmanathaswami via use-livecode 
> :
> 
> 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

Ouch! :-/

> There are several "convert date" libraries knocking around. That would help 
> you….

Thank you, but after now more than 20 years using of MC/RR/R/LC I know how to 
do that. :-D

> BR

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

Re: encrypting script-only stacks

[Richard Gaskin via use-livecode]

Thanks, Trevor.  That's a helpful outline.

I haven't had a business case to support so many branches, but I can see 
where it might be useful down the road.


Any opinions on Github vs Gitlab?

--
 Richard Gaskin
 Fourth World Systems


Trevor DeVore wrote:

On Tue, Jan 14, 2020 at 11:47 AM Richard Gaskin via use-livecode <
use-livecode at lists.runrev.com> wrote:


...

Help me motivate to move my Git transition forward sooner:

Beyond backup across versions (since that's widely available in most
cloud storage for even binary files), that Git features do you find most
valuable?



Hi Richard -

One way I use Git is to develop multiple features in tandem without
affecting the version I distribute of my app that I distribute to
customers. I love how I can silo my own work on features as well as the
flexibility to see detailed history of changes throughout the life of my
application. I use the Git commit notes and the ease with which you can
review changes in those commits a number of times when trying to track down
at what point a bug was introduced.

Here is an example of how I silo work I'm doing right now. If you looked at
my Git repo earlier today you would see the following branches:

- master
- develop
- tkd-htmltidy
- tkd-remove-answer-types
- tkd-mammoth
- tkd-hires-annotations

`master` always has the release version of the code.

`develop` is code that has been developed, tested, and is ready to go into
the next release. I will create builds from this branch to send to
customers who want early access to a feature or bug fix.

All other branches are features that are being worked on but which are not
finished and require more testing. Some of those branches exist for an
afternoon. Some last for a month or more.

Today I merged in `tkd-htmltidy` and tkd-remove-answer-types` into
`develop` as they were finished and are ready to send to customers who need
early access. When I squashed and merged those branches in there were a
number of changes which had been made in the develop branch since I had
started `tkd-htmltidy`. Those changes were seamless blended together
without any problem, even though there were changes changes made in some of
the same files. In addition, because I squashed the merge, all of the
changes that went into the addition of HTML Tidy are seen as one commit in
my `develop` branch. I made dozens of commits during development but was
able to make one clean commit when I was all done and ready to merge the
changes with the main code branch. This makes for a clean history that is
easier to review later on.

I will continue to work on the tkd-hires-annotations and tkd-mammoth
branches as they aren't done yet and require more revisions. But once they
are ready I perform the same squash and merge. If I want an internal tester
or a customer to test those features out before they are ready I can do
that too. I can use the Git rebase feature to bring in all changes to
`develop` that have been made since I created a particular branch. That
means the tester is using the latest version of the app along with the new
feature I'm working on.

One last example. Let's say that a nasty bug turns up while I'm working on
`develop` and need to get a release out to customers right away. I can go
to master, create a new branch from that code, make the fix, and package up
a new installer. I can merge that fix into `develop` as well so that it
will be included in a future update.

I think the scenarios I describe above are my favorite reasons for using
Git as they make my daily development and management of the code easier.

--
Trevor DeVore
ScreenSteps
www.screensteps.com



___
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

Re: Cause found for LC crashing to desktop when Browser widget opens PDF

[Matthias Rebbe via use-livecode]

Hm,
i am working with Mojave 10.14.6 and the most current version of Acrobat DC.
Maybe this also depends on the os. Anyway i can replicate it on a newly 
installed Mac.

We´ll see what LC´s Dev Team does say.



> Am 14.01.2020 um 22:16 schrieb Richard Hillen via use-livecode 
> :
> 
> 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 
>> 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 +
>> From: Bob Sneidar 
>> To: How to use LiveCode 
>> Subject: Re: SQL(ite) question
>> Message-ID: 
>> 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 
>>>  wrote:
>>> 
>>> Hi Sean,
>>> 
> Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode 
> :
 
 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 
>>  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 +
>> From: Bob Sneidar 
>> To: How to use LiveCode 
>> 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 
>>>  wrote:
>>> 
>>> And now I have to tell him that after 5 (FIVE!) years we still do not have 
>>> "system date" etc. on Android!? 
>>> 
>>> 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 
>> To: How to use LiveCode 
>> Subject: Re: SQL(ite) question
>> Message-ID: 
>> Content-Type: text/plain;charset=utf-8
>> 
>> Hi Bob,
>> 
>>> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode 
>>> :
>>> 
>>> 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 
>>>  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 +
>> From: Bob Sneidar 
>> To: How to use LiveCode 
>> 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

Re: Changing extention on script only stack

[Richard Gaskin via use-livecode]

Bob Sneidar wrote:

> Let's remember this is just Windows we are talking about. I have no
> issues whatsoever with the OS X version of LC Script Editor...

While performance issues are most evident on Windows, there's some 
noticeable lag on Mac too.  Most who use external editors here are on Mac.


And then there are oddities that affect all platforms, like the line 
numbers getting out of sync with the text when scrolling.



> ...but the few times I really needed to code and debug in Windows
> it was like scratching my eyes out with a toothpick.

Yeah, that.

I'll throw in a debugger for free if someone takes me up on by editor offer.

--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com


___
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

Re: SQL(ite) question

[Richard Gaskin via use-livecode]

Bob Sneidar wrote:
> Yes, but the original question was about whether or not it could be
> done with a single statement. Also I am not a big fan of full text
> searches the way they are implemented typically. For instance, on our
> copier vendor's websites they of course have searches, but what I end
> up with are 10,000 hits and almost none of them relevant. This is
> because they are not ranked, and the ranking makes all the difference
> in the world.
>
> My method does not rank of course, but it is a quick one liner that
> gets the job done (unless you have to build the query on the fly in a
> repeat loop).

SQLite's FTS is described as providing ranking.  Maybe they were using 
an older version, or not using the full API?


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com


___
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

Re: Cause found for LC crashing to desktop when Browser widget opens PDF

[Richard Hillen via use-livecode]

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 
> 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 +
> From: Bob Sneidar 
> To: How to use LiveCode 
> Subject: Re: SQL(ite) question
> Message-ID: 
> 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 
>>  wrote:
>> 
>> Hi Sean,
>> 
 Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode 
 :
>>> 
>>> 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 
>  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 +
> From: Bob Sneidar 
> To: How to use LiveCode 
> 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 
>>  wrote:
>> 
>> And now I have to tell him that after 5 (FIVE!) years we still do not have 
>> "system date" etc. on Android!? 
>> 
>> 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 
> To: How to use LiveCode 
> Subject: Re: SQL(ite) question
> Message-ID: 
> Content-Type: text/plain;charset=utf-8
> 
> Hi Bob,
> 
>> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode 
>> :
>> 
>> 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 
>>  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 +
> From: Bob Sneidar 
> To: How to use LiveCode 
> 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 
>>  wrote:
>> 
>> Hi Bob,
>> 
 Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode 
 :
>>> 
>>> 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

Re: encrypting script-only stacks

[Trevor DeVore via use-livecode]

On Tue, Jan 14, 2020 at 2:35 PM Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Trevor DeVore wrote:
>
> > I use SoS extensively but I had never tried using the SB to encrypt them
> as
> > I use Levure. The Levure packaging library automatically encrypts script
> > only stacks for you during the packaging process. While Levure uses the
> SB
> > to create the standalone, encrypting the stacks is handled in the Levure
> > packaging library, not the SB.
>
> I'm assuming Levure does this by converting a copy of the SoS stack
> files to binary stack files, yes?
>

That is correct. The SoS is opened, the the scriptonly property of the
stack is set to false, and then it is saved using the same filename. This
is all done in a temporary directory so that the source file isn't modified
at all.

-- 
Trevor DeVore
ScreenSteps
www.screensteps.com
___
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

Re: encrypting script-only stacks

[Trevor DeVore via use-livecode]

On Tue, Jan 14, 2020 at 11:47 AM Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> ...
>
> Help me motivate to move my Git transition forward sooner:
>
> Beyond backup across versions (since that's widely available in most
> cloud storage for even binary files), that Git features do you find most
> valuable?
>

Hi Richard -

One way I use Git is to develop multiple features in tandem without
affecting the version I distribute of my app that I distribute to
customers. I love how I can silo my own work on features as well as the
flexibility to see detailed history of changes throughout the life of my
application. I use the Git commit notes and the ease with which you can
review changes in those commits a number of times when trying to track down
at what point a bug was introduced.

Here is an example of how I silo work I'm doing right now. If you looked at
my Git repo earlier today you would see the following branches:

- master
- develop
- tkd-htmltidy
- tkd-remove-answer-types
- tkd-mammoth
- tkd-hires-annotations

`master` always has the release version of the code.

`develop` is code that has been developed, tested, and is ready to go into
the next release. I will create builds from this branch to send to
customers who want early access to a feature or bug fix.

All other branches are features that are being worked on but which are not
finished and require more testing. Some of those branches exist for an
afternoon. Some last for a month or more.

Today I merged in `tkd-htmltidy` and tkd-remove-answer-types` into
`develop` as they were finished and are ready to send to customers who need
early access. When I squashed and merged those branches in there were a
number of changes which had been made in the develop branch since I had
started `tkd-htmltidy`. Those changes were seamless blended together
without any problem, even though there were changes changes made in some of
the same files. In addition, because I squashed the merge, all of the
changes that went into the addition of HTML Tidy are seen as one commit in
my `develop` branch. I made dozens of commits during development but was
able to make one clean commit when I was all done and ready to merge the
changes with the main code branch. This makes for a clean history that is
easier to review later on.

I will continue to work on the tkd-hires-annotations and tkd-mammoth
branches as they aren't done yet and require more revisions. But once they
are ready I perform the same squash and merge. If I want an internal tester
or a customer to test those features out before they are ready I can do
that too. I can use the Git rebase feature to bring in all changes to
`develop` that have been made since I created a particular branch. That
means the tester is using the latest version of the app along with the new
feature I'm working on.

One last example. Let's say that a nasty bug turns up while I'm working on
`develop` and need to get a release out to customers right away. I can go
to master, create a new branch from that code, make the fix, and package up
a new installer. I can merge that fix into `develop` as well so that it
will be included in a future update.

I think the scenarios I describe above are my favorite reasons for using
Git as they make my daily development and management of the code easier.

-- 
Trevor DeVore
ScreenSteps
www.screensteps.com
___
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

Re: Use-livecode author names

[Alex Tweedly via use-livecode]

I'm slightly unsure of those numbers. My email outbox has over 1000 
messages to the list - and although a few of them were rejected :-), I 
would have thought I should still appear in that 'frequent-sender' list 
(even if I did split my posts between a couple of authornames).


Alex.

On 14/01/2020 11:17, hh via use-livecode wrote:

See the "statistics" here:
http://forums.livecode.com/viewtopic.php?p=186723#p186723

___
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

Re: Changing extention on script only stack

[Bob Sneidar via use-livecode]

Let's remember this is just Windows we are talking about. I have no issues 
whatsoever with the OS X version of LC Script Editor, but the few times I 
really needed to code and debug in Windows it was like scratching my eyes out 
with a toothpick. 

Bob S


> On Jan 14, 2020, at 12:09 , Kaveh Bazargan via use-livecode 
>  wrote:
> 
> The slow editing in LiveCode is a big drawback for me. It is slow, spacing
> is usually off till you hit tab, and generally not efficient.


___
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

Re: SQL(ite) question

[Bob Sneidar via use-livecode]

Yes, but the original question was about whether or not it could be done with a 
single statement. Also I am not a big fan of full text searches the way they 
are implemented typically. For instance, on our copier vendor's websites they 
of course have searches, but what I end up with are 10,000 hits and almost none 
of them relevant. This is because they are not ranked, and the ranking makes 
all the difference in the world. 

My method does not rank of course, but it is a quick one liner that gets the 
job done (unless you have to build the query on the fly in a repeat loop). 

Bob S


> On Jan 14, 2020, at 11:16 , Richard Gaskin via use-livecode 
>  wrote:
> 
> Bob Sneidar wrote:
>> Actually I do this all the time. SELECT * from MyTable where
>>   COLUMN1 like "%mysearchtermhere%" ORCOLUMN2 like "%mysearchtermhere%" 
>> ORCOLUMN3 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


___
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

Re: encrypting script-only stacks

[Richard Gaskin via use-livecode]

Trevor DeVore wrote:


On Tue, Jan 14, 2020 at 1:13 PM Richard Gaskin via use-livecode <
use-livecode at lists.runrev.com> wrote:


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?



I use SoS extensively but I had never tried using the SB to encrypt them as
I use Levure. The Levure packaging library automatically encrypts script
only stacks for you during the packaging process. While Levure uses the SB
to create the standalone, encrypting the stacks is handled in the Levure
packaging library, not the SB.


I'm assuming Levure does this by converting a copy of the SoS stack 
files to binary stack files, yes?


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com

___
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

Re: iOS launch screen dimensions

[J. Landman Gay via use-livecode]

I just went through a comparison and it looks like most of the actually 
do match. The SB is missing only these two:

11" iPad Pro   1668px × 2388px
10.5" iPad Pro 1668px × 2224px 

I used a couple of online image generators to get the full range of 
launch images, and they produced many other dimensions that aren't in 
the SB, and didn't include some that are. Maybe they were producing 
images for other things, storyboards maybe?


On 1/13/20 4:02 PM, panagiotis merakos via use-livecode wrote:

Hello Jacque,

The requirements in the S/B should match Apple's requirements - if they
don't then it looks like a bug.

Which screen's dimensions do not match? Also could you post the link of the
webpage you are referring to?

Kind regards
Panos
--

PS: Using a storyboard is not supported in LC. I _think_ it is possible to
do it though - if you tweak the IDE code that saves the iOS standalone.

On Mon, 13 Jan 2020 at 23:46, J. Landman Gay via use-livecode <
use-livecode@lists.runrev.com> wrote:


The list of launch screen dimensions on the Apple developer site doesn't
match the requirements in the standalone builder. Does that matter?

Apple doesn't recommend that method anyway, they prefer a storyboard.
Has anyone done that, and is it possible?

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
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




--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
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

Re: encrypting script-only stacks

[Trevor DeVore via use-livecode]

On Tue, Jan 14, 2020 at 1:13 PM Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> 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?
>

I use SoS extensively but I had never tried using the SB to encrypt them as
I use Levure. The Levure packaging library automatically encrypts script
only stacks for you during the packaging process. While Levure uses the SB
to create the standalone, encrypting the stacks is handled in the Levure
packaging library, not the SB.

I agree that the SB should handle this for you though.

-- 
Trevor DeVore
ScreenSteps
www.screensteps.com
___
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

Re: Changing extention on script only stack

[Kaveh Bazargan via use-livecode]

The slow editing in LiveCode is a big drawback for me. It is slow, spacing
is usually off till you hit tab, and generally not efficient.

On Tue, 14 Jan 2020 at 20:06, Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Brian Milby wrote:
>  > I would offer a clarification for ScriptTracker...
>
> I didn't mean to imply your fine tool's only purpose was to help people
> get around a slow Script Editor.  It is indeed very useful for its
> intended purposes.
>
> But when we start using tools intended for all sorts of things to hobble
> together alternatives that allow us to avoid LC's Script Editor, I begin
> to wonder:
>
> Isn't it possible to build an efficient, enjoyable text editor in LC?
>
> I believe it is.
>
> I'd do it if someone would pay my bills for a month.
>
> --
>   Richard Gaskin
>   Fourth World Systems
>   Software Design and Development for the Desktop, Mobile, and the Web
>   
>   ambassa...@fourthworld.comhttp://www.FourthWorld.com
>
> ___
> 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  • Twitter
 • LinkedIn

___
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

Re: Changing extention on script only stack

[Richard Gaskin via use-livecode]

Brian Milby wrote:
> I would offer a clarification for ScriptTracker...

I didn't mean to imply your fine tool's only purpose was to help people 
get around a slow Script Editor.  It is indeed very useful for its 
intended purposes.


But when we start using tools intended for all sorts of things to hobble 
together alternatives that allow us to avoid LC's Script Editor, I begin 
to wonder:


Isn't it possible to build an efficient, enjoyable text editor in LC?

I believe it is.

I'd do it if someone would pay my bills for a month.

--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com

___
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

Re: Changing extention on script only stack

[Brian Milby via use-livecode]

I would offer a clarification for ScriptTracker:  while the files it exports 
could be used as-is for SoS behaviors, that is not the goal of the tool.  One 
goal is to allow editing of scripts in external editors (performance is one 
reason, but there are others too).  A larger goal is to allow Git to be used on 
a binary stack but have the key piece of information (the code) extracted in 
such a way to facilitate tracking the changes.  A third goal goes hand in hand 
with that.  This goal is to allow review of code online without having to 
download the actual stack.  If you look at all of my public repositories you 
can review any code that is inside my binary stacks natively on GitHub.

If a stack makes sense to distribute as a binary stack file (and not built as 
an application), then this makes the tracking easy.  I also think it is better 
for the end user of the stack.  Trevor does something the other way around with 
Baker’s Assistant.  He develops with behaviors but then assembles everything 
into a single binary stack for distribution.  I’ve done something similar with 
Navigator for my own use.

Thanks,
Brian
On Jan 14, 2020, 2:15 PM -0500, Richard Gaskin via use-livecode 
, wrote:
> 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
>
> ___
> 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

Re: Embarrasssing old bugs

[Sannyasin Brahmanathaswami via use-livecode]

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




___
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

Re: SQL(ite) question

[Richard Gaskin via use-livecode]

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.comhttp://www.FourthWorld.com

___
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

Re: Changing extention on script only stack

[Richard Gaskin via use-livecode]

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.comhttp://www.FourthWorld.com

___
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

Re: encrypting script-only stacks

[Richard Gaskin via use-livecode]

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 
 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



___
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

Re: encrypting script-only stacks

[Kaveh Bazargan via use-livecode]

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
>  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  •
> Twitter
> >  • LinkedIn
> > 
> > ___
> > 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
___
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

Re: encrypting script-only stacks

[J. Landman Gay via use-livecode]

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 
 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  • Twitter
 • LinkedIn

___
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

Re: Changing extention on script only stack

[Greg (Pink) Miller via use-livecode]

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 , 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
>
___
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

Re: Embarrasssing old bugs

[Jjs via use-livecode]

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  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!? 
>
>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.
___
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

Re: Embarrasssing old bugs

[Klaus major-k via use-livecode]

Hi Bob,

> Am 14.01.2020 um 19:04 schrieb Bob Sneidar via use-livecode 
> :
> 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 
>>  wrote:
>> And now I have to tell him that after 5 (FIVE!) years we still do not have 
>> "system date" etc. on Android!? 
>> 
>> 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


___
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

Re: SQL(ite) question

[Bob Sneidar via use-livecode]

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 
>  wrote:
> 
> Hi Bob,
> 
>> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode 
>> :
>> 
>> 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


___
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

Re: SQL(ite) question

[Klaus major-k via use-livecode]

Hi Bob,

> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode 
> :
> 
> 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 
>  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


___
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

Re: Embarrasssing old bugs

[Bob Sneidar via use-livecode]

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 
>  wrote:
> 
> And now I have to tell him that after 5 (FIVE!) years we still do not have 
> "system date" etc. on Android!? 
> 
> As a result we cannot e.g. sort a datagrid by "sytem datetime" etc.


___
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

Re: SQL(ite) question

[Bob Sneidar via use-livecode]

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 
>  wrote:
> 
> Hi Sean,
> 
>> Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode 
>> :
>> 
>> 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 
  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
>>> 
> 

___
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

FYI: Cause found for LC crashing to desktop when Browser widget opens PDF

[Matthias Rebbe via use-livecode]

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.

A few days ago i mentionend in an answer to an other post, that   LC 9.5/9.6 
and also standalones created with that versions, but not LC8, crash to desktop 
when one opens a PDF in the Browser Widget. 

I contacted support, as i was pretty sure that this worked in the past.

As this only happened on my iMac, but not on my Macbook, i decided to 
completely erase the hard disk of my iMac and reinstall the OS and all needed 
LC stuff, because i had to finish some important work and waiting for an answer 
from support or continuing on the Macbook was not an option for me. 

I planned to install the other software one after the other  when i needed it.

All went well and the problem with the PDF in the widget did not happen 
anymore. Today i needed to install Acrobat DC for some tasks.
An hour later or so i received an answer from support and one question from Dev 
team was if by any chance Acrobat software is/was installed on my machine.

I tried again in LC and the crash happened again. After uninstalling Acrobat DC 
the crashes did not happen anymore. 

I reported this back to support.

Of course not using Acrobat DC anymore is no final solution, but for the moment 
it´s a workaround and hopefully the Dev team finds out what exactly is going 
wrong with.

Matthias




___
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

Embarrasssing old bugs

[Klaus major-k via use-livecode]

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!? 

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

Re: encrypting script-only stacks

[Richard Gaskin via use-livecode]

I use Nextcloud with my work folders, so backup with versions is 
automatic, and it keeps everything synced across my Mac, Linux, and Win 
boxes along with it.


But my needs are modest.  Because I rarely work in teams larger than 
three to five developers, and we assign tasks by skill focus so we 
rarely need to have two devs working on the same stack file at the same 
time, we rarely need automated merge assistance.  In the few cases where 
we have needed a merge, a prop diff and tossed-together script-diff have 
been sufficient.


I will be using Git more in 2020, though, for open source work, likely 
on Github (though I'm still considering Gitlab since it's open source 
itself).


Help me motivate to move my Git transition forward sooner:

Beyond backup across versions (since that's widely available in most 
cloud storage for even binary files), that Git features do you find most 
valuable?


--
 Richard Gaskin
 Fourth World Systems


Kaveh Bazargan 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




___
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

Re: encrypting script-only stacks

[Kaveh Bazargan via use-livecode]

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  • Twitter
 • LinkedIn

___
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

Re: encrypting script-only stacks

[Richard Gaskin via use-livecode]

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

Re: encrypting script-only stacks

[J. Landman Gay via use-livecode]

Wouldn't a binary script-only stack be the library stack we already have now?
--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com
On January 14, 2020 9:55:01 AM Richard Gaskin via use-livecode 
 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
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com

___
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

encrypting script-only stacks

[Richard Gaskin via use-livecode]

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
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com

___
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 author names

[hh via use-livecode]

See the "statistics" here:
http://forums.livecode.com/viewtopic.php?p=186723#p186723

___
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

Re: shell() and pdftotext

[hh via use-livecode]

> Richard H. wrote:
> Typing to Terminal „pdftotext“ I get a List with command-options. 
> With get shell(„pdftotext“) with and without quotes
> I get the answer „/bin/sh: line 1: pdftotext: command not found“
> What is wrong? May you please help? (MacOS Catalina).

You could add on startup /usr/local/bin
to the LC environment variable $PATH:

on startUp
  local ulb="/usr/local/bin"
  set itemdel to ":"
  if ulb is not among the items of $PATH
  then put ":"&ulb after $PATH
end startUp
___
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

Re: SQL(ite) question

[Klaus major-k via use-livecode]

Hi Sean,

> Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode 
> :
> 
> 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 
>>>  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
>> 
>>> On Jan 13, 2020, at 11:03 , Klaus major-k via use-livecode 
>>>  wrote:
>>> 
>>> Hi all,
>>> 
>>> I searched the docs of SQLite but could not find a hint.
>>> 
>>> Is it possible to create a "full text search" in SQL(ite)
>>> with ONE SQL command? Something like this (pseudocode):
>>> ...
>>> SELECT * from MyTable where ANY_COLUMN like "%mysearchtermhere%"
>>> ...
>>> ...

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