### Re: Divide Large Data Blob?

```OK so it appears there is a log2 property. The log2 of 1000 yields 9.965784 so
I suppsoe if you round up, that would give you the maximum number of iterations
to isolate a single line in a 1000 line sorted list.

Bob S

> On May 16, 2022, at 15:44 , Bob Sneidar via use-livecode
>  wrote:
>
> So this has got me thinking. Apparently what I am calling Divide and Conquer
> is really called a binary sort. I have looked up on the interwebs to
> calculate the maximum number of iterations for a given number of values, but
> it seems that all the formulas offered up use functions for C. I am trying to
> figure out what a basic math formula for this is, given n values.
>
> Bob S
>
>
>> On May 16, 2022, at 15:23 , Bob Sneidar via use-livecode
>>  wrote:
>>
>> A maximum of 7 recursions are necessary to isolate a single instance of 100
>> possible values. 1000 requires a maximum of 10. 1 values requires 14.
>> The idea is that for every factor of 10, you need roughly 3 more recursions.
>> This of course assumes the data is sorted, which in your case is sorted into
>> 3 containers. If you know the limits of how many lines can be garbage, and
>> how many can be valid data, you narrow your scope significantly.
>>
>> Livecode is pretty damn quick at parsing this kind of data. If there are
>> consistent delimiters (in this case a line break) then even 20 or 30
>> recursions is child's play.
>>
>> Bob S
>>
>>
>>> On May 16, 2022, at 15:00 , Bob Sneidar via use-livecode
>>>  wrote:
>>>
>>> Do you know exactly which lines you need to toss, or do you need to searc
>>> the data to find out where the beginning and end of the useful data is?
>>> If the former, then just put line x to y of your data into a new variable.
>>> If the latter, then a divide and conquer approach might be the answer. Get
>>> the line 30% in, test for valid, get the line 40% in, test, then 35% then
>>> 32.5% or 37.5% depending on your test.
>>>
>>> You may only have to do this a dozen or so times to find the exact line
>>> where your valid data begins.
>>>
>>> The other way of course is to get it all into a SQL database (how did you
>>> all know I was going to say that??) The downside is that you have to
>>> iterate through all your data once. The upside is a good one liner query
>>> statement may be all you need to process your data. And if you need to make
>>> multiple passes at your data, all the better.
>>>
>>> Bob S
>>>
>>>> On May 16, 2022, at 10:46 , Rick Harrison via use-livecode
>>>>  wrote:
>>>>
>>>> I have a large chunk of data that I want to
>>>> search as quickly as possible.
>>>>
>>>> Unfortunately the part I want to search is the
>>>> middle third of the data.  The other thirds at
>>>> the beginning and at the end are just junk and
>>>> slow down my search so I want to get rid of them.
>>>>
>>>> I don’t want to search line by line as that
>>>> takes way too long.
>>>>
>>>> There’s no unique character dividing any
>>>> of these data regions.
>>>>
>>>> What’s the best way to do this?
>>>>
>>>>
>>>> Rick
>>>>
>>>>
>>>>
>>>> ___
>>>> use-livecode mailing list
>>>> use-livecode@lists.runrev.com
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Divide Large Data Blob?

```So this has got me thinking. Apparently what I am calling Divide and Conquer is
really called a binary sort. I have looked up on the interwebs to calculate the
maximum number of iterations for a given number of values, but it seems that
all the formulas offered up use functions for C. I am trying to figure out what
a basic math formula for this is, given n values.

Bob S

> On May 16, 2022, at 15:23 , Bob Sneidar via use-livecode
>  wrote:
>
> A maximum of 7 recursions are necessary to isolate a single instance of 100
> possible values. 1000 requires a maximum of 10. 1 values requires 14. The
> idea is that for every factor of 10, you need roughly 3 more recursions. This
> of course assumes the data is sorted, which in your case is sorted into 3
> containers. If you know the limits of how many lines can be garbage, and how
> many can be valid data, you narrow your scope significantly.
>
> Livecode is pretty damn quick at parsing this kind of data. If there are
> consistent delimiters (in this case a line break) then even 20 or 30
> recursions is child's play.
>
> Bob S
>
>
>> On May 16, 2022, at 15:00 , Bob Sneidar via use-livecode
>>  wrote:
>>
>> Do you know exactly which lines you need to toss, or do you need to searc
>> the data to find out where the beginning and end of the useful data is?
>> If the former, then just put line x to y of your data into a new variable.
>> If the latter, then a divide and conquer approach might be the answer. Get
>> the line 30% in, test for valid, get the line 40% in, test, then 35% then
>> 32.5% or 37.5% depending on your test.
>>
>> You may only have to do this a dozen or so times to find the exact line
>> where your valid data begins.
>>
>> The other way of course is to get it all into a SQL database (how did you
>> all know I was going to say that??) The downside is that you have to iterate
>> through all your data once. The upside is a good one liner query statement
>> may be all you need to process your data. And if you need to make multiple
>> passes at your data, all the better.
>>
>> Bob S
>>
>>> On May 16, 2022, at 10:46 , Rick Harrison via use-livecode
>>>  wrote:
>>>
>>> I have a large chunk of data that I want to
>>> search as quickly as possible.
>>>
>>> Unfortunately the part I want to search is the
>>> middle third of the data.  The other thirds at
>>> the beginning and at the end are just junk and
>>> slow down my search so I want to get rid of them.
>>>
>>> I don’t want to search line by line as that
>>> takes way too long.
>>>
>>> There’s no unique character dividing any
>>> of these data regions.
>>>
>>> What’s the best way to do this?
>>>
>>>
>>> Rick
>>>
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Divide Large Data Blob?

```A maximum of 7 recursions are necessary to isolate a single instance of 100
possible values. 1000 requires a maximum of 10. 1 values requires 14. The
idea is that for every factor of 10, you need roughly 3 more recursions. This
of course assumes the data is sorted, which in your case is sorted into 3
containers. If you know the limits of how many lines can be garbage, and how
many can be valid data, you narrow your scope significantly.

Livecode is pretty damn quick at parsing this kind of data. If there are
consistent delimiters (in this case a line break) then even 20 or 30 recursions
is child's play.

Bob S

> On May 16, 2022, at 15:00 , Bob Sneidar via use-livecode
>  wrote:
>
> Do you know exactly which lines you need to toss, or do you need to searc the
> data to find out where the beginning and end of the useful data is?
> If the former, then just put line x to y of your data into a new variable. If
> the latter, then a divide and conquer approach might be the answer. Get the
> line 30% in, test for valid, get the line 40% in, test, then 35% then 32.5%
> or 37.5% depending on your test.
>
> You may only have to do this a dozen or so times to find the exact line where
>
> The other way of course is to get it all into a SQL database (how did you all
> know I was going to say that??) The downside is that you have to iterate
> through all your data once. The upside is a good one liner query statement
> may be all you need to process your data. And if you need to make multiple
> passes at your data, all the better.
>
> Bob S
>
>> On May 16, 2022, at 10:46 , Rick Harrison via use-livecode
>>  wrote:
>>
>> I have a large chunk of data that I want to
>> search as quickly as possible.
>>
>> Unfortunately the part I want to search is the
>> middle third of the data.  The other thirds at
>> the beginning and at the end are just junk and
>> slow down my search so I want to get rid of them.
>>
>> I don’t want to search line by line as that
>> takes way too long.
>>
>> There’s no unique character dividing any
>> of these data regions.
>>
>> What’s the best way to do this?
>>
>>
>> Rick
>>
>>
>>
>> ___
>> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Divide Large Data Blob?

```Do you know exactly which lines you need to toss, or do you need to searc the
data to find out where the beginning and end of the useful data is?
If the former, then just put line x to y of your data into a new variable. If
the latter, then a divide and conquer approach might be the answer. Get the
line 30% in, test for valid, get the line 40% in, test, then 35% then 32.5% or

You may only have to do this a dozen or so times to find the exact line where

The other way of course is to get it all into a SQL database (how did you all
know I was going to say that??) The downside is that you have to iterate
through all your data once. The upside is a good one liner query statement may
be all you need to process your data. And if you need to make multiple passes
at your data, all the better.

Bob S

> On May 16, 2022, at 10:46 , Rick Harrison via use-livecode
>  wrote:
>
> I have a large chunk of data that I want to
> search as quickly as possible.
>
> Unfortunately the part I want to search is the
> middle third of the data.  The other thirds at
> the beginning and at the end are just junk and
> slow down my search so I want to get rid of them.
>
> I don’t want to search line by line as that
> takes way too long.
>
> There’s no unique character dividing any
> of these data regions.
>
> What’s the best way to do this?
>
>
> Rick
>
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Sqlite and Monterey on M1

```Sandboxing. I don't think the latest Apple operating systems allow the writing
to the App Support folder, even if you have explicit write permissions. It's
better if you put the file into her documents folder somewhere. To answer the
question you are about to ask, it's likely that her old Mac OS was not current
enough to have the sandboxing limitations, and so it worked.

Bob S

> On May 12, 2022, at 10:10 , ludovic.thebault--- via use-livecode
>  wrote:
>
> ‌
>
> ‌
>
> ‌
>
>
> Hello All,
>
> I've made an macOS app for my sister that use an sqlite database located in
> the application support folder (~/library/Application Support/myApp/base.db)
>
> Since she replaced her old mac with an iMac M1, the app cannot write on the
> database. I've checked the permissions on the folder and the sqlite file and
> all seem ok.
> (-rwxr-xr-x for the database).
>
> The app is not notarized, but at first launch (I recompiled the app with
> Livecode 9.6.4), an alert to give permissions to the "document" folder is
> displayed (and accepted).
>
> What I miss ?
>
> Thanks !
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Re Pulldownmenu button bug on Windows

```I'm going to have a look at that Richard. Thanks.

Bob S

> On May 11, 2022, at 11:27 , Richard Gaskin via use-livecode
>  wrote:
>
> Neville Smythe wrote:
> > Thanks again Richard
> >
> > In my case I don’t actually need a workaround. Once I had corrected
> > my own error, the only effect of the inconsistent event order is that
> > on Windows and Linux the colour coding of the selection turns off a
> > fraction of a second earlier than on a Mac. I am not so obsessive as
> > to need to fix that.
>
> Glad you have a solution.
>
> Hopefully the demo I posted will be of use to others. Using stacks as menus
> are a poor substitute for text menus when all you need is text, but a wide
> range of graphical pickers can be made which can be very attractive and
> super-simple to make:
>
> Set the menuName property of a menu button to the short name of the stack you
> want to use as a menu, make sure the buttons you're using in the menu stack
> have their autoArm set to true, and all the normal menu behaviors you'd
> expect just work.
>
> Imagine icons used to represent a set of templates, or sample report output,
> or graphical effects, or anything else that lends itself well to a graphical
>
> I just updated the example stack this morning to include a simple graphical
> picker so folks could get a clearer idea of how it can be very useful:
>
>
> --
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: use-livecode Digest, Vol 224, Issue 8

```You can read for x characters then check the result for empty. So no you do not
need to read the entire file into memory.

Bob S

> On May 10, 2022, at 12:14 , Mark Clark via use-livecode
>  wrote:
>
> Thanks Tom, Mike and Craig. Sorry for the late response, I’m on the digest
> version.
>
> My thought was that an open file for read does not require placing the whole
> file into memory. Am I mistaken in that assumption? Seems like it would be
> nice to not use all of the available memory to run the decrypt. Results below
> seem to confirm this...
>
> I worked up a quick stack using the chunking notion I referenced in the
> original post and this seems to work fine. I compressed the Mac system folder
> on an old SSD. That directory was 8.9GB on disk. Compressing it with the
> Finder took about 28 minutes. Compressed size was 5.9GB.
>
> Using a byte range of 1048576 (1MB—small but useful for testing), I was able
> to read the source compressed file, encrypt and write to the new (encrypted)
> file in about 2 minutes. Decrypt took a little longer (less than 3 min).
> Memory utilization (I did a quick build of the stack) was 44-45MB during both
> operations. I’ll bump up the byte range and see how that compares.
>
>
>
> Thanks,
> Mark
>
>
>> On May 10, 2022, at 11:00 AM, use-livecode-requ...@lists.runrev.com
>>  wrote:
>>
>> there is no way to decrypt something that does not fit in memory. with 64
>> bit builds the limit is whatever the motherboard  supports.   on 32 bit
>> builds the limit is whatever the os will allow 1 process to have,
>> but then u need memory to store the decrypted data too.
>> you can use a command line program to outsource that work and memory
>> management.
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Re Pulldownmenu button bug on Windows

```Well put. I wonder what the real world effect of the order of messages is, and
whether or not it could be compensated for by send in time?

Sent from my iPhone

> On May 7, 2022, at 13:44, Richard Gaskin via use-livecode
>  wrote:
>
> ﻿It's definitely an inconsistency, but the bug's status as requiring "EXPERT
> REVIEW" prompts us to consider why these differences exist, and which, if
> any, should be considered "wrong" or "right".  It may not be as simple as it
> seems at first glance.
>
>
> Background:
> --
> MetaCard (the engine we now call LiveCode) was born on Unix, later ported to
> Windows, Linux, and then MacOS.
>
> On all platforms menus are implemented as selector buttons, buttons which
> provide the appearance and behavior of OS-provided menu objects.
>
> And until the port to MacOS, all platforms behaved consistently.
>
> So why the Mac change?
>
> Mac is unique among popular GUI OSes in its use of a global menu bar,
> attached to the top of the display; other OSes place the menu bar attached to
> the top of the window.
>
> Internally, LC menus are implemented as temporary dynamically-instantiated
> nameless stacks, which may seem counterintuitive until you realize that a
> menu is in essence a highly specialized form of window, a viewport
> independent of other windows with its own buffer, contents, and like all
> windows needs to use a common compositor for rendering them all together.
> (Indeed you can even use stacks as menus explicitly when you need a
> non-standard look, like a graphical picker, but that's another topic).
>
> So the engine's method of using a subclass of the stack object for rendering
> menus worked well and consistently for a great many years - until the port to
> MacOS.
>
> The Mac global menubar required a deep rethink on how menus are handled, not
> only in terms of detaching them from the window but also in terms of the
> nuances of display and interaction.
>
> So Dr Raney special-cased menus on MacOS, so the engine uses OS routines to
> render those, fed by the menu button properties for things like the menu name
> as parameters to those OS routines. On every other platform you're
> interacting with a LiveCode object, but on Mac you're interacting with a
> system object into which the engine has inserted some hooks to tie it in with
> your scripting so you can at least know when an item has been selected.
>
> This rewiring of properties and messages is no small feat, and has pervasive
> effects.  So from time to time you'll find Mac-specific things needed to
> exist in your stack (the Mac's "Application" menu belongs to the OS).
>
> It's not surprising that messages related to menu objects also have some
> inconsistencies along with everything else.
>
> If we consider that on all other platforms the menu object we're interacting
> with is a button, and the menus that appear are a stack, the messaging you
> see with Windows and Linux is consistent with other button object messaging:
> once the mouse leaves the control the mouseLeave message is sent.
>
> On Mac we have an exception to LC's normal button messaging because we're not
> interacting with an LC button at all, but with a system object, into which
> the engine devs have grafted just enough messaging to trigger actions from
> scripts.
>
> I have no opinion on qualitative labels like "right" or "wrong" on this; that
> seems a matter of personal familiarity and taste. It may even be somewhat
> philosophical: is a menu a single thing that expands, or two things (menu and
> items) where one triggers the appearance of the other?
>
> All I can do is help describe the under-the-hood parts to help makes sense of
> how the difference came about.
>
>
>
> The Here-And-Now:
>
> Whether or not we prefer it, the menu architecture is what it is, at least at
> the moment. Changing the behavior on all other platforms to be like Mac, or
> Mac to be like all other platforms, would be a scope of work that I'd guess
> the team would not be in a position to make a priority any time soon, even if
>
> They have a lot on their plates, and for all the questions we see regarding
> and "Preferences" items to system menus separate from the menu objects where
> we're asked to put them), I can't recall seeing a message here before about
> mouseLeave.
>
> I'm not saying it isn't important. It might well be. But observably this
> affects few; AFAIK this is the first such request in the 23 years I've been
> using this engine and participating in its communities. Just the same, let's
> roll up our sleeves and see what can be done:
>
>
>
> Looking Forward:
> ---
> Edge case or not, let's see what we can do to get a solution for ```

### Re: Anybody tried to import data to Quicken for Mac?

```Is QIF a text based format, or is it encrypted? If the latter (and it probably
is), it is doubtful that there is a way to do this without software (of which
there are some options if you google it).

Bob S

> On May 6, 2022, at 13:40 , William Prothero via use-livecode
>  wrote:
>
> Folks:
> I have a nasty accounting problem and need to somehow get data into Quicken
> (or perhaps find another management program). My question is whether it’s
> possible (or known) how to take csv data (easy) and convert to acceptable QIF
> form, which quicken requires.
>
> Best,
> Bill Prothero
>
> William Prothero
> waproth...@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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Zip file problem on Mac

```Should be an enhancement request.

Bob S

> On May 6, 2022, at 24:09 , matthias rebbe via use-livecode
>  wrote:
>
> Hm,
> is it really a bug  or does revZip just stick to the zip specs?

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Zip file problem on Mac

```Open a bug report and I will +1 it.

Bob S

> On May 4, 2022, at 15:35 , matthias rebbe via use-livecode
>  wrote:
>
> Neville, i can confirm that behavior even under BigSur.
>
> I've created a small standalone with LC 10DP3 on BigSur and created  2  zip
> files  from the output folder using LC's zip library and using shell command
> zip.
>
> Running the shell command 'zipinfo' to analyse both zip files showed, that
> the zip created with LC's zip library did not contain any executable
> permissions while the zip created with macOS zip shell command did contain
> the permissions.
> So it seems the LC's zip library does not store the permissions in the zip.
>
> According to your comment about The Unarchiver. Yes, i can also confirm that
> The Unarchiver and also Keka can extract the zip file created with LC and the
> standalone in the extracted folder is executable again.
> But...
> As zipinfo did list all the files wihtout any executable permissions, i
> unzipped the zip with the shell command 'unzip' and that standalone was not
> executable again. All files showed exact those permissions that zipinfo
> showed before.
>
> So i assume the following: Keka and The Unarchive seem to correct file
> permissions when they detect a folder structure that seems to be an app
> bundle. But that's just an assumption.
> At least Keka seems to have such feature according to its change log Changes
> in version 1.0.11
>
>
> But anyway. The LC zip library ignores the permission when creating an
> archive.  If this worked before with older versions of LC  i cannot say, as i
> always used the zip shell command or tools like Keka.
>
>
> Matthias
>
>
>> Am 04.05.2022 um 16:47 schrieb Neville Smythe via use-livecode
>> :
>>
>> I distribute a Mac standalone via a zip file, created using
>> revZipOpenArchive etc.
>>
>> This has worked fine until macOS Monterey or LiveCode 9.6.x
>>
>> Either a bug has been introduced into the revZip tools in 9.6.x, or I have a
>> corrupted version, or the Mac Archive Utility has changed so as to make the
>> rev zip tool fail. Can anyone verify the following?
>>
>> On my Mac, the Archive Utility in Monterey, which automagically unzips files
>> when a zip file is downloaded by Safari or double-clicked, now unsets the
>> execute bit on the application (more precisely, on the executable file in
>> the bundle). Which means the user gets a “This application could not be
>> opened”, with no options to continue, when they try to launch the unzipped
>> app. A terminal savvy user can use chmod x+ to make the app launchable, but
>> I can hardly expect the ordinary user to have to do that. The execute bit is
>> definitely set in the archive, because TheUnarchiver, a free third party
>> decompression tool, unzips the file leaving the app launchable. This also
>> suggests that the problem is not in my code.
>>
>> I can see why Granny Apple might have thought this was a good idea,
>> executables in zip files are a the major sources of trojans, but if Apple
>> has made this change it is a bit nasty because there is no obvious way to
>> override the behaviour.
>>
>> If I use the Archive Utility to actually create the zip file from the
>> standalone app bundle rather than using the rev tools, and then double-click
>> it to decompress, the file unzips with the execute bit set. This shows the
>> archive produced by revZip is not the same as that expected by the Archive
>> Utility. It also suggests  a workaround would be to use Archive Utility from
>> a shell command (it is not AppleScriptable – bad Apple!). From a cursory
>> search on Stackoverflow,  the command line would be (this is not yet tested
>> and the post is 5 years old)
>>
>> ditto -c -k --sequesterRsrc --keepParent Product.app Product.app.zip
>>
>> to create the zip file for the Mac platform. The post says that is what the
>> Archive Utility uses to compress files. Probably  the rev zip tools use
>> zlib. Or maybe I should be creating a .dmg disk image instead of a zip file.
>>
>> Neville
>>
>>
>> ___
>> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: getProp and passing values

```NVM I figured it out (again). Given that lGridDataA is a script local
containing an array of all the datagrid arrays: The getProp handler needs to be
written like this:

getProp maingriddata [pKey]
if pKey is not empty then
return lGridDataA [pKey]
else
return lGridDataA
end if
end maingridData

Bob S

> On May 3, 2022, at 15:00 , Bob Sneidar via use-livecode
>  wrote:
>
> Hi all.
>
> I seem to recall the ability to define a virtual custom property in such a
> way that I could for example code:
>
> put the maingriddata ["customers"] of card "Main" into tCustomersA
>
> As is I cannot pass args to a getprop handler. I can only pass args to a
> setProp handler.
>
> Any ideas? I checked the dictionary and lessons. Not a peep.
>
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### getProp and passing values

```Hi all.

I seem to recall the ability to define a virtual custom property in such a way
that I could for example code:

put the maingriddata ["customers"] of card "Main" into tCustomersA

As is I cannot pass args to a getprop handler. I can only pass args to a
setProp handler.

Any ideas? I checked the dictionary and lessons. Not a peep.

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: devcon 2022 recap

```Thanks for the Clarification Mark. I'm curious, is there a way to connect to
data sources other then the Appli cloud storage? I ask because this was looking
like a really good way to port a reduced functionality version of my Forms
Generator to some kind of web portal without actually having to develop the web
side of things. If I could demonstrate the ability to generate signable PDFs, I
might be able to convince my employer to sign up for this.

Bob S

> On Apr 28, 2022, at 17:46 , Mark Talluto via use-livecode
>  wrote:
>
> Hi Everyone,
>
> We should have Appli forums in the coming week or so. I’ll try to keep
> Appli-related responses to a minimum.
>
> Appli comes in two parts.
> Part 1 - Appli IDE runs as a desktop app that you can download from appli.io.
> Interesting note: We designed the IDE to work on desktops and tablets like
>
> Pat 2 - Appli Player is available from Google Play and iOS app stores.
>
> Appli makes native apps only. They feel like web apps because they use the
> cloud for distribution and data storage. We are looking to support the web
> export feature in LC 10 when it is feasible to do so.
>
> No-code and low-code
> These are fun words that do not mean much. I said they are great buzz words
> to have on hand in my conference presentation. :)
>
> We have wizards that can do complex actions with a few clicks. We also have a
> list of actions that you can drag onto a workflow that effectively replaces
> typing code. The killer feature is that you can use actual LiveCode scripts
> in Appli.
>
> Canela and LiveCode have partnered to bring a different type of tool for app
> makers to market. Our collaboration aims to get more people into the LiveCode
> community. We believe that a larger community will benefit everyone. This
> summer, we will execute a marketing plan for people outside our beloved LC
> community to try Appli. We will do our best to excite people to take full
> LC IDE (no standalone building).
>
> Our mutual hope is that new people will try Appli and eventually fall in love
> with LiveCode. These developers will see Appli, LiveCloud, and LiveCode as a
> suite as tools to help them make apps.
>
> Licensing Appli means you are also financially supporting LiveCode. We do not
> want to generate any uncomfortable friction by providing an alternative
> method for making apps. Since day one of its existence, we have been LiveCode
> developers and, long before, with MetaCard. Appli is made 100% in LiveCode.
> It is a comprehensive example of a complex solution made in LiveCode.
>
> The LiveCode team has plans to express the goals of our suite soon. When they
> announce, I am confident they will clearly articulate the value proposition.
>
> If anyone has Appli questions, please feel free to write us at
> he...@appli.io.
>
> -Mark Talluto
>
>> On Apr 28, 2022, at 2:03 PM, Bob Sneidar via use-livecode
>>  wrote:
>>
>> Well I downloaded the Appli app. The starting level is \$45 / month, and
>> storage is pretty sparse, which I can pay more for later. Doesn't look cost
>> effective for me when I could just create my own web portal.
>>
>> Bob S
>>
>>
>>> On Apr 28, 2022, at 13:58 , Richard Gaskin via use-livecode
>>>  wrote:
>>>
>>> Yes, but that's something of an "expert feature" in that intended market,
>>> much like coding externals for LC.
>>>
>>> In terms of general product flavor and intent, LC is "low code" and Appli
>>> is "no code".
>>>
>>> Given the clear mission for each, they seem good compliments.
>>>
>>> --
>>> 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
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: devcon 2022 recap

```Well I downloaded the Appli app. The starting level is \$45 / month, and storage
is pretty sparse, which I can pay more for later. Doesn't look cost effective
for me when I could just create my own web portal.

Bob S

> On Apr 28, 2022, at 13:58 , Richard Gaskin via use-livecode
>  wrote:
>
> Yes, but that's something of an "expert feature" in that intended market,
> much like coding externals for LC.
>
> In terms of general product flavor and intent, LC is "low code" and Appli is
> "no code".
>
> Given the clear mission for each, they seem good compliments.
>
> --
> Fourth World Systems

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: devcon 2022 recap

```Richard, I've been pounding the pulpit on this one for some time. Besides the
default datagrid behavior, I have a whole library of handlers that I use for my
datagrids that I need to access. To do this, I need my library to be inserted
*between* the datagrid and the default behavior. This is not presently possible
without a bit of magic someone sent to me.

The fix is simple and elegant and has worked for me since I started using it.
In behaviorsdatagridbuttonbehavior.livecodescript I replaced the private
function _resourceStack handler with an updated one:

-- Sly Labs! Inline Custom Behaviors
/*
private function _ResourceStack
local theStack, theCharNo
put the behavior of me into theStack
if theStack is not empty then
put offset(" of stack", theStack) into theCharNo
delete char 1 to (theCharNo + 3) of theStack
end if

return theStack
end _ResourceStack
*/

local sResourceStack

private function _ResourceStack
local theStack, theCharNo

if sResourceStack is empty then
put the behavior of me into theStack

repeat
if trueWord -1 of theStack is "revDataGridLibrary" or theStack is
empty then
exit repeat
else
put the behavior of theStack into theStack
end if
end repeat

if theStack is not empty then
put offset(" of stack", theStack) into theCharNo
delete char 1 to (theCharNo + 3) of theStack
end if
put theStack into sResourceStack
end if

return sResourceStack
end _ResourceStack

-- END Sly Labs! Inline Custom Behaviors

If I then set the behavior of the datagrid to my custom behavior, then set that
behavior to the default datagrid behavior, then I have nested datagrid
behaviors. (I think it's a bit more complex but that is the idea.)

What's the advantage you say? Well for instance I have a selectionChanged
hander that I use for all my datagrids, preventing me from having to code it in
every datagrid in my app, which is quite a few. That selectionChanged handler
accomodates a FindBar object so if I am searching for a data record in a
database, selecting the found record in the datagrid will reload all the other
associated data.

Also in that behavior I have a standard method for querying data for the
datagrids, a standard method for populating fields, buttons and menus on the
card the datagrid is on, and a mouseDoubleUp handler so that when a user double
clicks on a datagrid row I can process it. These use custom properties I set
for each datagrid so that things like the table to query, the primary key, the
field to focus on when done etc. are accessible to the particular datagrid.

As a result, all I have to do now to create a new datagrid is copy/paste an
existing one, name it, change a few custom properties, and set the column
names, and away it goes. I suppose what would be needed to support this in the
release versions of LC is a way to easily "insert" a behavior "before" or
"after" the default behavior.

Bob S

> On Apr 28, 2022, at 12:57 , Richard Gaskin via use-livecode
>  wrote:
>
> Mike Kerner wrote:
>
> > * This wasn't discussed, but there is supposed to be some
> > fixing coming in dp's of 10 for behaviors, especially
> > nested behaviors
>
> I missed a bug report: what are the issues with nested behaviors?
>
>
> > * Still nothing on dealing with the way groups are handled.
>
> What aspects of group handling, and how should they be different?
>
> --
> Fourth World Systems
> Software Design and Development for the Desktop, Mobile, and the Web

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: devcon 2022 recap

```NVM I found it. Not on the app store.

Bob S

> On Apr 28, 2022, at 13:26 , Bob Sneidar  wrote:
>
> That looked really interesing to me. The ability to create a no code web app
> was especially intriguing. I was not able to find the app on the Apple Store
> though. Where do I get the 45 day demo??
>
> Bob S
>
>
>> On Apr 28, 2022, at 12:02 , Mike Kerner via use-livecode
>>  wrote:
>>
>> * The whole low-code piece...meh. It feels like they're chasing another
>

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: devcon 2022 recap

```That looked really interesing to me. The ability to create a no code web app
was especially intriguing. I was not able to find the app on the Apple Store
though. Where do I get the 45 day demo??

Bob S

> On Apr 28, 2022, at 12:02 , Mike Kerner via use-livecode
>  wrote:
>
> * The whole low-code piece...meh. It feels like they're chasing another

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: devcon 2022 recap

```Anytime I get to thinking I'm a pretty smart guy, I can just watch one of Mark
Waddingham's sessions, and be duly humbled. ;-)

Bob S

> On Apr 28, 2022, at 09:06 , Mark Smith via use-livecode
>  wrote:
>
> I thought it was a pretty good conference Mike, and surprisingly well handled
> by Zoom (although it took me 3 days to figure out what all the bits and
> pieces of the interface were for) and there were some pretty great
> presentations. Some I had to miss because of other commitments so I’ll be
> looking forward to watching them post-conf when Heather has a chance to
> upload them. There were a lot of very forward looking sessions from Kevin and
> company, and Mark Talluto had an interesting take on app development
> presented during his plenary (Appli.io ). Lots of ideas I
> think on how things could be improved or, as Mark said “made as simple as
> possible, but no simpler” (or maybe that was Einstein!!). Either way, great
> quote/comment. Like Matthias, I signed up for the LC Global 22/23 just so I
> could keep up with it all during the coming year.

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Curved text possible?

```Great ideas Martin. I'm going to grant you an honorary doctorate from the
institute of Sly Laboratories.

Bob S

> On Apr 28, 2022, at 08:10 , Martin Koob via use-livecode
>  wrote:
>
> I was thinking that SVG might work as someone else has said.
>
> At first I thought you could create individual files for each letter and
> number and put the path for a letter into a svg widget which you could rotate
> or scale.
> you would then have to calculate the angle of rotation and location of each
> svg widget on a path.   But then when I tried rotating the svg widget its
> scale would change as it rotated because the bounds of the rect were
> changing. Then you would have to calculate the scale depending on the
> rotation angle and that seemed a bit much.
>
> I also thought you could import the svg file as an image and perhaps that
> would not have the odd behaviour when rotating.  I did not try that though.
>
> Then I found this.
>
> https://css-tricks.com/snippets/svg/curved-text-along-path/
>
>
> it shows how to use css to put text along a SVG path.  At the LiveCode Dev
> Con there were a few unconventional uses of the browser widget beyond
> displaying webpages that add features that can add features that LiveCode
> does not have natively.  So I thought maybe this is one of them.  So what I
> thought could be done is display the above in a browser widget or,  If you
> did not want to show the browser widget, use the browser widget to render the
> curved text, thentake a snapshot of the rendered text and then show that in
> an image.
>
> Not sure if it will work but the sessions at the conference have really got
> me thinking of new ways to leverage the technology in that widget.
>
> Martin Koob

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Single Window LC IDE?

```I watched the keynote by Kevin, and I think all your concerns are slated to be

Bob S

> On Apr 27, 2022, at 09:24 , Paul Dupuis via use-livecode
>  wrote:
>
> On 4/27/2022 11:58 AM, J. Landman Gay via use-livecode wrote:
>> I like the new look very much, but most of us old timers have specific
>> requirements which LC agrees they want to accommodate.
>
> I'm fine with the IDE being either multi-window or single-window. I've worked
> with both in the past and can adapt to either.
>
> I would REALLY like language support for easier layouts, from groups (or
> views) with built-in slidable dividers (H & V) to easier way to set up
> resizable groups or controls. The geometry manager is not idea and coding by
> hand gets exact results but is time intensive. Language support for
> "tearable" or "dockable" windows is another HIGHLY desired enhancement.
>
> 80% of our development time is on the UI. We're a data analytics product.
> Much more of our developer time should be on the data analysis code for new
> analytical features not  simply making the UI work.
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Advantages of Memory based sqLite databases

```So I tested this when I got in the shop this morning. The memory database is
roughly 450:1 over an sqLite database on the LAN. That is incredibly
significant, if the goal is to start with a certain dataset, then query it over
and over.

Bob S

> On Apr 21, 2022, at 19:52 , Bob Sneidar via use-livecode
>  wrote:
>
> Hi all.
>
> Just an exercise in semi-futility here. I was curious about the actual
> difference in performance between querying a memory based sqLite database, as
> opposed to querying a mySQL database over a slow (iPhone hotspot) connection.
> I expected it to be significant, but HOW significant I had no idea.
>
> Querying for one record produced a performance ratio of 2600 to 1. Some will
> say, "Of course! What did you expect?" That is just the point. Many people
> assume repeated queries of an SQL database over a network to be tolerable,
> even if the connection is remote. But what if your application needs to make
> repeated queries? At some point, the overhead of repeated queries will exceed
> that of querying for all or a subset of the data once, storing it in a memory
> database, then performing your repeated queries on the memory database
>
> I will test this over a LAN connection when I get into work tomorrow, but I
> expect it to be, if not AS significant, certainly more that one would expect.
>
> Just food for thought.
>
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Advantages of Memory based sqLite databases

```I made a client server proof of concept which encrypted messages before sending
and decrypted them on the other end. The upshot was that I can send an
encrypted query string from the client to the server, the server which handles
the database connection stuff performs the query, then returns the data as an
encoded array, also encrypted of course. It worked a peach. It can be used for
anything. Sending Files to a remote server for example. It uses simple sockets
for the connection, and I use a unique method for poisoning the payload so it
cannot be cracked without having the poison pill, or the antidote as it were.
And if you have that, I am likely dead.

Sent from my iPhone

> On Apr 21, 2022, at 20:04, doc hawk via use-livecode
>  wrote:
>
> ﻿The difference between :memory: and the local hard disk is, in itself,
> stunning.
>
> I initially set up with mysql, and (iirc) disk sqlite.
>
> Whether it’s mysql or livecode’s fault, it isn’t (wans’t?) possible to to do
> a compound transaction to a mysql server.
>
> So when I opened a “file” (a couple of tables per debtor for my software), it
> took *minutes* on a remote server to do what took a couple of seconds for a
> local sqlite file.
>
> And an in-memory database was instantaneous.
>
> If you need remote, there is a very many to one difference between Postgres
> (which can handle a transaction of several hundred queries at once) and mysql
> (which requires several hundred queries in sequence, with full latency
> applied to each one).
>
> And another huge boost for going to in-memory sqlite.  (Don’t believe the bit
>
> So I settled on a remote Postgres, in which I stored the commands to update
> the in-memory sqlite.
>
> The catch, of course, is that livecode never implemented the encrypted
> connection that Postgres supports out off the box.
>
> If I was going to continue, I’d probably go to a local Postgres server on
> each machine with REPLICATE, and stay with in-memory sqlite—but barring any
> surprises, I’ll just retire instead.
>
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Advantages of Memory based sqLite databases

```Hi all.

Just an exercise in semi-futility here. I was curious about the actual
difference in performance between querying a memory based sqLite database, as
opposed to querying a mySQL database over a slow (iPhone hotspot) connection. I
expected it to be significant, but HOW significant I had no idea.

Querying for one record produced a performance ratio of 2600 to 1. Some will
say, "Of course! What did you expect?" That is just the point. Many people
assume repeated queries of an SQL database over a network to be tolerable, even
if the connection is remote. But what if your application needs to make
repeated queries? At some point, the overhead of repeated queries will exceed
that of querying for all or a subset of the data once, storing it in a memory

I will test this over a LAN connection when I get into work tomorrow, but I
expect it to be, if not AS significant, certainly more that one would expect.

Just food for thought.

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

```Hi all.

I just wanted to alert anyone working with memory databases. Normally when you
call revOpenDatabase("sqLite", filename) it will open the sqLite database with
all the tables and data intact. HOWEVER... If you do this with ":memory:"
instead of a filename then EACH TIME you call revOpenDatabase() it will create
a NEW MEMORY DATABASE! I had no idea this was possible. I don't see anything in
the dictionary about it. In fact, :memory: does not even show up in the
dictionary! LOL!

I had to update my arrayToSQLite handler with an additional parameter, pDBID,
and I only call revOpenDatabase() if that parameter is empty.

Here is an updated version in case anyone is using it (however unlikely) :

/*
The following function will attempt to open a database passed in pDBFile, which
should be the full path to an sqLite
database file, or else a memory database. It will then *attempt* to drop the
table passed in pDBName. It will leave
other tables intact, so tables can be added and dropped as needed by calling
this function. pArrayDataA must be a
2 dimensional numbered array, such as the kind used by datagrids. Nested arrays
are not supported. provide pDBID
if there is already a memory database open.
*/
FUNCTION arrayToSQLite pArrayDataA, pDBFile, pDBName, pDBID
put the keys of pArrayDataA into tArrayKeys
sort tArrayKeys numeric ascending
IF pDBFile is empty THEN put ":memory:" into pDBFile
IF pDBName is empty THEN put "arraydata" into pDBName

TRY
if pDBID is empty then \
put revOpenDatabase("sqlite", pDBFile) into pDBID

IF "Error" is in pDBID THEN
return empty
END IF

put "drop table " & pDBName into tDropSQL
revExecuteSQL pDBID, tDropSQL
put  the result into tResult
CATCH tError
IF the environment is "development" THEN exit to top ELSE quit
END TRY

-- create the table
put "create table" && quote & pDBName & quote \
& cr into tCreateCommand
put "(" & quote & "recordid" & quote && "NUMERIC PRIMARY KEY UNIQUE, " \
& cr AFTER tCreateCommand

put the keys of pArrayDataA [1] into tRecordKeyList

REPEAT for each line tRecordKey in tRecordKeyList
if pArrayDataA [1] [tRecordKey] is an array then
put "BLOB" into tColumnType
else
put VARCHAR into tColumnType
end if

put quote & tRecordKey & quote && tColumnType & "," && cr AFTER
tCreateCommand
END REPEAT

delete char -3 to -1 of tCreateCommand
put ")" AFTER tCreateCommand

TRY
revExecuteSQL pDBID, tCreateCommand
put the result into tResult
IF tResult is not 0 THEN breakpoint
CATCH tError
breakpoint
END TRY

put 1 into tRecordCounter
put "recordid" & cr & tRecordKeyList into tColumns

repeat with i = 1 to the number of lines of tColumns
put ":" & i into item i of tColumnList
end repeat

put "(" & tColumnList & ")" into tColumnList

-- insert data
REPEAT for each line tKey in tArrayKeys
put 1 into tColumnCounter
put pArrayDataA [tKey] into tRecordDataA
put tRecordCounter into tQueryDataA [1]

REPEAT for each line tRecordKey in tRecordKeyList

if tRecordDataA [tRecordKey] is an array then
put arrayEncode(tRecordDataA [tRecordKey]) into tValue
else
put tRecordDataA [tRecordKey] into tValue
end if

put tValue into tQueryDataA [tColumnCounter]
END REPEAT

put "insert into" && pDBName &&  "VALUES" && tColumnList into tInsertSQL

TRY
revExecuteSQL pDBID, tInsertSQL, "tQueryDataA"
put the result into tResult
if the result is not a number then breakpoint
CATCH tError
breakpoint
END TRY

END REPEAT

return pDBID
END arrayToSQLite
___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Encountering slow navigation to a card containing very large fields? Do this one simple trick

```Let me know off list if you want to have a look at the handlers I have written
for getting data from a datagrid array into a memory database and back again so
your queries can be more efficient.

Bob S

> On Apr 21, 2022, at 04:50 , David V Glasgow via use-livecode
>  wrote:
>
>
> Thanks to all who responded on this.  I will definitely take a look at
> Datagrids as a possible solution.  Both Phil and Jim suggested avoiding
> navigation completely …. which I will also investigate.
>
> Cheers
>
> David G
>
>> On 21 Apr 2022, at 2:23 am, Jim Lambert via use-livecode
>>  wrote:
>>
>>> DavidG wrote:
>>> That is exactly it, Craig!  Text processing and field responsivity on the
>>> card containing the fields are as fast as I could hope.
>>>
>>> It is simply navigating back to the card containing the fields that can
>>> take several seconds, depending on how much text is in the fields.  The
>>> workaround is to have invisible groups containing the field(s) placed on
>>> the card you are navigating from.
>>
>> Here's another possibility.
>> Instead of using multiple cards, do the whole interface on a single card.
>> Have different groups on that single card, each of which does the job of one
>> of the eliminated cards.
>> In that way you NEVER NAVIGATE away from your data fields. They are simple
>> present in a now hidden group.
>>
>> For example, let's say your stack currently has 5 cards.
>> Card #1 is the card with the two data fields you describe.
>> Put those fields and any other interface elements currently on that card
>> into Group #1 of the card.
>> Put the contents of cards 2 thru 5 into groups #2 thru 5 on card #1.
>> Hide and show groups where you previously navigated between cards.
>>
>> Jim Lambert
>>
>> ___
>> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Standalone Error Dialog

```Ya that is the first place I looked. I even re-added them all one by one. In a
prior version of Livecode (I couldn't say which now) this did not happen. When
I first noticed it, I went back to that prior version and built a standalone
and it did not happen.  I can ive with it.

Bob S

> On Apr 12, 2022, at 14:32 , J. Landman Gay via use-livecode
>  wrote:
>
> Double check the files in the Copy Files pane of the standalone settings and
> make sure that the file paths are correct. I'm not aware of a log file for
> the builder.
>
> --
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software | http://www.hyperactivesw.com
> On April 12, 2022 4:19:16 PM Bob Sneidar via use-livecode
>  wrote:
>
>> Hi all.
>>
>> Some time ago I began getting an error dialog reporting:
>>
>>
>> This apparently is not causing any issues that I have found, but I would
>> sure like to find out what is causing it and stop it.
>>
>> Is there a Standalone Builder log I can look at?
>>
>> 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
>
>
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Standalone Error Dialog

```Hi all.

Some time ago I began getting an error dialog reporting:

This apparently is not causing any issues that I have found, but I would sure
like to find out what is causing it and stop it.

Is there a Standalone Builder log I can look at?

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Localizing e.g. "Answer dialog" featuzre reques = hibernated?

```That is a very loose translation. ;-)

Bob S

> On Apr 12, 2022, at 11:24 , Klaus major-k via use-livecode
>  wrote:
>
> Hi all,
>
>> Am 12.04.2022 um 20:15 schrieb matthias rebbe via use-livecode
>> :
>>
>> Maybe I would agree, too,  if I understood what Richmond wrote. ;)
>> Tried even Google translate for  Scottish to German. No success... :)
>
> he wrote:
> Cannot say anything to this issue, but must confuse the list or I will
> lose my good reputation otherwise.
>
> :-D :-D :-D

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Localizing e.g. "Answer dialog" featuzre reques = hibernated?

```My thoughts exactly!

Bob S

> On Apr 11, 2022, at 11:00 , Richmond Mathewson via use-livecode
>  wrote:
>
> Ah cud spak , an, aiblins it micht be mensefu, anent ither leids, but Ah
> jalouse that fowk widnae thole war jalouse qhat Ah wis ettlin an speiran
> eftir.
>
> On Mon, 11 Apr 2022, 20:52 Klaus major-k via use-livecode, <
> use-livecode@lists.runrev.com> wrote:
>
>> Hi all,
>>
>> some time ago I "feature requested" a possibility to localize e.g. the
>>
>>
>> Example:
>> Cancel = english, which is always displayed currently
>> Annuler = french
>> Abbrechen = german
>> All these are much longer words, so just setting the label of that button
>> will not suffice.
>> Bernd Niggeman provided a nifty solution for this inconvenience.
>>
>> But why on earth has this been "Hibernated"?
>>
>> Don't we all think that we should be able to localize all aspectcs of LC?
>> Not the whole world is speaking english, ladies and gentlemen!
>>
>> Maybe you want to add a comment, thank you!
>>
>>
>> Best
>>
>> Klaus
>> --
>> Klaus Major
>> https://www.major-k.de
>> https://www.major-k.de/bass
>> 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
>>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Widget properties

```Poor Widget. The bastard child of Livecode objects.  ;-P

Bob S

> On Apr 6, 2022, at 16:39 , Richard Gaskin via use-livecode
>  wrote:
>
> Monte Goulding wrote:
>
> > ...there has never been any intention of supporting the properties
> > for widgets as far as I’m aware...
>
> If the company wants widgets to be seen as first-class citizens, a little
> more conformity with existing object syntax would go a long way to making
> that happen.
>
> It's possible for the engine to derive a set of widget properties. If it's
> not also possible to map that into how "the properties" works that would be
> very enlightening.
>
>
> FWIW I've had requests to update my 4W Property Sheet tool to special-case
> for widgets. I tell people I'll take widgets seriously when the company does,
> and if they do I won't need to update my tool because the existing call to
> "the properties" that works for everything else will work for widgets.
>
> Maybe I've been overestimating the importance of widgets to LC Ltd. Guidance
> welcome.
>
> --
> Fourth World Systems
> Software Design and Development for the Desktop, Mobile, and the Web

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: drawingSvgCompileIcon(pIconName) always BLACK

```Sounds a little like the old bug where a PNG would draw as black if it had an
Alpha channel.

Bob S

> On Apr 6, 2022, at 06:23 , Klaus major-k via use-livecode
>  wrote:
>
> Hi all,
>
> drawingSvgCompileIcon(pIconName) is really great,
> but the resulting images are always black.
>
> I can of course add a "color overlay" but when I use them as
> "imagesource" it uses the original black images.
>
> Any hints on how to add color to them when using them
> as "imagesource" in a field without screenshotting them or
> exporting them, add color in an image editing app and
> reimport them as images?
>
> Thanks for any hint!
>
>
> Best
>
> Klaus
> --
> Klaus Major
> https://www.major-k.de
> https://www.major-k.de/bass
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Flash Talks - 3 slots remaining

```I'm in.

Bob S

> On Apr 5, 2022, at 13:36 , Mark Wieder via use-livecode
>  wrote:
>
> On 4/5/22 10:36, Craig Newman via use-livecode wrote:
>
>> But I do use LC to control three very different machines in our shop. Would
>> it be of any interest to anyone to see one of these in operation?
>
> Add me to the list of interested folks.
>
> --
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Tools & techniques for one-off consolidation of multiple 'similar' CSV files?

```Okay no answer to my question so here is why I ask. SQL databases typically
have a limit on how many columns you can have, and how many total bytes a
record will take. If it is possible to import each CSV file as a separate
table, that would be ideal. If not you need to make yourself aware of those
limits, and if you are going to exceed them, then SQL is not the way to go.

CSV format is OK if the text fields are enclosed in quotes, and the numeric
fields can be enclosed in quotes or not, it doesn't matter. If text fields ARE
enclosed in quotes, then Excel should be able to open it natively, even if
there are commas in the field text, that is not as delimiters. Id the fields
are NOT enclosed in quotes, and the field text DOES contain commas, you are
essentially screwed.

Bob S

> On Apr 4, 2022, at 10:37 , Bob Sneidar via use-livecode
>  wrote:
>
> Does all the data need to be in a single table?
>
> Sent from my iPhone
>
>> On Apr 4, 2022, at 10:31, Mike Kerner via use-livecode
>>  wrote:
>>
>> ﻿keith,
>> are all the files structured the same way? are they all gathered in the
>> same place?
>> LC's big strength, IMHO, is text handling, so you're right in its
>> wheelhouse.
>> for the simplest example, let's assume that all the files have all the same
>> column layout and they're all in the same folder.
>> in that case, you would
>> * grab the list of files in the folder
>> * exclude files that shouldn't be included - maybe filter everything
>> that doesn't have a .csv suffix. you could do this during the loop, below,
>> * iterate through the files by reading each one, and appending the contents
>> to a variable/container (if you do this, don't forget to make sure that
>> when you append each file, the last line ends with a line delimiter)
>> * create a new file
>> * save the variable/container to the file
>>
>> slightly more complicated: the layouts aren't the same
>> you can either:
>> * rearrange the columns upon reading the file or
>> * use something like an sqlite db and create a record for each row,
>> assigning the column in each record based on the column name in the csv
>> file,  or
>> * use a LC array, using the column names in the file as the keys of the
>> array.
>> * create a new file
>> * output the result of whichever of the three solutions you chose to the
>> new file.
>>
>> both the easy and less-easy scenarios should take, i'm guessing, somewhere
>> between twenty and fifty lines of code, and are easy to implement. if you
>> have a couple hundred files, i think that the LC solution would be much
>> faster and easier to write, test, and run than the drag-and-drop solution.
>>
>>> On Mon, Apr 4, 2022 at 1:04 PM Keith Clarke via use-livecode <
>>> use-livecode@lists.runrev.com> wrote:
>>>
>>> Hi folks,
>>> I need to consolidate a couple of hundred CSV files of varying sizes
>>> (dozens to hundreds of rows) and column structures (some shared columns but
>>> many unique), into a single superset dataset that comprises all data from
>>> all files.
>>>
>>> There are too many files and columns to attempt a manual process, so in
>>> I’ve been trying to achieve this with LiveCode - by iterating through the
>>> files to parse the column header rows into into row template and column
>>> mapping arrays used to build the combined table. However, I'm struggling to
>>> both compile the superset and render the results.
>>>
>>> I feel I may be designing a very complicated solution for a problem that
>>> has probably been solved before. I wonder if I’m missing a simpler method -
>>> with LiveCode or perhaps with Excel or ‘drag & drop’ into some kind of
>>> self-organising database GUI for SQLite, etc?
>>>
>>> Thanks in advance for any ideas.
>>> Best,
>>> Keith
>>> ___
>>> 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
>>>
>>
>>
>> --
>> On the first day, God created the heavens and the Earth
>> On the second day, God created the oceans.
>> On the third day, God put the animals on hold for a few hours,
>>  and did a little diving.
>> And God said, "This is good."
>> ___
>> use-livecode mailing list
>> use-live```

### Re: Tools & techniques for one-off consolidation of multiple 'similar' CSV files?

```Does all the data need to be in a single table?

Sent from my iPhone

> On Apr 4, 2022, at 10:31, Mike Kerner via use-livecode
>  wrote:
>
> ﻿keith,
> are all the files structured the same way? are they all gathered in the
> same place?
> LC's big strength, IMHO, is text handling, so you're right in its
> wheelhouse.
> for the simplest example, let's assume that all the files have all the same
> column layout and they're all in the same folder.
> in that case, you would
> * grab the list of files in the folder
> * exclude files that shouldn't be included - maybe filter everything
> that doesn't have a .csv suffix. you could do this during the loop, below,
> * iterate through the files by reading each one, and appending the contents
> to a variable/container (if you do this, don't forget to make sure that
> when you append each file, the last line ends with a line delimiter)
> * create a new file
> * save the variable/container to the file
>
> slightly more complicated: the layouts aren't the same
> you can either:
> * rearrange the columns upon reading the file or
> * use something like an sqlite db and create a record for each row,
> assigning the column in each record based on the column name in the csv
> file,  or
> * use a LC array, using the column names in the file as the keys of the
> array.
> * create a new file
> * output the result of whichever of the three solutions you chose to the
> new file.
>
> both the easy and less-easy scenarios should take, i'm guessing, somewhere
> between twenty and fifty lines of code, and are easy to implement. if you
> have a couple hundred files, i think that the LC solution would be much
> faster and easier to write, test, and run than the drag-and-drop solution.
>
>> On Mon, Apr 4, 2022 at 1:04 PM Keith Clarke via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>> Hi folks,
>> I need to consolidate a couple of hundred CSV files of varying sizes
>> (dozens to hundreds of rows) and column structures (some shared columns but
>> many unique), into a single superset dataset that comprises all data from
>> all files.
>>
>> There are too many files and columns to attempt a manual process, so in
>> I’ve been trying to achieve this with LiveCode - by iterating through the
>> files to parse the column header rows into into row template and column
>> mapping arrays used to build the combined table. However, I'm struggling to
>> both compile the superset and render the results.
>>
>> I feel I may be designing a very complicated solution for a problem that
>> has probably been solved before. I wonder if I’m missing a simpler method -
>> with LiveCode or perhaps with Excel or ‘drag & drop’ into some kind of
>> self-organising database GUI for SQLite, etc?
>>
>> Thanks in advance for any ideas.
>> Best,
>> Keith
>> ___
>> 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
>>
>
>
> --
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>   and did a little diving.
> And God said, "This is good."
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Thank you

```> On Mar 30, 2022, at 12:16 , J. Landman Gay via use-livecode
>  wrote:
>
> On 3/30/22 11:21 AM, Guillaume Hédieu via use-livecode wrote:
>> Thank you for your "welcome". I'm pleased to see that there is a community
>> around Livecode :)
>
> The best thing about our community is that we don't tolerate trolls,

AHEM! I'm sitting right here!

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Stack offscreen solution

```Sorry, a few artifacts from a previous version snuck in there. Here is the
latest.

on setWindowInScreen pStackName
-- the stack rect
put the rect of stack pStackName into tStackRect

-- the rect of the screen the stack belongs to
put the screen of stack pStackName into tScreenNum
put line tScreenNum of the working screenrects into tScreenRect

-- Check for window off screen
IF item 1 of tStackRect < item 1 of tScreenRect THEN \
set the left of stack pStackName to item 1 of tScreenRect
IF item 2 of tStackRect < item 2 of tScreenRect THEN \
set the top of stack pStackName to (item 2 of tScreenRect)
IF item 3 of tStackRect > item 3 of tScreenRect THEN \
set the right of stack pStackName to item 3 of tScreenRect
IF item 4 of tStackRect > item 4 of tScreenRect THEN \
set the bottom of stack pStackName to (item 4 of tScreenRect)

-- the new screenRect
return the rect of stack pStackName
end setWindowInScreen

Bob S

> On Mar 30, 2022, at 09:04 , Bob Sneidar via use-livecode
>  wrote:
>
> Hi all.
>
> For those dealing with the stack appearing offscreen, here is a handy handler
> for moving the stack so that it is fully visible to the screen it belongs to.
> Note that the screen it belongs to is determined by the loc of the stack.
> Maybe this should be added to the Master Library?
>
> Bob S
>
>
> on setWindowInScreen pStackName
>   -- the stack rect
>   put the rect of stack pStackName into tStackRect
>
>   -- the rect of the screen the stack belongs to
>   put the screen of stack pStackName into tScreenNum
>   put line tScreenNum of the working screenrects into tScreenRect
>
>   -- is stack within the screenRect
>
>   -- Check for window off screen
>   IF item 1 of tStackRect < item 1 of tScreenRect THEN \
> set the left of stack pStackName to item 1 of tScreenRect
>   IF item 2 of tStackRect < item 2 of tScreenRect THEN \
> set the top of stack pStackName to (item 2 of tScreenRect + 42)
>   IF item 3 of tStackRect > item 3 of tScreenRect THEN \
> set the right of stack pStackName to item 3 of tScreenRect
>   IF item 4 of tStackRect > item 4 of tScreenRect THEN \
> set the bottom of stack pStackName to (item 4 of tScreenRect - 40)
>
>   -- the new screenRect
>   return the rect of stack pStackName
> end setWindowInScreen
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Stack offscreen solution

```Hi all.

For those dealing with the stack appearing offscreen, here is a handy handler
for moving the stack so that it is fully visible to the screen it belongs to.
Note that the screen it belongs to is determined by the loc of the stack. Maybe
this should be added to the Master Library?

Bob S

on setWindowInScreen pStackName
-- the stack rect
put the rect of stack pStackName into tStackRect

-- the rect of the screen the stack belongs to
put the screen of stack pStackName into tScreenNum
put line tScreenNum of the working screenrects into tScreenRect

-- is stack within the screenRect

-- Check for window off screen
IF item 1 of tStackRect < item 1 of tScreenRect THEN \
set the left of stack pStackName to item 1 of tScreenRect
IF item 2 of tStackRect < item 2 of tScreenRect THEN \
set the top of stack pStackName to (item 2 of tScreenRect + 42)
IF item 3 of tStackRect > item 3 of tScreenRect THEN \
set the right of stack pStackName to item 3 of tScreenRect
IF item 4 of tStackRect > item 4 of tScreenRect THEN \
set the bottom of stack pStackName to (item 4 of tScreenRect - 40)

-- the new screenRect
return the rect of stack pStackName
end setWindowInScreen

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: New user

```You will find it to be a USE list (emphasis on USEful.)

Bob S

> On Mar 30, 2022, at 06:50 , Guillaume Hédieu via use-livecode
>  wrote:
>
> Hi everyone,
>
> Just a message to say hello. I'm new to Livecode. First of all, please
> apologize for my english, it's not my native language.
>
> I am a computer scientist in an association that trains students for
> working in some social profession.
>
> I like "make and dev" and working with Livecode it's just a hobby for me. I
> love learning and discovering new things and tools, that's why I am here.
>
> Pleased to meet the community, I hope I will be able to read some of your
> messages here.
>
> Have a nice day,
>
> Regards,
>
> Guillaume
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Getting Webpage Information

```It seems to me that in order for the browser widget to DISPLAY all the text,
even in Javascript objects, it must KNOW what the text is. If it KNOWS, maybe
there is a way to update the widget to make that information available in a
property?

Bob S

> On Mar 28, 2022, at 13:50 , Bob Sneidar via use-livecode
>  wrote:
>
> I get the web page text, but not any of the values in the fields, nor even
> any of the body text. I think that is because the page I am looking at is
> Java based. I'd LOVE to figure out a way to get THAT text as it would make my
> job of backing up copier data during installs MUCH quicker.
>
> Bob S
>
>
>> On Mar 28, 2022, at 13:38 , Tom Glod via use-livecode
>>  wrote:
>>
>> Rick,
>>
>> try the htmltext property instead of text. I just tested it, it works and
>> text does not.
>>
>>
>> On Sun, Mar 27, 2022 at 5:53 PM Rick Harrison via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>>> Hi Keith,
>>>
>>> Yes, I have tried that several times and ways.  It doesn’t seem to work.
>>> One would think that would work fine.
>>>
>>> Other ideas?
>>>
>>> Thanks,
>>>
>>> Rick
>>>
>>>> On Mar 27, 2022, at 3:58 PM, Keith Clarke via use-livecode <
>>> use-livecode@lists.runrev.com> wrote:
>>>>
>>>> Hi Rick,
>>>> Maybe try 'put the text of widget "youtBrowserName" into field
>>> "yourFieldName" ' to get the plain text? If you need the html source, try
>>> '...the htmlText' of widget...
>>>> Best,
>>>> Keith
>>>
>>> ___
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Getting Webpage Information

```I get the web page text, but not any of the values in the fields, nor even any
of the body text. I think that is because the page I am looking at is Java
based. I'd LOVE to figure out a way to get THAT text as it would make my job of
backing up copier data during installs MUCH quicker.

Bob S

> On Mar 28, 2022, at 13:38 , Tom Glod via use-livecode
>  wrote:
>
> Rick,
>
> try the htmltext property instead of text. I just tested it, it works and
> text does not.
>
>
> On Sun, Mar 27, 2022 at 5:53 PM Rick Harrison via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> Hi Keith,
>>
>> Yes, I have tried that several times and ways.  It doesn’t seem to work.
>> One would think that would work fine.
>>
>> Other ideas?
>>
>> Thanks,
>>
>> Rick
>>
>>> On Mar 27, 2022, at 3:58 PM, Keith Clarke via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>>
>>> Hi Rick,
>>> Maybe try 'put the text of widget "youtBrowserName" into field
>> "yourFieldName" ' to get the plain text? If you need the html source, try
>> '...the htmlText' of widget...
>>> Best,
>>> Keith
>>
>> ___
>> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: keyup not always working

```I have also run into this. I use rawKeyDown though, that always seems to work.
Have you tried rawKeyUp?

Bob S

> On Mar 24, 2022, at 13:58 , Klaus major-k via use-livecode
>  wrote:
>
> Hi,
>
> I have this in the card script to provide some shortcuts to a player object:
> --
> on keyup tKey
>
>   ## Have been bitten by this in the past :-D
>   if the selectedfield <> EMPTY then
>  pass keyup
>   end if
>   switch tKey
>
>  ## This ALWAYS works:
>  case SPACE
> set the paused of player 1 to NOT (the paused of player 1)
> check_time
> break
>
>  ## This only works about one out of ten times?
>  case "r"
> set the currenttime of player 1 to 0
> check_time
> break
>  default
> pass keyup
> break
>   end switch
> end keyup
> ---
> So I added this as a workaround:
> -
> on keydown tKey
>   if the selectedfield <> EMPTY then
>  pass keydown
>   end if
>   switch tKey
>
>  ## This ALWAYS works!
>  case "r"
> set the currenttime of player 1 to 0
> check_time
> break
>  default
> pass keydown
> break
>   end switch
> end keydown
> --
> Any idea why KEYUP does not work as exspected?
>
>
> Best
>
> Klaus
> --
> Klaus Major
> https://www.major-k.de
> https://www.major-k.de/bass
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: playrate & templateimage

```Now THAT is interesting. I used to play guitar along with music in my iTunes.
The problem is that recording studios used to alter the pitch of their songs
(and so the time of the song) slightly, in order to get the songs to play
within the limits imposed by Radio stations, and to get everything to fit onto
an LP. (That was a vinyl disc that spun at 33 1/3 rotations per minute and a
diamond stylus vibrated with the grooves on the LP, for those of you born after
the 80's.)

Even though these are not considerations anymore, recording studios STILL alter
the pitch of songs slightly (not sure why) so each song I played along with I
had to do a quick re-tune of the guitar! It was so frustrating I eventually
just stopped doing that.

I wonder if there is a way to change the PITCH without changing the PLAYRATE,
or a way to still change both?

Bob S

> On Mar 24, 2022, at 04:31 , Klaus major-k via use-livecode
>  wrote:
>
> Hi friends,
>
> LC never ceases to surprise me and I love that!
>
> 1. In earlier versions setting the "playrate" of a player object to a
> different value than 1
> unfortunately also changed the PITCH of the sound/movie.
>
> Today I was delighted to find out that this is not the case anymore!
> PITCH does not change anymore when setting the PLAYRATE!
> Thanks for the hint, Frans!
>
> At least on a Mac. Is this also the case on Windows?
>
> When did this happen?
> And why didn't anybody tell me? :-D
>
> 2. The fact that we can also import/export snapshots from "the templateimage"
> also suprised me a lot earlier this week.
> A very handy feature, can make a lot of work unneccessary!
>
> Same from "the templateplayer" does not work however, but does not throw
> an error, just a small black image.
>
>
> Best
>
> Klaus
> --
> Klaus Major
> https://www.major-k.de
> https://www.major-k.de/bass
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: ExcelLib in a standalone

```That is to say, it IS Visual Basic doing the work.

Bob S

> On Mar 22, 2022, at 16:14 , Bob Sneidar  wrote:
>
> Oh yes, that is what I read. Got my wires crossed.

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: ExcelLib in a standalone

```Oh yes, that is what I read. Got my wires crossed.

It's interesting that you found that Excel was running hidden. My hangups in
the past may just have been that I was getting some kind of dialog but couldn't
see it because the app was hidden. I say that because when I tried to shut down
my Windows 7 VM earlier, it indicated that Excel was running, even though there
was no visible window.

Bob S

> On Mar 22, 2022, at 16:06 , matthias rebbe via use-livecode
>  wrote:
>
> Bob,
> are you really sure that Java is used on Windows and not VisualBasicScript?
> Here my tests showed that Excel is definitely loaded. It was hidden on the
> desktop, but it was listed in TaskManager as a running process.
>
>
>
>
>

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Counting Syllables

```That's because the British take 1.46 times as long as Americans to say
anything. ;-)

Bob S

> On Mar 22, 2022, at 15:21 , Craig Newman via use-livecode
>  wrote:
>
> Brian.
>
> Storage space should not be an issue. A typical dictionary , whether American
> (191,000)  or British (280,000), with a median word length of about 8 chars,
> still only occupies a handful of MB of storage.
>
> Craig

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: ExcelLib in a standalone

```On the Mac, the library uses Apple Events, and for that to work it has to
launch Excel and open the spreadsheet. On Windows, it uses some kind of Java
library, so does not need to open the file or the app, which means it runs much
faster on Windows, quite the anomaly these days. :-)

Bob S

> On Mar 22, 2022, at 14:40 , matthias rebbe via use-livecode
>  wrote:
>
> Hm,
> i tried here and it works, but Excel is run/opened hidden. i needed to call
> XCEL_Application_Show to get Excel shown.
>
> Regards,
> Matthias
>
>> Am 22.03.2022 um 21:07 schrieb Bob Sneidar via use-livecode
>> :
>>
>> The Excel_Lib file is at the same folder level as the application. In other
>> words I can see Excel_Lib (and the other libraries) in the application
>> folder.
>>
>> Bob S
>>
>>
>>> On Mar 22, 2022, at 12:20 , matthias rebbe via use-livecode
>>>  wrote:
>>>
>>> Bob,
>>>
>>> how did you include the library? As a separate stack or integrated in the
>>> .exe?
>>>
>>> Regards,
>>> Matthias
>>>
>>>> Am 22.03.2022 um 19:18 schrieb Bob Sneidar via use-livecode
>>>> :
>>>>
>>>> Hi all. I'll try to make this as succinct as possible.
>>>>
>>>> 1. Excel_Lib works in MacOS IDE
>>>> 2. Excel_Lib works in MacOS Standalone
>>>> 3. Excel_Lib works in Windows 7 IDE
>>>> 4. Excel_Lib does NOT WORK in Windows 7 Standalone
>>>> 5. Excel_Lib works in Windows 10 IDE
>>>> 6. Excel_Lib does NOT WORK in Windows 10 standalone
>>>>
>>>> Is there something I am missing? I am not getting any alerts when it
>>>> fails, it simply doesn't access the spreadsheet files and the data they
>>>> contain.
>>>>
>>>> Bob S
>>>>
>>>>
>>>> ___
>>>> use-livecode mailing list
>>>> use-livecode@lists.runrev.com
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: ExcelLib in a standalone

```OK So I set up a debugging log to see where along the way I was going wrong. I
found some anomalies, and fixed them and now it seems to be working.

Bob S

> On Mar 22, 2022, at 11:18 , Bob Sneidar via use-livecode
>  wrote:
>
> Hi all. I'll try to make this as succinct as possible.
>
> 1. Excel_Lib works in MacOS IDE
> 2. Excel_Lib works in MacOS Standalone
> 3. Excel_Lib works in Windows 7 IDE
> 4. Excel_Lib does NOT WORK in Windows 7 Standalone
> 5. Excel_Lib works in Windows 10 IDE
> 6. Excel_Lib does NOT WORK in Windows 10 standalone
>
> Is there something I am missing? I am not getting any alerts when it fails,
> it simply doesn't access the spreadsheet files and the data they contain.
>
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: ExcelLib in a standalone

```The Excel_Lib file is at the same folder level as the application. In other
words I can see Excel_Lib (and the other libraries) in the application folder.

Bob S

> On Mar 22, 2022, at 12:20 , matthias rebbe via use-livecode
>  wrote:
>
> Bob,
>
> how did you include the library? As a separate stack or integrated in the
> .exe?
>
> Regards,
> Matthias
>
>> Am 22.03.2022 um 19:18 schrieb Bob Sneidar via use-livecode
>> :
>>
>> Hi all. I'll try to make this as succinct as possible.
>>
>> 1. Excel_Lib works in MacOS IDE
>> 2. Excel_Lib works in MacOS Standalone
>> 3. Excel_Lib works in Windows 7 IDE
>> 4. Excel_Lib does NOT WORK in Windows 7 Standalone
>> 5. Excel_Lib works in Windows 10 IDE
>> 6. Excel_Lib does NOT WORK in Windows 10 standalone
>>
>> Is there something I am missing? I am not getting any alerts when it fails,
>> it simply doesn't access the spreadsheet files and the data they contain.
>>
>> 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
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### ExcelLib in a standalone

```Hi all. I'll try to make this as succinct as possible.

1. Excel_Lib works in MacOS IDE
2. Excel_Lib works in MacOS Standalone
3. Excel_Lib works in Windows 7 IDE
4. Excel_Lib does NOT WORK in Windows 7 Standalone
5. Excel_Lib works in Windows 10 IDE
6. Excel_Lib does NOT WORK in Windows 10 standalone

Is there something I am missing? I am not getting any alerts when it fails, it
simply doesn't access the spreadsheet files and the data they contain.

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: There is no TextEdit.app???

```Andre, the goal for me on this one is to get the path to the app so I can use
it in the launch command. For some reason, using the short name of the app does
not work with the launch command, although maybe it should. Also launch using
just the filename does not launch the default app like you would think.

Bob S

> On Mar 21, 2022, at 16:16 , Bob Sneidar  wrote:
>
> NVM on this one. Apparently the TextEdit.app application is actually in
> /System/Applications/ even though there is a TextEdit.app file in
> /Applications/. Must be a SymLink.
>
> Bob S
>
>
>> On Mar 21, 2022, at 16:12 , Bob Sneidar  wrote:
>>
>> Also the launch command is not working with the TextEdit application.
>>
>> Bob S
>>
>>
>>> On Mar 21, 2022, at 15:58 , Bob Sneidar via use-livecode
>>>  wrote:
>>>
>>> I have the following in a script, and it does not seem to be able to find
>>> the TextEdit.app application on a Mac!
>>>
>>> put "/Applications/TextEdit.app" into tTextEditorPath
>>> if there is a folder tTextEditorPath  then
>>>   put true into tValidPath
>>> end if
>>>
>>> if tValidPath is false then
>>>put empty into tTextEditorPath
>>> end if
>>>
>>> That cannot be right.
>>>
>>> MacOS Catalina 10.15.7 LC 9.6.7 lc2.
>>>
>>> Bob S
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: There is no TextEdit.app???

```Craig, the system is not case sensitive. Should the Symlink produce true for
there is a folder? If so then I suppose it is a bug. But it's a minor one and
it can be worked around. It makes sense for Apple to put such apps in the
system, as deleting or worse yet modifying them would take more than admin
credentials.

Bob S

> On Mar 22, 2022, at 06:01 , Craig Newman via use-livecode
>  wrote:
>
> Bob.
>
> There is no way that the uppercase/lowercase difference in a character in a
> literal can have that sort of effect. Are you saying you can duplicate this???
>
> Craig
>
>> On Mar 22, 2022, at 7:01 AM, Andre Garzia via use-livecode
>>  wrote:
>>
>> Damn, I took a long time formatting that message so the source-code would be
>> legible. Well, sorry, don’t know if it was my mail app or the mailing-list
>> software, but something borked it.
>>
>>> On 22 Mar 2022, at 10:36, Andre Garzia  wrote:
>>>
>>> Bob,
>>>
>>> Another way to check if an application is installed on a mac is by using
>>> AppleScript. Here are some functions that work together to check if
>>> TextEdit is installed.
>>>
>>> function q txt
>>> return quote & txt & quote
>>> end q
>>>
>>> function isApplicationInstalledByBundleID pID
>>> put "try" & cr into tScript
>>> put "tell application " & q("Finder") & " to get application file id " &
>>> q(pID) & cr after tScript
>>> put "return true" & cr after tScript
>>> put "on error" & cr after tScript
>>> put "return false" & cr after tScript
>>> put "end try" & cr after tScript
>>>
>>> do tScript as “applescript"
>>>
>>> if the result is "{true}” then
>>>  return true
>>> else
>>>  return false
>>> end if
>>> end isApplicationInstalledByBundleID
>>>
>>> function isTextEditInstalled
>>> return isApplicationInstalledByBundleID("com.apple.TextEdit")
>>> end isTextEditInstalled
>>>
>>>
>>>
>>>> On 21 Mar 2022, at 22:58, Bob Sneidar via use-livecode
>>>>  wrote:
>>>>
>>>> I have the following in a script, and it does not seem to be able to find
>>>> the TextEdit.app application on a Mac!
>>>>
>>>> put "/Applications/TextEdit.app" into tTextEditorPath
>>>> if there is a folder tTextEditorPath  then
>>>>  put true into tValidPath
>>>> end if
>>>>
>>>> if tValidPath is false then
>>>>   put empty into tTextEditorPath
>>>> end if
>>>>
>>>> That cannot be right.
>>>>
>>>> MacOS Catalina 10.15.7 LC 9.6.7 lc2.
>>>>
>>>> Bob S
>>>>
>>>>
>>>> ___
>>>> use-livecode mailing list
>>>> use-livecode@lists.runrev.com
>>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: There is no TextEdit.app???

```NVM on this one. Apparently the TextEdit.app application is actually in
/System/Applications/ even though there is a TextEdit.app file in

Bob S

> On Mar 21, 2022, at 16:12 , Bob Sneidar  wrote:
>
> Also the launch command is not working with the TextEdit application.
>
> Bob S
>
>
>> On Mar 21, 2022, at 15:58 , Bob Sneidar via use-livecode
>>  wrote:
>>
>> I have the following in a script, and it does not seem to be able to find
>> the TextEdit.app application on a Mac!
>>
>>  put "/Applications/TextEdit.app" into tTextEditorPath
>>  if there is a folder tTextEditorPath  then
>>put true into tValidPath
>>  end if
>>
>>  if tValidPath is false then
>> put empty into tTextEditorPath
>>  end if
>>
>> That cannot be right.
>>
>> MacOS Catalina 10.15.7 LC 9.6.7 lc2.
>>
>> 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
>

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: There is no TextEdit.app???

```Also the launch command is not working with the TextEdit application.

Bob S

> On Mar 21, 2022, at 15:58 , Bob Sneidar via use-livecode
>  wrote:
>
> I have the following in a script, and it does not seem to be able to find the
> TextEdit.app application on a Mac!
>
>   put "/Applications/TextEdit.app" into tTextEditorPath
>   if there is a folder tTextEditorPath  then
> put true into tValidPath
>   end if
>
>   if tValidPath is false then
>  put empty into tTextEditorPath
>   end if
>
> That cannot be right.
>
> MacOS Catalina 10.15.7 LC 9.6.7 lc2.
>
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: There is no TextEdit.app???

```Also of great curiosity to me,

set the tool to "Browse Tool"

throws an error in the SE.

set the tool to "browse tool"

does NOT throw an error in the SE!

Bob S

> On Mar 21, 2022, at 15:58 , Bob Sneidar  wrote:
>
> I have the following in a script, and it does not seem to be able to find the
> TextEdit.app application on a Mac!
>
>   put "/Applications/TextEdit.app" into tTextEditorPath
>   if there is a folder tTextEditorPath  then
> put true into tValidPath
>   end if
>
>   if tValidPath is false then
>  put empty into tTextEditorPath
>   end if
>
> That cannot be right.
>
> MacOS Catalina 10.15.7 LC 9.6.7 lc2.
>
> Bob S
>

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### There is no TextEdit.app???

```I have the following in a script, and it does not seem to be able to find the
TextEdit.app application on a Mac!

put "/Applications/TextEdit.app" into tTextEditorPath
if there is a folder tTextEditorPath  then
put true into tValidPath
end if

if tValidPath is false then
put empty into tTextEditorPath
end if

That cannot be right.

MacOS Catalina 10.15.7 LC 9.6.7 lc2.

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel Lib 1.4

```I did check that out. But my specific application requires I produce a new
spreadsheet, and I didn’t see with your product how to do that.

Sent from my iPhone

> On Mar 18, 2022, at 19:39, Curry Kenworthy via use-livecode
>  wrote:
>
> ﻿
> Me:
> > Or try the original
>
>
> My own Addon Store is finally back online this year,
> after going down when eSellerate died. Now with SendOwl.
>
> (And a few days ago, I got SpreadLib back up for sale.)
>
>
> Best wishes,
>
> Curry Kenworthy
>
> SpreadLib: Excel files to LC fields in 1 script line!
> "Excel-lent spreadsheet import and export for LiveCode"
>
> Innovative Christian LiveCode Training and Consulting
> "Better Methods, Better Results"
> http://livecodeconsulting.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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: ArrayEncode/Decode broken??

```I’m so embarrassed. On my way to the beach this morning it hit me like a ton of
bricks. DOH!

Sent from my iPhone

> On Mar 18, 2022, at 17:11, J. Landman Gay via use-livecode
>  wrote:
>
> ﻿I made the same mistake a while ago, until I remembered that the encoded
> array is binary. You have to write and read it to/from a binary file. If you
> just use "open file" you get text only.
>
> --
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software | http://www.hyperactivesw.com
>> On March 18, 2022 6:40:40 PM Bob Sneidar via use-livecode
>>  wrote:
>>
>> Hi all.
>>
>> I'm running 9.6.7 rc2. I have this code in a closeStackRequest handler:
>>
>>  put the settings of me into tSettingsA
>>  put field "fldEAFilePath" into tSettingsA ["eafilepath"]
>>  put field "fldInvFilePath" into tSettingsA ["invfilepath"]
>>  put field "fldOutFilePath" into tSettingsA ["Outfilepath"]
>>  put the dgText [true] of group "dgVariance" into tSettingsA ["gridtext"]
>>  put arrayEncode(tSettingsA) into tSettingsText
>>  put the filename of this stack into tSettingsPath
>>  set the itemDelimiter to "/"
>>  put "settings.prefs" into item -1 of tSettingsPath
>>  open file tSettingsPath for write
>>  write tSettingsText to file tSettingsPath
>>  close file tSettingsPath
>>
>> Then in the openStack handler I have this:
>>
>>  put the filename of this stack into tSettingsPath
>>  set the itemDelimiter to "/"
>>  put "settings.prefs" into item -1 of tSettingsPath
>>  open file tSettingsPath for read
>>  read from file tSettingsPath until eof
>>  put it after tSettingsText
>>  close file tSettingsPath
>>  put arrayDecode(tSettingsText) into tSettingsA
>>  set the settings of me to tSettingsA
>>
>> Instead of an array, I get the text "gr" which is the first 2 characters of
>> the key "grid text" in the array. That can't be right!
>>
>> 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
>
>
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel Lib 1.4

```I looked into my emails and found I had actually paid for a full license some
time ago. There were instructions on how to get to the downloads page (which
you cannot find by simply going to his website and clicking a link). I was able
to get v1.5 and THAT is working in Windows now. I have no idea how I got that
whacky 1.4 version with the library set as a substack of the documentation
stack, but it's in the trash now!

Bob S

> On Mar 18, 2022, at 15:56 , Curry Kenworthy via use-livecode
>  wrote:
>
>
> (Cough, cough)
>
> Or try the original
>
> Best wishes,
>
> Curry Kenworthy
>
> SpreadLib: Excel files to LC fields in 1 script line!
> "Excel-lent spreadsheet import and export for LiveCode"
>
> Innovative Christian LiveCode Training and Consulting
> "Better Methods, Better Results"
> http://livecodeconsulting.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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### ArrayEncode/Decode broken??

```Hi all.

I'm running 9.6.7 rc2. I have this code in a closeStackRequest handler:

put the settings of me into tSettingsA
put field "fldEAFilePath" into tSettingsA ["eafilepath"]
put field "fldInvFilePath" into tSettingsA ["invfilepath"]
put field "fldOutFilePath" into tSettingsA ["Outfilepath"]
put the dgText [true] of group "dgVariance" into tSettingsA ["gridtext"]
put arrayEncode(tSettingsA) into tSettingsText
put the filename of this stack into tSettingsPath
set the itemDelimiter to "/"
put "settings.prefs" into item -1 of tSettingsPath
open file tSettingsPath for write
write tSettingsText to file tSettingsPath
close file tSettingsPath

Then in the openStack handler I have this:

put the filename of this stack into tSettingsPath
set the itemDelimiter to "/"
put "settings.prefs" into item -1 of tSettingsPath
read from file tSettingsPath until eof
put it after tSettingsText
close file tSettingsPath
put arrayDecode(tSettingsText) into tSettingsA
set the settings of me to tSettingsA

Instead of an array, I get the text "gr" which is the first 2 characters of the
key "grid text" in the array. That can't be right!

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel Lib 1.4

```Does anyone have zryip's email? For whatever reason it's not in my address
book, and his web page for submitting issues did not cc me when I submitted a
request, so I do not think that is working.

Bob S

> On Mar 17, 2022, at 09:47 , Bob Sneidar via use-livecode
>  wrote:
>
> I have v1.4, not sure about the licensing. I will contact zryip presently.
> Meanwhile I was able to create a separate version of Excel_Lib. I just tested
> it and it works.
>
> Bob S
>
>
>> On Mar 17, 2022, at 09:39 , matthias rebbe via use-livecode
>>  wrote:
>>
>> Are you using the open source or the commercial version?
>> If i am not wrong then only the commercial license is available as 1.5 and
>> the open source license is 1.2 or so.
>>
>> version using the username and password that Zryip should have submitted to
>> you.
>> If you do not have those credentials, you could send an email to
>> zryip.thes...@gmail.com <mailto:zryip.thes...@gmail.com> and ask him to get
>> He normally replies quickly.
>>
>> Regards,
>>
>> Matthisa
>>
>>
>>> Am 17.03.2022 um 16:48 schrieb Bob Sneidar via use-livecode
>>> :
>>>
>>> Also if anyone has version 1.5 of the library, would it be possible to send
>>> that to me off list?
>>>
>>> Bob S
>>>
>>>
>>>> On Mar 17, 2022, at 08:43 , Bob Sneidar via use-livecode
>>>>  wrote:
>>>>
>>>> Does anyone use Excel_Lib? How do you get it to work?? Opening the
>>>> documentation stack loads the necessary libraries and stacks, but the
>>>> actual library is a substack of the documentation stack! Also, there are
>>>> handlers which call on the PROPERTIES of that stack! So I cannot just copy
>>>> the code out to a script only stack!
>>>>
>>>> This would mean I would have to include the entire documentation stack in
>>>> my stackfiles for any project that uses it. That doesn't seem right to me.
>>>>
>>>> Bob S
>>>>
>>>>
>>>>> On Mar 16, 2022, at 17:26 , Bob Sneidar
>>>>> wrote:
>>>>>
>>>>> Wow. The excel_lib I need is actually a substack of the documentation
>>>>> stack! Wh???
>>>>>
>>>>> Bob S
>>>>>
>>>>
>>>>
>>>> ___
>>>> use-livecode mailing list
>>>> use-livecode@lists.runrev.com
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel Lib 1.4

```Looks like Excel_Lib is a paid product to the tune of \$99/year. For my
purposes, that is more than I want to spend simply for the convenience of
scraping some data out of an exported Crystal Reports file.

Windows is trying to decompress what looks like a compressed vbscript, but
Livecode for Windows balks at the decompress command and says it is not
compressed data, although it certainly looks like it is in the variable
watcher. I suspect it's been corrupted somehow.

At any rate, I will probably look at getting the data from exported PDFs

Bob S

> On Mar 17, 2022, at 09:47 , Bob Sneidar via use-livecode
>  wrote:
>
> I have v1.4, not sure about the licensing. I will contact zryip presently.
> Meanwhile I was able to create a separate version of Excel_Lib. I just tested
> it and it works.
>
> Bob S
>
>
>> On Mar 17, 2022, at 09:39 , matthias rebbe via use-livecode
>>  wrote:
>>
>> Are you using the open source or the commercial version?
>> If i am not wrong then only the commercial license is available as 1.5 and
>> the open source license is 1.2 or so.
>>
>> version using the username and password that Zryip should have submitted to
>> you.
>> If you do not have those credentials, you could send an email to
>> zryip.thes...@gmail.com <mailto:zryip.thes...@gmail.com> and ask him to get
>> He normally replies quickly.
>>
>> Regards,
>>
>> Matthisa
>>
>>
>>> Am 17.03.2022 um 16:48 schrieb Bob Sneidar via use-livecode
>>> :
>>>
>>> Also if anyone has version 1.5 of the library, would it be possible to send
>>> that to me off list?
>>>
>>> Bob S
>>>
>>>
>>>> On Mar 17, 2022, at 08:43 , Bob Sneidar via use-livecode
>>>>  wrote:
>>>>
>>>> Does anyone use Excel_Lib? How do you get it to work?? Opening the
>>>> documentation stack loads the necessary libraries and stacks, but the
>>>> actual library is a substack of the documentation stack! Also, there are
>>>> handlers which call on the PROPERTIES of that stack! So I cannot just copy
>>>> the code out to a script only stack!
>>>>
>>>> This would mean I would have to include the entire documentation stack in
>>>> my stackfiles for any project that uses it. That doesn't seem right to me.
>>>>
>>>> Bob S
>>>>
>>>>
>>>>> On Mar 16, 2022, at 17:26 , Bob Sneidar
>>>>> wrote:
>>>>>
>>>>> Wow. The excel_lib I need is actually a substack of the documentation
>>>>> stack! Wh???
>>>>>
>>>>> Bob S
>>>>>
>>>>
>>>>
>>>> ___
>>>> use-livecode mailing list
>>>> use-livecode@lists.runrev.com
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Solution for how to allow LC 9.6.6 and up standalones to control other apps in macOS - was:Excel_Lib on Mac

```Of course, I am running MacOS 10.7.2. YMMV

Bob S

> On Mar 18, 2022, at 14:28 , Bob Sneidar via use-livecode
>  wrote:
>
> I might beg to differ. I created an app with 9.6.7 rc2 after giving it
> permissions to control Excel for Mac. After building the standalone, it has
> no problems sending Apple Events to Excel for Mac.
>
> I will double check later.
>
> Bob S
>
>
>> On Mar 18, 2022, at 12:17 , matthias rebbe via use-livecode
>>  wrote:
>>
>> First of all there is a bug report already. Unfortunately LC stuff is not
>> able to reproduce the problem.
>> But there a some users who reported that it is not possible in LC 9.6.6 and
>> up to control an other app from within a LC script using Apple script if the
>> app was not already listed under Livecode  in System
>> preferences/Security/Automation. For whatever reason there was not
>> the typical security pop up asking for confirmation.
>>
>> As a workaround it is possible to run the stack first with LC 9.6.3. With
>> that version the dialog pops up and the user can confirm. After that the
>> stack works also with 9.6.6 and up and is able to control that other app.
>>
>> But what about standalones created with LC 9.6.6 and up? They will not show
>> up the dialog.
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Solution for how to allow LC 9.6.6 and up standalones to control other apps in macOS - was:Excel_Lib on Mac

```I might beg to differ. I created an app with 9.6.7 rc2 after giving it
permissions to control Excel for Mac. After building the standalone, it has no
problems sending Apple Events to Excel for Mac.

I will double check later.

Bob S

> On Mar 18, 2022, at 12:17 , matthias rebbe via use-livecode
>  wrote:
>
> First of all there is a bug report already. Unfortunately LC stuff is not
> able to reproduce the problem.
> But there a some users who reported that it is not possible in LC 9.6.6 and
> up to control an other app from within a LC script using Apple script if the
> app was not already listed under Livecode  in System
> preferences/Security/Automation. For whatever reason there was not
> the typical security pop up asking for confirmation.
>
> As a workaround it is possible to run the stack first with LC 9.6.3. With
> that version the dialog pops up and the user can confirm. After that the
> stack works also with 9.6.6 and up and is able to control that other app.
>
> But what about standalones created with LC 9.6.6 and up? They will not show
> up the dialog.

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: How to access scripts on a modal card that is stuck / not visible?

```I wasn't aware a card could be made modal as opposed to a stack. I have a
separate substack for logging in, so I go stack "Login" as modal. That works
for me.

Bob S

> On Mar 18, 2022, at 03:28 , Keith Clarke via use-livecode
>  wrote:
>
> Hi folks,
> Experimenting with OAuth, I built a “Login” card containing a Browser widget
> that allows me to access OAuth to log onto an online service. Once
> authorised, the script on the Browser Widget finished with 'go card “Home”’
> where I’m building out some utilities to work with the web service.
>
> The web service’s access token is short-lived, so I thought I’d convert the
> Login card into a pop-up dialogue on the Home card for convenience. So, I
> now any attempt to go to the Login card results in either the card flashing
> up and disappearing or the stack locking with the modal card inaccessible. I
> seem to have created some kind of loop that is in play in run or edit modes.
>
> I’ve not done much with multiple card stacks and never used modes before. So,
> I have two questions:
>
> 1. What’s the syntax needed to open the script of an un-open object via the
> message box, so I can break out of this loop?
> 2. Can anyone please suggest a worked example or lesson of a pop-up web
> service login dialogue, as I’m clearly doing something basic wrong!
>
> Thanks & regards,
> Keith
>
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Compiler Funding Options Update

```I originally popped for \$198, but I just paid for a year's subscription. If I
do not get the \$198 back, oh well.

Bob S

> On Mar 16, 2022, at 17:57 , Tom Glod via use-livecode
>  wrote:
>
> Well...I threw in \$100 to help make it happen...fingers crossed.
>
> On Wed, Mar 16, 2022 at 8:53 PM Tom Glod  wrote:
>
>> I see the page I had bookmarked has a "-page" at the end of slug.
>>
>> https://livecode.com/script-compiler-project-page/
>>
>> Thank you.
>>
>> On Wed, Mar 16, 2022 at 7:27 PM J. Landman Gay via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>>> On 3/16/22 5:46 PM, Tom Glod via use-livecode wrote:
When I go ot the page I only see the 3 options how do I get to the
>>> \$99
option?
>>>
>>> I see six options. Do you have any plugins that might disable some of the
>>> javascript, or
>>> similar? Try a different browser, maybe?
>>>
>>> --
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel Lib 1.4

```I have v1.4, not sure about the licensing. I will contact zryip presently.
Meanwhile I was able to create a separate version of Excel_Lib. I just tested
it and it works.

Bob S

> On Mar 17, 2022, at 09:39 , matthias rebbe via use-livecode
>  wrote:
>
> Are you using the open source or the commercial version?
> If i am not wrong then only the commercial license is available as 1.5 and
> the open source license is 1.2 or so.
>
> version using the username and password that Zryip should have submitted to
> you.
> If you do not have those credentials, you could send an email to
> zryip.thes...@gmail.com <mailto:zryip.thes...@gmail.com> and ask him to get
> He normally replies quickly.
>
> Regards,
>
> Matthisa
>
>
>> Am 17.03.2022 um 16:48 schrieb Bob Sneidar via use-livecode
>> :
>>
>> Also if anyone has version 1.5 of the library, would it be possible to send
>> that to me off list?
>>
>> Bob S
>>
>>
>>> On Mar 17, 2022, at 08:43 , Bob Sneidar via use-livecode
>>>  wrote:
>>>
>>> Does anyone use Excel_Lib? How do you get it to work?? Opening the
>>> documentation stack loads the necessary libraries and stacks, but the
>>> actual library is a substack of the documentation stack! Also, there are
>>> handlers which call on the PROPERTIES of that stack! So I cannot just copy
>>> the code out to a script only stack!
>>>
>>> This would mean I would have to include the entire documentation stack in
>>> my stackfiles for any project that uses it. That doesn't seem right to me.
>>>
>>> Bob S
>>>
>>>
>>>> On Mar 16, 2022, at 17:26 , Bob Sneidar
>>>> wrote:
>>>>
>>>> Wow. The excel_lib I need is actually a substack of the documentation
>>>> stack! Wh???
>>>>
>>>> Bob S
>>>>
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Text overwriting itself in non wrapping field

```I have a cleanASCII function:

Bob S

FUNCTION cleanASCII pString, pModeList, pCustomList
/*
pModeList is a comma delimited list that may contain the following values:
"lowercase,uppercase,numbers,tabs,newlines,returns,spaces,symbols,custom"
If custom is used, then a third paramaeter containing allowed characters
must be supplied.
*/
IF pModeList contains dash THEN replace dash with "\" & dash in pModeList

IF pModeList is empty THEN
put " 0-9a-zA-Z" into tAllowedChars
END IF

REPEAT for each item pMode in pModeList
put word 1 of pMode into pMode

SWITCH
break
CASE "tabs" is in pMode
put "\t" AFTER tAllowedChars
break
CASE "newlines" is in pMode
put "\n" BEFORE tAllowedChars
break
CASE "returns" is in pMode
put "\r" BEFORE tAllowedChars -- currently not working
break
CASE "spaces" is in pMode
put " " AFTER tAllowedChars
break
CASE "numbers" is in pMode
put "0-9" AFTER tAllowedChars
break
CASE "lowercase" is in pMode
put "a-z" AFTER tAllowedChars
break
CASE "uppercase" is in pMode
put "A-Z" AFTER tAllowedChars
break
CASE "symbols" is in pMode
put "!#\$%&'()*+,./:;<=>?@\|\[\]\\_`{|}~^-" AFTER tAllowedChars
break
CASE pMode is "custom"
put pCustomList AFTER tAllowedChars
break
END SWITCH
END REPEAT

put "[" & tAllowedChars & "]" into tMatchText

REPEAT for each character  theChar in pString
IF matchtext(theChar, tMatchText) is true THEN
put theChar AFTER cleanString
END IF
END REPEAT

return cleanString
END cleanASCII

> On Mar 17, 2022, at 08:58 , David V Glasgow via use-livecode
>  wrote:
>
> Hi folks,
>
> I have imported just under 10,000 lines of a web history into a non wrapping
> scrollable field.  As the subject above indicates, in one line characters
> appear rendered over the top of each other.  The is quite stable, so
> redrawing or scrolling doesn’t make it go away.
>
> That line is pretty long, but not longer than field limits - 10693 chars
>
> Examining it, it looks like it ought to be a number of separate lines, and it
> also contains weird visible and also white space that is not a simple space.
> I can’t see any recognisable pattern to suggest where cr should be.
>
> Any suggestions about what is going on and how I might fix it?
>
> Cheers
>
> David Glasgow
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel Lib 1.4

```Also if anyone has version 1.5 of the library, would it be possible to send
that to me off list?

Bob S

> On Mar 17, 2022, at 08:43 , Bob Sneidar via use-livecode
>  wrote:
>
> Does anyone use Excel_Lib? How do you get it to work?? Opening the
> documentation stack loads the necessary libraries and stacks, but the actual
> library is a substack of the documentation stack! Also, there are handlers
> which call on the PROPERTIES of that stack! So I cannot just copy the code
> out to a script only stack!
>
> This would mean I would have to include the entire documentation stack in my
> stackfiles for any project that uses it. That doesn't seem right to me.
>
> Bob S
>
>
>> On Mar 16, 2022, at 17:26 , Bob Sneidar  wrote:
>>
>> Wow. The excel_lib I need is actually a substack of the documentation stack!
>> Wh???
>>
>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel Lib 1.4

```Does anyone use Excel_Lib? How do you get it to work?? Opening the
documentation stack loads the necessary libraries and stacks, but the actual
library is a substack of the documentation stack! Also, there are handlers
which call on the PROPERTIES of that stack! So I cannot just copy the code out
to a script only stack!

This would mean I would have to include the entire documentation stack in my
stackfiles for any project that uses it. That doesn't seem right to me.

Bob S

> On Mar 16, 2022, at 17:26 , Bob Sneidar  wrote:
>
> Wow. The excel_lib I need is actually a substack of the documentation stack!
> Wh???
>
> Bob S
>

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Excel Lib 1.4

```Wow. The excel_lib I need is actually a substack of the documentation stack!
Wh???

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: :MEMORY: databases and Windows

```Once again you nailed it. Still, this is a bug, minor though it may be. In the
past I was told that it MUST be capitalized. Now it seems capitalized only
works on the mac while all lowercase works on both platforms.  squared.

Bob S

> On Mar 16, 2022, at 15:00 , matthias rebbe via use-livecode
>  wrote:
>
> You don't have to... ;)
>
> I assume you wrote :MEMORY: in capital letters, right.
>
> Write it in lower letters  :memory: and it should work. I just tested it
> successfully with :memory:
>
>
>
>> Am 16.03.2022 um 22:54 schrieb Bob Sneidar via use-livecode
>> :
>>
>> OK I'll open a bug report.
>>
>> Bob S
>>
>>
>>> On Mar 16, 2022, at 14:51 , matthias rebbe via use-livecode
>>>  wrote:
>>>
>>> I just tested under Win in the IDE, it does not work there either.
>>>
>>> Error message is   'Database Error: Unable to open the database file'
>>>
>>>
>>>
>>>> Am 16.03.2022 um 22:32 schrieb Tom Glod via use-livecode
>>>> :
>>>>
>>>> Whats the error message you get when you check the result of
>>>> databaseconnect?
>>>> ___
>>>> use-livecode mailing list
>>>> use-livecode@lists.runrev.com
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: :MEMORY: databases and Windows

```Wow. Why does it work on MacOS I wonder??

Bob S

> On Mar 16, 2022, at 15:00 , matthias rebbe via use-livecode
>  wrote:
>
> You don't have to... ;)
>
> I assume you wrote :MEMORY: in capital letters, right.
>
> Write it in lower letters  :memory: and it should work. I just tested it
> successfully with :memory:
>
>
>
>> Am 16.03.2022 um 22:54 schrieb Bob Sneidar via use-livecode
>> :
>>
>> OK I'll open a bug report.
>>
>> Bob S
>>
>>
>>> On Mar 16, 2022, at 14:51 , matthias rebbe via use-livecode
>>>  wrote:
>>>
>>> I just tested under Win in the IDE, it does not work there either.
>>>
>>> Error message is   'Database Error: Unable to open the database file'
>>>
>>>
>>>
>>>> Am 16.03.2022 um 22:32 schrieb Tom Glod via use-livecode
>>>> :
>>>>
>>>> Whats the error message you get when you check the result of
>>>> databaseconnect?
>>>> ___
>>>> use-livecode mailing list
>>>> use-livecode@lists.runrev.com
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: :MEMORY: databases and Windows

```OK I'll open a bug report.

Bob S

> On Mar 16, 2022, at 14:51 , matthias rebbe via use-livecode
>  wrote:
>
> I just tested under Win in the IDE, it does not work there either.
>
> Error message is   'Database Error: Unable to open the database file'
>
>
>
>> Am 16.03.2022 um 22:32 schrieb Tom Glod via use-livecode
>> :
>>
>> Whats the error message you get when you check the result of
>> databaseconnect?
>> ___
>> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: :MEMORY: databases and Windows

```Curiously, this works fine in a MacOS standalone. I think there may be an issue
with Windows and :MEMORY: databases.

Bob S

> On Mar 16, 2022, at 14:49 , Bob Sneidar via use-livecode
>  wrote:
>
> I get an error creating the database. I went back into my code and checked
> that the database id was an integer upon creation and it was not.
>
> Bob S
>
>
>> On Mar 16, 2022, at 14:32 , Tom Glod via use-livecode
>>  wrote:
>>
>> Whats the error message you get when you check the result of
>> databaseconnect?
>> ___
>> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: :MEMORY: databases and Windows

```I get an error creating the database. I went back into my code and checked that
the database id was an integer upon creation and it was not.

Bob S

> On Mar 16, 2022, at 14:32 , Tom Glod via use-livecode
>  wrote:
>
> Whats the error message you get when you check the result of
> databaseconnect?
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### :MEMORY: databases and Windows

```Hi all.

I have a simple app that creates a :MEMORY: sqLite database, then populates it
with some small bit of data. On the Mac in the IDE it works fine, but in a
Windows standalone, it fails to create the database. I have manually included
the sqLite and database libraries in the standalone settings. What else do I
require?

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel_Lib on Mac

```Matthia you are a genius. This apparently is a bug in the most recent version
of Livecode. I tried you method, and now ALL versions of Livecode have access
to send apple events to Excel.

Bob S

> On Mar 16, 2022, at 08:18 , Bob Sneidar via use-livecode
>  wrote:
>
> I have older versions of Livecde still, I should give that a try. I wonder
> what happens then when I use it in a compiled app? We shall see.
>
> Bob S
>
>
>> On Mar 16, 2022, at 05:35 , matthias rebbe via use-livecode
>>  wrote:
>>
>> I tried with a sample stack here with Livecode 10 and had the exact problem.
>>
>> I then tried Livecode 9.6.3 and got a macOS system pop up with the following
>> message
>> LiveCode Business 9.6.3.app“ möchte Zugriffsrechte, um „Microsoft Excel.app“
>> zu steuern. Durch die Erlaubnis zum Steuern kann auf Dokumente und Daten in
>> „Microsoft Excel.app“ zugegriffen werden und Aktionen können in dieser App
>> durchgeführt werden.
>>
>> something like this in English:
>> Livecode Business... wants to have access rights to control Microsfot Excel
>> app. By granting access documents and data in Microsoft Excel.app can be
>> accessed and actions can be done.
>>
>> After confirming/allowing  Livecode was listed under Automation in System
>> Preferences -> Security
>>
>> And the funny part of this is, that not LC 9.6.3 is listed now under
>> Automation, but LC 10 DP2.
>>
>> I tested then with 9.6.3 and with 10DP and it works now in both editions.
>>
>>
>> Matthias
>>
>>
>>
>>
>>
>>> Am 15.03.2022 um 22:50 schrieb Bob Sneidar via use-livecode
>>> :
>>>
>>> Hi all.
>>>
>>> I am trying to incorporate Excel_Lib into a project. There is a command to
>>> open a spreadsheet with Excel on a Mac, and ONLY Macs can use this command.
>>> It looks however like the library works with Windows too.
>>>
>>> My issue is that I am getting an error, "XCELLibErr: Not authorized to send
>>> Apple events to Microsoft Excel." So first, is there an easy way, like a
>>> shell command to do this? And then if not, is using this library dependent
>>> on Apple events on a Mac?
>>>
>>> Bob S
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel_Lib on Mac

```I have older versions of Livecde still, I should give that a try. I wonder what
happens then when I use it in a compiled app? We shall see.

Bob S

> On Mar 16, 2022, at 05:35 , matthias rebbe via use-livecode
>  wrote:
>
> I tried with a sample stack here with Livecode 10 and had the exact problem.
>
> I then tried Livecode 9.6.3 and got a macOS system pop up with the following
> message
> LiveCode Business 9.6.3.app“ möchte Zugriffsrechte, um „Microsoft Excel.app“
> zu steuern. Durch die Erlaubnis zum Steuern kann auf Dokumente und Daten in
> „Microsoft Excel.app“ zugegriffen werden und Aktionen können in dieser App
> durchgeführt werden.
>
> something like this in English:
> Livecode Business... wants to have access rights to control Microsfot Excel
> app. By granting access documents and data in Microsoft Excel.app can be
> accessed and actions can be done.
>
> After confirming/allowing  Livecode was listed under Automation in System
> Preferences -> Security
>
> And the funny part of this is, that not LC 9.6.3 is listed now under
> Automation, but LC 10 DP2.
>
> I tested then with 9.6.3 and with 10DP and it works now in both editions.
>
>
> Matthias
>
>
>
>
>
>> Am 15.03.2022 um 22:50 schrieb Bob Sneidar via use-livecode
>> :
>>
>> Hi all.
>>
>> I am trying to incorporate Excel_Lib into a project. There is a command to
>> open a spreadsheet with Excel on a Mac, and ONLY Macs can use this command.
>> It looks however like the library works with Windows too.
>>
>> My issue is that I am getting an error, "XCELLibErr: Not authorized to send
>> Apple events to Microsoft Excel." So first, is there an easy way, like a
>> shell command to do this? And then if not, is using this library dependent
>> on Apple events on a Mac?
>>
>> 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
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel_Lib on Mac

```Because I get the error that says I can't, and when I try to give it
permissions there seems to be no place to do so. Monterey does not have the
onerous sandboxing that Catalina does. Also, I am using Office 365 license and
not a standalone version of Excel.

Bob S

> On Mar 16, 2022, at 04:29 , Andreas Bergendal via use-livecode
>  wrote:
>
> I’m confused - we’re talking Excel Lib by Zryip TheSlug, right?
>
> I’m using v.1.5.3, and it works very well for opening/editing Excel files on
> my Mac (12.2 Monterery, Excel 16.59, LC9.6.7 rc1).
> I can’t remember if at first use I had to grant some permissions of some
> kind, but now it works without a hitch. Using AppleScript if understand
> correctly. (On Mac I only tried it from the IDE, though, not a standalone.)
>
> On Windows it works fine in a standalone too, where it uses vsbscript.
>
> Bob wrote:
>> The Macintosh can no longer send apple events to Excel, or indeed any other
>> Microsoft product [...]
>
> We’re does this info come from? My Mac seems to disagree… :)
>
> Best,
> Andreas
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Excel_Lib on Mac

```I did some research. The Macintosh can no longer send apple events to Excel, or
indeed any other Microsoft product, due to the fact that Apple Sandboxing
prevents it. There ought, I suppose, to be a way to grant this access, but
Appleand/or Microsoft has decided to prevent it, making the excel_lib worthless
on MacOS.

The more programmers and politicians set about to help me, the less I am able
to help myself.

Bob S

> On Mar 15, 2022, at 14:50 , Bob Sneidar via use-livecode
>  wrote:
>
> Hi all.
>
> I am trying to incorporate Excel_Lib into a project. There is a command to
> open a spreadsheet with Excel on a Mac, and ONLY Macs can use this command.
> It looks however like the library works with Windows too.
>
> My issue is that I am getting an error, "XCELLibErr: Not authorized to send
> Apple events to Microsoft Excel." So first, is there an easy way, like a
> shell command to do this? And then if not, is using this library dependent on
> Apple events on a Mac?
>
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Excel_Lib on Mac

```Hi all.

I am trying to incorporate Excel_Lib into a project. There is a command to open
a spreadsheet with Excel on a Mac, and ONLY Macs can use this command. It looks
however like the library works with Windows too.

My issue is that I am getting an error, "XCELLibErr: Not authorized to send
Apple events to Microsoft Excel." So first, is there an easy way, like a shell
command to do this? And then if not, is using this library dependent on Apple
events on a Mac?

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Speaking of Filter and Match...

```The UNIQUE clause is the UNIQUE combination of ALL the columns put together. If
I used:

SELECT city,state UNIQUE FROM zip codes where state = 'CA'

I would get every unique city/state combination in CA, whereas if I used:

SELECT state UNIQUE from zip codes where state = 'CA'

I would get the first record matching 'CA', that is one record.

There is a way to get the city and state for the one record (why anyone would
want to I don't know) by creating a join to the same table and using the UNIQUE
clause in the join. I am not that good at join syntax, so I won't attempt it
here and embarrass myself. :-)

BTW you can get the last matching record by doing an ascending sort and using
LIMIT 1, but I think MS SQL suffers from not having a limit clause. Not sure
why. Instead you use the TOP clause.

Bob S

> On Mar 14, 2022, at 12:14 , Roger Guay via use-livecode
>  wrote:
>
>> Actually I must correct myself. That will not work because the unique value
>> column (typically an autoincrementing integer) will not be unique for each
>> record. Instead, assuming your lines of text are in a column called
>> "textdata"
>>
>> SELECT textdata UNIQUE FROM...
>>
>> Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Windows 11 incompatible?

```Ah thanks! That worked. Unfortunately there is no alternative for the Mac. :-(

Bob S

> On Mar 14, 2022, at 10:29 , Colin Holgate via use-livecode
>  wrote:
>
> No, you press Alt and tap the spacebar. Let go of both keys, then tap M, and
> tap any arrow key. Move the cursor to see the frontmost window is attached.
>
>
>> On Mar 14, 2022, at 11:25 AM, Craig Newman via use-livecode
>>  wrote:
>>
>> Hi, Colin.
>>
>> Hmmm.  I assume that all four of those keys are pressed at the same time?
>>
>> Craig
>>
>>> On Mar 14, 2022, at 11:52 AM, Colin Holgate via use-livecode
>>>  wrote:
>>>
>>> Yes it does. The M is for Move, if you’re working on a non-English system
>>> you would type the first letter for Move in your language.
>>>
>>>
On Mar 14, 2022, at 9:47 AM, Craig Newman via use-livecode
wrote:

Do I understand that, on Windows, typing those keys makes the frontmost
window track the cursor???
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Speaking of Filter and Match...

```Actually I must correct myself. That will not work because the unique value
column (typically an autoincrementing integer) will not be unique for each
record. Instead, assuming your lines of text are in a column called "textdata"

SELECT textdata UNIQUE FROM...

Bob S

> On Mar 14, 2022, at 08:29 , Bob Sneidar via use-livecode
>  wrote:
>
> They depend on the fact that arrays cannot have duplicate keys. Dumping the
> data into an SQL database and querying using the UNIQUE statement would do it
> too.
>
> SELECT * UNIQUE from ...
>
> Bob S
>
>
>
>> On Mar 13, 2022, at 13:16 , Roger Guay via use-livecode
>>  wrote:
>>
>> Thank you Jacqueline, Alex and Terry. Very interesting new (for me) methods
>> that I would never have come up with on my own.
>>
>> Roger
>>
>>> On Mar 13, 2022, at 1:05 PM, J. Landman Gay via use-livecode
>>>  wrote:
>>>
>>> On 3/12/22 8:54 PM, Roger Guay via use-livecode wrote:
>>>> I have a field with about a thousand lines with many duplicate lines, and
>>>> I want to delete the duplicates. Seems like this should be simple but I am
>>>> running around in circles. Can anyone help me with this?
>>>
>>> Making the list into an array is the easiest way but as mentioned, it will
>>> destroy the original order. If the order is important then you can restore
>>> it with a custom sort function. Here's my test handlers:
>>>
>>>
>>> on mouseUp
>>> put fld 1 into tData -- we keep this as a reference to the original order
>>> put tData into tTrimmedData -- this one will change
>>> split tTrimmedData by cr as set -- removes duplicates
>>> put keys(tTrimmedData) into tTrimmedData -- convert to a text list
>>> sort tTrimmedData numeric by origOrder(each,tData)
>>> put tTrimmedData into fld 1
>>> end mouseUp
>>>
>>> function origOrder pWord, @pData
>>> set wholematches to true -- may not matter, depends on the data
>>> return lineoffset(pWord, pData)
>>> end origOrder
>>>
>>> Field 1 contains lines in random order with duplicates.
>>>
>>> --
>>> Jacqueline Landman Gay | jac...@hyperactivesw.com
>>> HyperActive Software   | http://www.hyperactivesw.com
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Windows 11 incompatible?

```Is there a Macintosh equivalent to that??

Bob S

> On Mar 13, 2022, at 14:56 , Colin Holgate via use-livecode
>  wrote:
>
> There is an issue on Windows that would show similar symptoms. That is, if a
> window is opened off screen it’s as if the application has frozen.
>
> To see if that is the problem, type Alt-spacebar, M, any arrow key, and move
> the cursor. The offscreen window will be attached to the cursor, and a
> left-click will drop it off in the right place.
>
>
>> On Mar 13, 2022, at 3:40 PM, J. Landman Gay via use-livecode
>>  wrote:
>>
>> Well, you'd need an account with a school but since the problem is only on
>> launch you might be able to test that part.
>>
>>
>>
>> On 3/13/22 2:52 PM, Colin Holgate via use-livecode wrote:
>>> Do you have an app I can test?
On Mar 13, 2022, at 1:31 PM, J. Landman Gay via use-livecode
wrote:

We're getting reports that our LC app won't launch after the new Windows
11 update. Anyone else seeing this? If so, do you know what the problem is?

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

___
use-livecode mailing list
use-livecode@lists.runrev.com
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> 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
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Speaking of Filter and Match...

```They depend on the fact that arrays cannot have duplicate keys. Dumping the
data into an SQL database and querying using the UNIQUE statement would do it
too.

SELECT * UNIQUE from ...

Bob S

> On Mar 13, 2022, at 13:16 , Roger Guay via use-livecode
>  wrote:
>
> Thank you Jacqueline, Alex and Terry. Very interesting new (for me) methods
> that I would never have come up with on my own.
>
> Roger
>
>> On Mar 13, 2022, at 1:05 PM, J. Landman Gay via use-livecode
>>  wrote:
>>
>> On 3/12/22 8:54 PM, Roger Guay via use-livecode wrote:
>>> I have a field with about a thousand lines with many duplicate lines, and I
>>> want to delete the duplicates. Seems like this should be simple but I am
>>> running around in circles. Can anyone help me with this?
>>
>> Making the list into an array is the easiest way but as mentioned, it will
>> destroy the original order. If the order is important then you can restore
>> it with a custom sort function. Here's my test handlers:
>>
>>
>> on mouseUp
>> put fld 1 into tData -- we keep this as a reference to the original order
>> put tData into tTrimmedData -- this one will change
>> split tTrimmedData by cr as set -- removes duplicates
>> put keys(tTrimmedData) into tTrimmedData -- convert to a text list
>> sort tTrimmedData numeric by origOrder(each,tData)
>> put tTrimmedData into fld 1
>> end mouseUp
>>
>> function origOrder pWord, @pData
>> set wholematches to true -- may not matter, depends on the data
>> return lineoffset(pWord, pData)
>> end origOrder
>>
>> Field 1 contains lines in random order with duplicates.
>>
>> --
>> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Paste no closeField

```Yeah, I suppose. But I use the IDE a LOT. Remember my code is in a front
script, which is good, because it works for all my apps, and ONLY when entering
and leaving a field.

Bob S

> On Mar 11, 2022, at 08:48 , Klaus major-k via use-livecode
>  wrote:
>
> Hi Bob,
>
>> Am 11.03.2022 um 17:30 schrieb Craig Newman via use-livecode
>> :
>>
>> OK.
>>
>> Does this help? It catches pasting, but not typing.
>>
>> on textChanged
>> if the commandKey is down then beep
>> end textChanged
>
> you could also catch "on pastekey", but that will only work in a standalone,
> the IDE will catch and not pass it.
>
>>> On Mar 11, 2022, at 10:52 AM, Bob Sneidar via use-livecode
>>>  wrote:
>>>
>>> Because I don’t want to trigger it every time someone types a character,
>>> but that would be one way to do it. I clean up anything I drag or type into
>>> fields, stripping all but printable ascii because OCR PDF files contain a
>>> lot of crap that wreaks havoc with databases.
>>>
>>> Sent from my iPhone
>>>
>>>> On Mar 11, 2022, at 05:56, Craig Newman via use-livecode
>>>>  wrote:
>>>>
>>>> ﻿Hi.
>>>>
>>>> Why not use the “textChanged” message? That one would always fire if
>>>> pasting text.
>>>> Craig
>>>>
>>>>>> On Mar 10, 2022, at 5:57 PM, Bob Sneidar via use-livecode
>>>>>>  wrote:
>>>>>> works with fields whose nam
>
> Best
>
> Klaus
>
> --
> Klaus Major
> https://www.major-k.de
> https://www.major-k.de/bass
> 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

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Browser Widget Issues

```Still cannot understand why it is that my Apple Mail program seems to think a
completely different mail thread is the same thread as the one I was using. If
however people are clicking on one thread, replying and changing the subject,
in theory that is, well then that is just bad list etiquette. :-)

Bob S

> On Mar 11, 2022, at 10:25 , Rick Harrison via use-livecode
>  wrote:
>
> I was hoping to be able to programmatically
> tell the browser widget where to go to next
> by having LC click on an image or button
> within the browser window.
>
> So far I have had no success with that.
> Is there a bug in LC preventing me from
> doing this seemingly simple task?
>
> Is there a work around?
>
>
> Rick

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### matchText error??

```I have a matchtext string [0-9+-/\*]. I feed each character of "284,763" in a
repeat loop. To my understanding I ought to get "284673" but instead the comma
comes along to play too. Is that right?? Does 0-9 include commas??

Bob S

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Paste no closeField

```Because I don’t want to trigger it every time someone types a character, but
that would be one way to do it. I clean up anything I drag or type into fields,
stripping all but printable ascii because OCR PDF files contain a lot of crap
that wreaks havoc with databases.

Sent from my iPhone

> On Mar 11, 2022, at 05:56, Craig Newman via use-livecode
>  wrote:
>
> ﻿Hi.
>
> Why not use the “textChanged” message? That one would always fire if pasting
> text.
>
> Craig
>
>>> On Mar 10, 2022, at 5:57 PM, Bob Sneidar via use-livecode
>>>  wrote:
>>>
>>> works with fields whose nam
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: Paste no closeField

```It only works with fields whose name begins with "fld" (damn you spell correct!)

Bob S

> On Mar 10, 2022, at 14:53 , Bob Sneidar via use-livecode
>  wrote:
>
> It only works with fields whose name begins with "old"

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Paste no closeField

```hi all.

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

/*
If a user pastes something into a text field, then leaves the field, closeField
is not triggered. These two handlers
are the workaround for that. Only fields beginning with "fld"  are considered.
*/
on openField
put long id of the target into pField
if char 1 to 3 of the short name of pField is not "fld" then \
pass openField
set the savedtext of pField to the text of pField
pass openField
end openField

on exitField
put the long id of the target into pField
if char 1 to 3 of the short name of pField is not "fld" then \
pass exitField
if the text of pField is not the savedtext of pField then \
dispatch closeField to pField
set the savedtext of pField to empty
pass exitField
end exitField

Bob S
___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: revOpenDatabase over SSH tunnel?

```I do not think this is a mySQL issue. Livecode currently can only send one
statement per query to *any* sql server, at least that is what I have come to
understand. But I do not think issuing many queries from livecode is the
bottleneck, but rather the ability of the SQL server to respond. When I use
memory databases, the response time is nearly nil. A single mySQL query over a
LAN is not even noticeable. I make maybe 15 or so queries every time I select a
new customer in my Forms Generator app, and it isn't the queries that slow
things down, it's the populating of the datagrids and fields that take time.

Now on Windows, I think I do experience some delays with queries, but I think
that is just Windows networking security overhead.

Bob S

> On Mar 10, 2022, at 11:37 , doc hawk via use-livecode
>  wrote:
>
> I dropped mysql after the first run with my software—I don’t know if mysql
> could have handled it at the time, but LiveCode could only send a single
> command per transaction (afaik, this is still the case).  And with several
> hundred transactions to start a session . . . (there were also issues about
> lack of actual rollback).
>
> I switched to postgresql, which can trivially connect remotely.
> Unfortunately, even though the option is there in the command, and Postgres
> supports it, livecode still can’t do an encrypted connection to a postgres
> server.
>
> If I were going to continue, I suppose I would do it through an https
> connection to the server, possibly encrypting before sending and letting the
> server decrypt.

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: revOpenDatabase over SSH tunnel?

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

Bob S

> On Mar 10, 2022, at 10:55 , matthias rebbe via use-livecode
>  wrote:
>
> You are right.
>
> You invoke the SSH in a terminal on that machine that shall communicate with
> the MySQL database on a remote server.
> LC then connects  to itself (127.0.01) using the port you've used in the
> command for ssh connection, in my example 6102.
> That's it.
>
> As more and more servers do not allow remote MySQL access due to security
> restrictions, SSH tunneling or a solution like the one Bob has created are
> the only way. Whereby the SSH tunneling would allow a real direct
> communication. Which one is better, i do not know. It depends on the needs of
> the customer and also what software is available.
>
>
>
>
>> Am 10.03.2022 um 19:11 schrieb Ben Rubinstein via use-livecode
>> :
>>
>> Yes, my case is that the database is on a hosted platform which only
>> supports access over SSH.
>>
>> My reading of your document, Matthias, is that we simply invoke SSH in a
>> terminal, and then LiveCode/revOpenDatabase uses that tunnel automatically
>> because the database host is at the same address. Can that be right? Or does
>> this only work with LiveCode server?
>>
>> Ben
>>
>> On 10/03/2022 16:42, matthias rebbe via use-livecode wrote:
>>> There is nothing wrong with your method. But there might be situations
>>> where you need direct access to the MySQL database, e.g. you are using 3rd
>>> party software (in my case SQLPro Studio) or libraries. I have a customer
>>> who is using a special Delphi library that only supports direct connections.
>>> Okay that is not the case when using Livecode. But there might be servers
>>> that do not run Livecode Server. In this case you cannot use your solution.
>>> In this case SSH tunneling would be a safe solution.
>>>> Am 10.03.2022 um 17:14 schrieb Bob Sneidar via use-livecode
>>>> :
>>>>
>>>> I am not sure what SSH tunneling is, but I did a proof of concept where I
>>>> had an LC client app communicating with an LC server app that encrypted
>>>> the data at the client end before sending it, and the server end decrypted
>>>> it. I just used non-secured sockets. I used AES encryption with a key only
>>>> I know, and a method for corrupting the data in a way only the server can
>>>> "cleanse".
>>>>
>>>> I suppose some may advise me on what is wrong with this method, and I
>>>> welcome the input, but it worked for me. No unencrypted data went "over
>>>> the wire".
>>>>
>>>> The reason I developed this method is because I do not want to deal with
>>>> expiring security certificates or secure websites to handle the data
>>>> transfer. The method works out of the box.
>>>>
>>>> Bob S
>>>>
>>>>
>>>>> On Mar 10, 2022, at 03:34 , Ben Rubinstein via use-livecode
>>>>>  wrote:
>>>>>
>>>>>
>>>>> I need to access a (MySQL) database on a remote service - which has to be
>>>>> done over an SSH tunnel.
>>>>>
>>>>> Has anyone done this in LiveCode? Is it trivial/possible/impossible?
>>>>>
>>>>> TIA,
>>>>>
>>>>> Ben
>>>>>
>>>>> ___
>>>>> use-livecode mailing list
>>>>> use-livecode@lists.runrev.com
>>>>> subscription preferences:
>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>
>>>>
>>>> ___
>>>> use-livecode mailing list
>>>> use-livecode@lists.runrev.com
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscri```

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

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

Bob S

> On Mar 10, 2022, at 10:33 , Richmond via use-livecode
>  wrote:
>
> What do you mean when you write "I'm still supporting LC 6.7"?
>
> On 10.03.22 20:25, Curry Kenworthy via use-livecode wrote:
>>
>> To plan addon development for the next few years,
>> I would like to know if some people still need LC 6.7.
>>
>> If you're a Lurker, that's OK! If shy: offlist is fine.
>> (Regulars welcome too, of course.)
>>
>> Currently I'm still supporting LC 6.7 too, but as LC 9
>> matures on bugs/stability and performance, hopefully
>> there will come a time when I can make this decision.
>>
>> Supporting LC 6.7 and 9/10 is fine, in fact it's fun,
>> but moving past 6.7 eventually would have some perks.
>> So the question is how long people will still need it.
>>
>> Your input will help guide my plan! Thanks.
>>
>> Best wishes,
>>
>> Curry Kenworthy

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: [ANN] SpreadLib ordering is back online

```I'm really looking forward to this update Curry. I have a current need for

Bob S

> On Mar 9, 2022, at 12:53 , Curry Kenworthy via use-livecode
>  wrote:
>
>
> The SpreadLib order page is back up:
>
>
> This is NOT a new version! Just the "store restored"
> after going offline when eSellerate died.
> (I've marked the price down a bit, though, at SendOwl.)
>
> but COVID nuked my productivity those last two years,
> so it never got the License keys for a public release.
>
> That's a priority this year, therefore
>
> Here's the SpreadLib for 2022 Plan:
>
> - Public release during Summer.
> - New backend integration for more frequent updates.
> - Multi-sheet handling.
> - Updated and expanded Documentation.
> - Many more improvements done before 2020.
>
> (Meanwhile, WordLib is first in line again,
> with a minor version coming up around Easter
> for supercharged MS Word Comments.)
>
> Happy coding! More news soon
>
> Best wishes,
>
> Curry Kenworthy
>
> SpreadLib: Excel files to LC fields in 1 script line!
> "Excel-lent spreadsheet import and export for LiveCode"
>
> Innovative Christian LiveCode Training and Consulting
> "Better Methods, Better Results"
> http://livecodeconsulting.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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: LC and SqlLite Question

```As mentioned, only for reads, only one for write. But why not create a server
agent that is responsible for handling multiple connections from clients, and
the server agent can be the single connection to the sqLite database?

Bob S

> On Mar 10, 2022, at 08:34 , Paul Dupuis via use-livecode
>  wrote:
>
> Can a sqlLite database file on disk be accessed by more than 1 LiveCode app
> at the same time?
>
> A server hosted mySql database can be accessed by any number of client LC
> apps at the same time as the serve side mySql does the record locking
> necessary, but what about a sqlLite file?
>
> Obviously, I could code up some test apps and try it, but I am hoping some
> one on the list definitively know for sure.
>
>
> ___
> 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
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: revOpenDatabase over SSH tunnel?

```Yes, the server agent part resides on the same device that the SQL Server is
on. The server agent communicates directly with the SQL server, and is
responsible for making and storing connection specifics. The client agent can
request a list of connections from the server agent when it connects to it. All
that passes between the client and server are these requests for connections,
the sql statements the server needs to execute, and the data the server
retrieves. All back and forth are encrypted. It's really quite elegant if I do
say so myself. :-)

It really is just the framework for any client server solution. It can be used
for a document storage and retrieval system too, or anything you want to
communicate between two devices securely.

Bob S

> On Mar 10, 2022, at 08:42 , matthias rebbe via use-livecode
>  wrote:
>
> There is nothing wrong with your method. But there might be situations where
> you need direct access to the MySQL database, e.g. you are using 3rd party
> software (in my case SQLPro Studio) or libraries. I have a customer who is
> using a special Delphi library that only supports direct connections.

___
use-livecode mailing list
use-livecode@lists.runrev.com
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

```

### Re: revOpenDatabase over SSH tunnel?

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

I suppose some may advise me on what is wrong with this method, and I welcome
the input, but it worked for me. No unencrypted data went "over the wire".

The reason I developed this method is because I do not want to deal with
expiring security certificates or secure websites to handle the data transfer.
The method works out of the box.

Bob S

> On Mar 10, 2022, at 03:34 , Ben Rubinstein via use-livecode
>  wrote:
>
>
> I need to access a (MySQL) database on a remote service - which has to be
> done over an SSH tunnel.
>
> Has anyone done this in LiveCode? Is it trivial/possible/impossible?
>
> TIA,
>
> Ben
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please 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