Re: Divide Large Data Blob?

2022-05-16 Thread Bob Sneidar via use-livecode
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?

2022-05-16 Thread Bob Sneidar via use-livecode
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?

2022-05-16 Thread Bob Sneidar via use-livecode
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?

2022-05-16 Thread Bob Sneidar via use-livecode
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

2022-05-12 Thread Bob Sneidar via use-livecode
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

2022-05-11 Thread Bob Sneidar via use-livecode
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

2022-05-10 Thread Bob Sneidar via use-livecode
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

2022-05-07 Thread Bob Sneidar via use-livecode
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?

2022-05-06 Thread Bob Sneidar via use-livecode
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

2022-05-06 Thread Bob Sneidar via use-livecode
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

2022-05-05 Thread Bob Sneidar via use-livecode
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

2022-05-03 Thread Bob Sneidar via use-livecode
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

2022-05-03 Thread Bob Sneidar via use-livecode
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

2022-04-29 Thread Bob Sneidar via use-livecode
; 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

2022-04-28 Thread Bob Sneidar via use-livecode
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

2022-04-28 Thread Bob Sneidar via use-livecode
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

2022-04-28 Thread Bob Sneidar via use-livecode
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

2022-04-28 Thread Bob Sneidar via use-livecode
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

2022-04-28 Thread Bob Sneidar via use-livecode
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?

2022-04-28 Thread Bob Sneidar via use-livecode
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?

2022-04-27 Thread Bob Sneidar via use-livecode
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

2022-04-22 Thread Bob Sneidar via use-livecode
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

2022-04-21 Thread Bob Sneidar via use-livecode
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

2022-04-21 Thread Bob Sneidar via use-livecode
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

:memory: heads up

2022-04-21 Thread Bob Sneidar via 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

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

2022-04-21 Thread Bob Sneidar via use-livecode
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

2022-04-12 Thread Bob Sneidar via use-livecode
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

2022-04-12 Thread Bob Sneidar via use-livecode
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?

2022-04-12 Thread Bob Sneidar via use-livecode
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?

2022-04-12 Thread Bob Sneidar via use-livecode
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

2022-04-06 Thread Bob Sneidar via use-livecode
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

2022-04-06 Thread Bob Sneidar via use-livecode
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

2022-04-05 Thread Bob Sneidar via use-livecode
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?

2022-04-04 Thread Bob Sneidar via use-livecode
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?

2022-04-04 Thread Bob Sneidar via use-livecode
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

2022-03-30 Thread Bob Sneidar via use-livecode
> 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

2022-03-30 Thread Bob Sneidar via use-livecode
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

2022-03-30 Thread Bob Sneidar via use-livecode
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

2022-03-30 Thread Bob Sneidar via use-livecode
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

2022-03-28 Thread Bob Sneidar via use-livecode
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

2022-03-28 Thread Bob Sneidar via use-livecode
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

2022-03-24 Thread Bob Sneidar via use-livecode
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

2022-03-24 Thread Bob Sneidar via use-livecode
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

2022-03-22 Thread Bob Sneidar via use-livecode
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

2022-03-22 Thread Bob Sneidar via use-livecode
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

2022-03-22 Thread Bob Sneidar via use-livecode
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

2022-03-22 Thread Bob Sneidar via use-livecode
> 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

2022-03-22 Thread Bob Sneidar via use-livecode
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

2022-03-22 Thread Bob Sneidar via use-livecode
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

2022-03-22 Thread 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

Re: There is no TextEdit.app???

2022-03-22 Thread Bob Sneidar via use-livecode
>> 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???

2022-03-22 Thread Bob Sneidar via use-livecode
;>> 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???

2022-03-21 Thread Bob Sneidar via use-livecode
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???

2022-03-21 Thread Bob Sneidar via use-livecode
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???

2022-03-21 Thread Bob Sneidar via use-livecode
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???

2022-03-21 Thread Bob Sneidar via use-livecode
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

2022-03-19 Thread Bob Sneidar via use-livecode
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??

2022-03-19 Thread Bob Sneidar via use-livecode
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

2022-03-18 Thread Bob Sneidar via use-livecode
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??

2022-03-18 Thread Bob Sneidar via use-livecode
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

2022-03-18 Thread Bob Sneidar via use-livecode
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

2022-03-18 Thread Bob Sneidar via use-livecode
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

2022-03-18 Thread Bob Sneidar via use-livecode
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

2022-03-18 Thread Bob Sneidar via use-livecode
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?

2022-03-18 Thread Bob Sneidar via use-livecode
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

2022-03-17 Thread Bob Sneidar via use-livecode
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

2022-03-17 Thread Bob Sneidar via use-livecode
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

2022-03-17 Thread Bob Sneidar via use-livecode
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

2022-03-17 Thread 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 load

Re: Excel Lib 1.4

2022-03-17 Thread Bob Sneidar via use-livecode
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

2022-03-16 Thread Bob Sneidar via use-livecode
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

2022-03-16 Thread Bob Sneidar via use-livecode
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

2022-03-16 Thread Bob Sneidar via use-livecode
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

2022-03-16 Thread 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

Re: :MEMORY: databases and Windows

2022-03-16 Thread Bob Sneidar via use-livecode
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

2022-03-16 Thread Bob Sneidar via use-livecode
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

2022-03-16 Thread Bob Sneidar via use-livecode
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

2022-03-16 Thread Bob Sneidar via use-livecode
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

2022-03-16 Thread Bob Sneidar via use-livecode
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

2022-03-16 Thread Bob Sneidar via use-livecode
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

2022-03-15 Thread Bob Sneidar via use-livecode
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

2022-03-15 Thread 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

Re: Speaking of Filter and Match...

2022-03-14 Thread Bob Sneidar via use-livecode
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?

2022-03-14 Thread Bob Sneidar via use-livecode
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-03-14 Thread Bob Sneidar via use-livecode
, 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?

2022-03-14 Thread Bob Sneidar via use-livecode
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...

2022-03-14 Thread Bob Sneidar via use-livecode
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

2022-03-11 Thread Bob Sneidar via use-livecode
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

2022-03-11 Thread Bob Sneidar via use-livecode
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??

2022-03-11 Thread Bob Sneidar via use-livecode
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

2022-03-11 Thread Bob Sneidar via use-livecode
> 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

2022-03-10 Thread Bob Sneidar via use-livecode
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

2022-03-10 Thread Bob Sneidar via use-livecode
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?

2022-03-10 Thread Bob Sneidar via use-livecode
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?

2022-03-10 Thread Bob Sneidar via use-livecode
>>> 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)

2022-03-10 Thread Bob Sneidar via use-livecode
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

2022-03-10 Thread Bob Sneidar via use-livecode
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

2022-03-10 Thread Bob Sneidar via use-livecode
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?

2022-03-10 Thread Bob Sneidar via use-livecode
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?

2022-03-10 Thread 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

  1   2   3   4   5   6   7   8   9   10   >