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

### Re: Divide Large Data Blob?

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 1

### Re: Divide Large Data Blob?

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

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

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

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

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

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

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

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

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

### Re: getProp and passing values

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

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

### Re: devcon 2022 recap

; 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

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

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

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

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

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

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

### Re: Single Window LC IDE?

I watched the keynote by Kevin, and I think all your concerns are slated to be addressed. 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

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

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

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

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

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

### Re: Standalone Error Dialog

acqueline 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: >> >> 1 File to include

### Standalone Error Dialog

Hi all. Some time ago I began getting an error dialog reporting: 1 File to include in standalone not found: "" 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?

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

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

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

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

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

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

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 t

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

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

### Re: Stack offscreen solution

e 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

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

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

### Re: Getting Webpage Information

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

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

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

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

### 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 Please visit this url to

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

### 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),

### Re: ExcelLib in a standalone

> 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

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

### Re: ExcelLib in a standalone

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

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

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

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

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

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

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

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

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

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

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

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

### Re: ArrayEncode/Decode broken??

inary. 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 Snei

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

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

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

### Re: Excel Lib 1.4

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

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

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

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

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

### Re: Excel Lib 1.4

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

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

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

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

### 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 Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

### Re: :MEMORY: databases and Windows

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 Bo

### Re: :MEMORY: databases and Windows

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

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

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

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

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

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

### Re: Excel_Lib on Mac

ith 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. Ther

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

### Re: Excel_Lib on Mac

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.

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

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

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

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

, 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

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

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

### Re: Paste no closeField

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

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

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

### Re: Paste no closeField

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

### 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" _

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

### Re: revOpenDatabase over SSH tunnel?

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

### Re: revOpenDatabase over SSH tunnel?

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

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

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

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

### Re: LC and SqlLite Question

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

### Re: revOpenDatabase over SSH tunnel?

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

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