Strange times, amazing projects

Good afternoon LC'ers (evening to some), Enjoyed the Zoom chat today and it was good to see all of your faces again. It has been way too long. Over the past couple of years I have been sidetracked from LC as I have not had the need to be as hands on as I once was. Now, however, I am forced to p

Problems locating Android SDK

I am relatively new to Mac so if this is an easy fix, sorry for asking. I have installed Android Studio and the SDK is located in my user/library directory. I figured out how to reveal the library folder using Finder but when I try to browse to the SDK location in Livecode settings, I am not able

Re: Problems locating Android SDK

e, LiveCode doesn’t recognize it as > valid Android SDK root. It’s been a few years since I had to set that path. > > > > On Apr 5, 2020, at 3:25 PM, Skip Kimpel via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > > I am relatively new to Mac so if this

Re: Problems locating Android SDK

n: "Android SDK Tools (Obsolete)" - > check that, hit "Apply" - it will download the files and "Tools" folder > will appear in the /Users/youruser/Library/Android/sdk/ folder: > > > > > > HTH, > > - > Matthias Rebbe > Life Is Too Sh

Re: Problems locating Android SDK

indow. > > > > - Now there should appear a new option: "Android SDK Tools (Obsolete)" - > check that, hit "Apply" - it will download the files and "Tools" folder > will appear in the /Users/youruser/Library/Android/sdk/ folder: > > > > > > > >

Re: Problems locating Android SDK

I did an uninstall of the Android Studio and re-installed it. After that, it worked. Go figure! SKIP On Sun, Apr 5, 2020 at 8:55 PM Sannyasin Brahmanathaswami via use-livecode < use-livecode@lists.runrev.com> wrote: > ~/Library/Android/sdk/ > > I don't use virtual machines... I just use my Mot

Re: Problems locating Android SDK

Richard, It took me two attempts at the Android Studio install. I realized during the first attempt that I had cut it short before it had finished everything. After re-installing, it worked just fine. SKIP On Mon, Apr 6, 2020 at 1:47 PM Colin Holgate via use-livecode < use-livecode@lists.runre

Livecode and AWS Sql

Any trick to connecting to an AWS Sql instance? I am using some of my old scripts that always hooked up properly to a local Sql server. Wondering if I might be a trick for AWS or heck, my method might be old and there is a better way to do it. *put revOpenDatabase("ODBC","DRIVER=SQL Server;SERVE

Re: Livecode and AWS Sql

I forgot to mention that I am on a Mac... also very new to me. This might also have something to do with how the SQL connection script is written. SKIP On Thu, Apr 9, 2020 at 10:09 PM Skip Kimpel wrote: > Any trick to connecting to an AWS Sql instance? I am using some of my old > scripts that

Re: Livecode and AWS Sql

e- > From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On > Behalf > Of Skip Kimpel via use-livecode > Sent: Thursday, April 09, 2020 10:10 PM > To: How to use LiveCode > Cc: Skip Kimpel > Subject: Livecode and AWS Sql > > Any trick to connecting to an AWS S

Re: Livecode and AWS Sql

> >> -Original Message- >> From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On >> Behalf >> Of Skip Kimpel via use-livecode >> Sent: Thursday, April 09, 2020 10:10 PM >> To: How to use LiveCode >> Cc: Skip Kimpel >> Subject: L

Re: Livecode and AWS Sql

... am able to connect via other programs. > > > > SKIP > > > > On Fri, Apr 10, 2020 at 8:44 AM Ralph DiMola via use-livecode < > use-livecode@lists.runrev.com> wrote: > > Firewall port? > > Ralph DiMola > IT Director > Evergreen Information Serv

Re: Livecode and AWS Sql

gt; find too much help. Anybody have suggestions on this piece? > > SKIP > > > > On Fri, Apr 10, 2020 at 9:44 AM Skip Kimpel wrote: > > Nope... am able to connect via other programs. > > > > SKIP > > > > On Fri, Apr 10, 2020 at 8:44 AM Ralph DiMol

Re: Livecode and AWS Sql

ubject: Re: Livecode and AWS Sql >> >> >> >> I am so used to running in the Windows world that I don't think I have a >> SQL ODBC driver installed on my MAC. I googled it a little bit and did not >> find too much help. Anybody have suggestions on this piece

Re: Livecode and AWS Sql

o use LiveCode > Cc: Ralph DiMola > Subject: Re: Livecode and AWS Sql > > > > I am so used to running in the Windows world that I don't think I have a > SQL ODBC driver installed on my MAC. I googled it a little bit and did not > find too much help. Anybody have su

Re: Livecode and AWS Sql

rgreeninfo.net >> >> Phone: 518-636-3998 Ex:11 >> >> Cell: 518-796-9332 >> >> >> >> From: Skip Kimpel [mailto:skiplon...@gmail.com] >> Sent: Friday, April 10, 2020 10:19 AM >> To: How to use LiveCode >> Cc: Ralph DiMola >> Subject: Re: Livecode an

Re: Livecode and AWS Sql

gt; Sent: Friday, April 10, 2020 10:19 AM > To: How to use LiveCode > Cc: Ralph DiMola > Subject: Re: Livecode and AWS Sql > > > > I am so used to running in the Windows world that I don't think I have a > SQL ODBC driver installed on my MAC. I googled it a little bit an

Re: Livecode and AWS Sql

hat I needed to Xcode 10.1 in order to be compatible with the latest >> version of LC. Maybe I am wrong here. >> >> >> >> >> >> SKIP >> >> >> >> On Fri, Apr 10, 2020 at 10:28 AM Ralph DiMola via use-livecode < >> use-liveco

Re: Livecode and AWS Sql

hat communicates with ODBC must be on the same device as the DSN. > > > > May not be your issue. > > > > Bob S > > > > > >> On Apr 10, 2020, at 4:36 AM, Skip Kimpel via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> > &

Re: Livecode and AWS Sql

> socket apps. > > Since they encrypt both ways, it’s secure as well, and I do not have to > enable SSL on my mySQL server and futz with SSL certs. > > Bob S > > > > On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode < > use-livecode@lists.runrev.com> wro

Re: Livecode and AWS Sql

e ODBC connections are easy and > built in. Then I will have my Mac or Windows LC apps send queries via the > socket apps. > >> > >> Since they encrypt both ways, it’s secure as well, and I do not have to > enable SSL on my mySQL server and futz with SSL certs. >

Re: Livecode and AWS Sql

Mac or Windows LC apps send queries via > the > >> socket apps. > >> > >> Since they encrypt both ways, it’s secure as well, and I do not have to > >> enable SSL on my mySQL server and futz with SSL certs. > >> > >> Bob S > >>

Re: Livecode and AWS Sql

never were able to use them with ODBC Manager. > In the middle of the page at > > https://docs.microsoft.com/de-de/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 > you´ll find more information about it > > > Matthias > > > > &g

Even Distribution

I have 15 "jobs" that need to be assigned to 7 "drivers". How would you evenly distribute the jobs to the drivers? In this case one of the drivers would have 3 jobs while the others have two. Obviously, the number of drivers and number of jobs would fluctuate. This has been my mind twister for t

Re: Even Distribution

ete basis so that all were busy for > about the same time. > > > On 16-Apr-2020, at 8:23 PM, Skip Kimpel via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > > I have 15 "jobs" that need to be assigned to 7 "drivers". How would you &g

Re: Even Distribution

to complete basis so that all were busy for >> about the same time. >> >> > On 16-Apr-2020, at 8:23 PM, Skip Kimpel via use-livecode < >> use-livecode@lists.runrev.com> wrote: >> > >> > I have 15 "jobs" that need to be assigned to 7 &qu

Re: Even Distribution

have long trips and short trips, I would try >>> and allocate on an estimated time to complete basis so that all were busy >>> for about the same time. >>> >>> > On 16-Apr-2020, at 8:23 PM, Skip Kimpel via use-livecode < >>> use-livecode@lists.runre

Re: Even Distribution

or an oversimplification, > but there is an easy way to find if the jobs can be exactly evenly > distributed, with nothing left over: > if (tjobs mod tdrivers) = 0 then // it is evenly distrutable. > .Jerry > > > On Apr 16, 2020, at 7:41 PM, Skip Kimpel via use-livecode < &

Re: Even Distribution

but there is an easy way to find if the jobs can be exactly evenly > distributed, with nothing left over: > > if (tjobs mod tdrivers) = 0 then // it is evenly distrutable. > > .Jerry > > > >> On Apr 16, 2020, at 7:41 PM, Skip Kimpel via use-livecode < > use-l

Counting unique items in a file

Good afternoon LC'ers, I am loading a tab delimited file into a variable and I need to pull out all unique names from a certain column (let's say column 10) and count how many times that name appears in that column. I know there has to be an easy way of doing it. Every time I try to start coding

Re: Counting unique items in a file

You should get back an array keyed by the unique names, and how many > instances of each one > > > -Dan > > > > On 4/27/20, 10:25 AM, "use-livecode on behalf of Skip Kimpel via > use-livecode" use-livecode@lists.runrev.com> wrote: > > Good afte

Re: Counting unique items in a file

gt; "combine " the array with "return and "comma" > Craig > > > -Original Message- > From: Skip Kimpel via use-livecode > To: Dan Friedman > Cc: Skip Kimpel ; How to use LiveCode < > use-livecode@lists.runrev.com> > Sent: Mon, Apr 27

Re: Counting unique items in a file

use-livecode@lists.runrev.com> wrote: > >> Hi. >> You are getting empty because the information returned from the function >> is an array. >> "combine " the array with "return and "comma" >> Craig >> >> >> -Origina

Best relational database for IOS / Android

Good morning, In your opinion, what is the best relational database to use for an IOS / Android application? Being a PC guy and always living in the Microsoft world, I always default to SQL, however, with my latest discoveries of the complexities involved and lack of support in LC I don't think t

MP3 ID3 tag writer

Has anybody written a library for this? Looking to write ID3 tags for mp3 files including the addition to mp3 artwork. Thoughts? SKIP ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage

Re: MP3 ID3 tag writer

; > > http://marksmith.on-rev.com/revstuff/files/libID3.zip > > > > Here's an overview of his rev stacks: > > > > http://marksmith.on-rev.com/revstuff/ > > > > - > > Matthias Rebbe > > Life Is Too Short For Boring Code > > > >> Am 24.

Re: MP3 ID3 tag writer

t;> > http://marksmith.on-rev.com/revstuff/files/libID3.zip >> > >> > Here's an overview of his rev stacks: >> > >> > http://marksmith.on-rev.com/revstuff/ >> > >> > - >> > Matthias Rebbe >> > Life Is Too Short Fo

Re: MP3 ID3 tag writer

com/revstuff/files/libID3.zip >>> > >>> > Here's an overview of his rev stacks: >>> > >>> > http://marksmith.on-rev.com/revstuff/ >>> > >>> > - >>> > Matthias Re

Problems with text data fields pulling from SQL

I am pulling data from an Azure MS SQL database using an ODBC connection. All data comes across just fine EXCEPT for data with field types of NVARCHAR(Max). When those fields arrive to LC, it shows up as a question mark "?". Any reason why this would happen? Any resolution to this? Best regard

Looking to hire API (SOAP) expert (work for hire)

I have a project on my plate that needs some assistance with an API integration. Need some help kicking it off and getting everything connected... from there on out, I can make the "calls" but need the initial assistance. Anybody interested in taking this on? Obviously I will pay you for your wo

Also looking for MSSQL integration person

I have MSSQL data flowing into my project but two data input fields are coming through as "?" instead of the actual text. WIlling to pay someone to help me figure this out. Please contact me directly at s...@magicgate.com Thank you! SKIP ___ use-live

Re: Also looking for MSSQL integration person

able(s) are using or set > the encoding of the table(s) in the database to what you want and then > perform the appropriate textEncode or textDecode operations in LC > > > > On 7/26/2021 4:44 PM, Skip Kimpel via use-livecode wrote: > > I have MSSQL data flowing into my proj

Re: Also looking for MSSQL integration person

g in the database. >> >> You need to either look up what encoding you table(s) are using or set >> the encoding of the table(s) in the database to what you want and then >> perform the appropriate textEncode or textDecode operations in LC >> >> >>

Re: Also looking for MSSQL integration person

try_cast worked!!! I converted those fields, using that technique, into a varchar and BAM! Thank you, Bob! SKIP On Mon, Jul 26, 2021 at 7:29 PM Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > > MSSQL has a try_cast snf cast function. > > That should read MSSQL has a try_

Most streamlined method to get data

I have a variable that contains: ,Name,,,Quantity,Total,,,Percent ,Dine In,,,189,"$4,812.71",,,57.96% ,Take Out,,,72,"$1,676.43",,,20.19% ,3rd Party,,,54,"$1,779.35",,,21.43% ,Bakery,,,3,$34.83,,,0.42% ,Total,,,318,"$8,303.32",,, What is the best way to get 8303.32 f

Re: Most streamlined method to get data

So to give you a full sense of the ugliness of the CSV I am working with, here it is: (trying to add certain columns but because some columns have multiple "thousand dollar+ amounts, it throws doing an item count. Need to get rid of all dollar signs (easy) and all the commas that are part of a th

Re: Most streamlined method to get data

It looks like all the "thousand dollar+" amounts are quoted - i.e. it's > an example of a regular CSV file - ugly but predictable. > > Did you try the CSVToTab converter ? > > > https://github.com/macMikey/csvToText > <https://github.com/macMikey/csvToText>

Need to populate array into datagrid

What is the best way to do this? I have searched my old code, online results, etc and cannot find a clear cut answer. Having said that, it has been a VERY long time since I have done this so I am part of the "use it or lose it" club right now. Any help would be greatly appreciated! SKIP ___

Re: Need to populate array into datagrid

way tiggers the LayoutControl and FillInData handlers in the > datagrid, so these need to be the same as (or be modified to meet) the > structure of the incoming data. > > There is more in the dictionary under dgData and dgText. > > Mark > > > On Aug 10, 2021, at 7:52 PM,

Re: [ANN] Organize - A daily task manager

Me as well! Looks like a fantastic product. SKIP > On Aug 25, 2021, at 8:08 PM, Marc Siskin via use-livecode > wrote: > > Mark, > > I would like to test your app. I need an invitation code in order to do so. > > If you still have space, please send me a code directly to my e-mail. > > Th

Re: [ANN] Organize - A daily task manager

Thank you, Mark! > On Aug 26, 2021, at 5:55 AM, Mark Smith via use-livecode > wrote: > > Hi Skip, I’ve sent you a direct link in email as well. > > Cheers, > Mark > >> On Aug 26, 2021, at 1:13 AM, Skip Kimpel via use-livecode >> wrote: >> >

Re: [ANN] Organize - A daily task manager

cked > > Checked > >All > > ••• > > > > The ••• could be for the ‘more…’ maybe that could open the settings or > a dialog with other view options. > > > > Martin > > > > > >> On Aug 26, 2021, at 7:48 AM, Skip Kimpel

JSON to Datagrid

I have been googling a solution for this but have not found a solid solution for this. Can anybody lead me in the right direction on this? SKIP ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe a

Re: JSON to Datagrid

To functions actually needed... need to be able to convert to a datagrid and I will be also pumping this data into a SQL server. SKIP On Wed, Dec 8, 2021 at 11:15 AM Skip Kimpel wrote: > I have been googling a solution for this but have not found a solid > solution for this. > > Can anybody lea

Livecode / Github

Greetings! Been a while since I have been on this list. Working on a new project and wondering if the backing up of Livecode files to Github was ever implemented and created. I know there was talk of it at one time. I apologize if it has been in place for a while and I am just out of the loop.

AR applications?

Has anybody done anything with LC and AR? Curious minds want to know :) SKIP ___ 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/

Re: AR applications?

will be more possible. > > Rick > >> On May 27, 2023, at 12:26 PM, Skip Kimpel via use-livecode >> wrote: >> >> Has anybody done anything with LC and AR? >> >> Curious minds want to know :) >> >> SKIP > > ___

Re: Livecode Future - End User Cost Extravaganza

Wow… just catching up on this thread, and I have to say, I am more confused than ever! Not sure the licensing model needed to be this complicated and questioning if LC even knows who its end user is and what we are developing. I don’t mean to be trouble here, and I am probably misconstruing fa

Re: [ANN] v2.2 of DB Lib

Is there an upgrade charge? SKIP KIMPEL On Mon, Jun 18, 2018 at 11:12 PM, Andre Garzia via use-livecode < use-livecode@lists.runrev.com> wrote: > Friends, > > After ages without updating my tools, I've resumed working on them. Today I > am releasing a tentative version of DB Lib v2.2 which has b

Preview HTML of a field

I would like to preview the HTML that exists in a field and preview it within LC. What is the best way of doing this? SKIP ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscr

Re: Preview HTML of a field

Thank you Andy and Paul for your input. Having said that, I have tried both techniques and am still not able to produce the results. Any other insight I might be missing? Seems like such a simple thing, not sure why I am struggling with this. SKIP On Wed, Aug 15, 2018 at 11:03 AM Paul Dupuis v

Re: Preview HTML of a field

So sorry, my bad!!! I had, for some reason, commented out a key element of this and that is why it was not rendering. I knew it was easier than I made it out to be! Thanks again for your help in this matter! SKIP On Wed, Aug 15, 2018 at 11:03 AM Paul Dupuis via use-livecode < use-livecode@list

Re: Preview HTML of a field

ding coming out of the database, that would preclude database > encoding, especially if you are using a blob column as those (to my > knowledge) are already binary type. > > Bob S > > > > On Aug 15, 2018, at 08:15 , Skip Kimpel via use-livecode < > use-livecode@lists.

Re: What's Happening with TactileMedia?

I can only dream that they would bring Scott into the folds of the LiveCode and make his amazing visual interface components part of the base package. It would be win/win for everybody! SKIP On Thu, Aug 24, 2017 at 3:30 PM, Richard Gaskin via use-livecode < use-livecode@lists.runrev.com> wrote:

LC on Raspberry Pi3

Anybody running any apps on RPi3 (Raspbian)? SKIP ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Microsoft 365 Rest API

I am very interested in this functionality as well. SKIP On Thu, Oct 12, 2017 at 8:54 AM, Pi Digital via use-livecode < use-livecode@lists.runrev.com> wrote: > I’ve been currently working on a project with another Livecoder making a > library to work with MS Dynamics365. It turns out that the be

Re: Microsoft 365 Rest API

Roger... why is it that you and I are ALWAYS on the same page and interested in the same things? Love it! SKIP On Thu, Oct 12, 2017 at 9:43 AM, Roger Eller via use-livecode < use-livecode@lists.runrev.com> wrote: > VERY interested! Will this be shared, or become a add-on product for the > LC c

Re: Microsoft 365 Rest API

Amen to that... SKIP On Thu, Oct 12, 2017 at 9:54 AM, Roger Eller via use-livecode < use-livecode@lists.runrev.com> wrote: > Skip, we are piloting the same starship in alternate universes, I do > believe. ;) > > ~Roger > > > On Thu, Oct 12, 2017 at 9:47 AM, Skip Kimp

Re: [OT] Download Request

I just checked and I don't see it. SKIP KIMPEL On Wed, Jan 11, 2017 at 12:09 PM, Randy Hengst via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi All, > > I successfully had three iOS apps approved for sale by Apple on Jan 8th. > So far they have not shown up on the Apple App Store… wh

Re: It looks like Director is Finally Dead

Sad to see it officially going away but the writing on the wall has been there for YEARS. I think most of us switched to other tools to do what we once did in Director. That is why we are now all friends of LiveCode :) SKIP On Fri, Jan 27, 2017 at 1:25 PM, Colin Holgate via use-livecode < use-l

Re: It looks like Director is Finally Dead

I am going to have to bring those out of the archives just for old times sake especially the "Is Director Dead" episodes. Appreciate the comment, Tom. SKIP On Sat, Jan 28, 2017 at 9:26 AM, tbodine via use-livecode < use-livecode@lists.runrev.com> wrote: > Hey, Skip. > > I always loved your

Re: Drag List Items Up and Down

Very nice little script! Question: You can actually drag an item "up" and out of the field and it disappears forever. Any way to avoid this? SKIP KIMPEL On Thu, Feb 2, 2017 at 11:14 AM, AndyP via use-livecode < use-livecode@lists.runrev.com> wrote: > Try this > > Create a scrolling field > >

Re: Drag List Items Up and Down

Excellent... works like a charm. Thanks for sharing! SKIP On Thu, Feb 2, 2017 at 1:48 PM, AndyP via use-livecode < use-livecode@lists.runrev.com> wrote: > Modified script > added > > /if within (field "myField", the mouseLoc) is true then / > > on mouseDown > >put word 2 of the clickLine in

Re: Creating LiveCode applications that play well with version control software

I second Dave's comments very well done and a foundation for amazing things to come. This is been an issue that has been brought up in the past and you have made great headways into making version control a reality in LiveCode. SKIP On Sun, Feb 5, 2017 at 8:55 AM, Dave Kilroy via use-livecod

Re: LiveCode + Amazon CloudFront

No suggestions but if somebody is going to develop this, please add in support for Windows. This would be a great addition! SKIP > On Feb 20, 2017, at 2:27 AM, Todd Fabacher via use-livecode > wrote: > > Hello All, > > We need to interface between LiveCode and Amazon CloudFront. We are awa

Producing a list of duplicates

Anybody have a good method for searching a list of items for duplicates and listing those duplicates in a variable? I have a bunch of data records that contain email addresses. I need to search through that list and produce an list so those duplicates can be acted upon. As always, your input is g

Re: [ANN] tinyDictionary

Great job! Downloaded and already using it. SKIP On Wed, Mar 22, 2017 at 11:05 AM, Roger Guay via use-livecode < use-livecode@lists.runrev.com> wrote: > I love it! Thanks!! > > Roger > > > On Mar 22, 2017, at 7:37 AM, BNig via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > > I upl

Re: Producing a list of duplicates

for posting it :) > > On Wed, Mar 22, 2017 at 12:25 PM, Dr. Hawkins via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > On Wed, Mar 22, 2017 at 4:41 AM, Skip Kimpel via use-livecode < > > use-livecode@lists.runrev.com> wrote: > > > > > I

Re: [ANN] Introducing Remote DB Lib

Excited to try this out! SKIP On Tue, Jun 6, 2017 at 4:16 PM, Andre Garzia via use-livecode < use-livecode@lists.runrev.com> wrote: > DB Lib (andregarzia/projects/dblib) is a minimalistic database library for > LiveCode that works on Desktop and Mobile and allows you to build > database-savvy ap

Re: LC Global - my experience

an open bar SKIP > On Jun 17, 2017, at 8:42 AM, pink via use-livecode > wrote: > > While it is fun to hang out with other Livecoders, and to go out carousing > with the staff, it is definitely nice to be able to watch remotely. We can > still interact with each other, we can still ask

Re: OT: Hackintosh

I have built one and submitted apps with no problems. A pain to install but it is a possibility. Another option is MacInCloud (https://www.macincloud.com) I have used them before as well and then map a DropBox folder to my PC so I can transfer files back forth effortlessly. SKIP On Tue, Aug 1,

Re: Hackintosh

By the way, I would go the route of a VM version of a hackitosh, not a hardware, build from scratch concept. SKIP On Tue, Aug 1, 2017 at 4:03 PM, Erik Beugelaar via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi Dan, > > I have built 6 years ago a Hackintosh computer based on a (nowad