Re: MP3 ID3 tag writer

2020-11-24 Thread Skip Kimpel via use-livecode
Also found this by Paul McClernan:
https://github.com/PaulMcClernan/id3lib

SKIP

On Tue, Nov 24, 2020 at 12:39 PM Skip Kimpel  wrote:

> Looking at that zip file, I don't see the library attached.  Also, does
> anybody have an idea if what ID3 version this is compatible with?
>
> SKIP
>
> On Tue, Nov 24, 2020 at 12:37 PM Skip Kimpel  wrote:
>
>> Thank you!
>>
>> SKIP
>>
>> On Tue, Nov 24, 2020 at 11:09 AM matthias rebbe via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>>> I just noticed, that the files are not available anymore.
>>>
>>> I've uploaded a zip archive of those files here
>>>
>>> https://dl.qck.nu/?dl=MarkSmith.zip
>>>
>>>
>>> -
>>> Matthias Rebbe
>>> Life Is Too Short For Boring Code
>>>
>>> > Am 24.11.2020 um 16:59 schrieb matthias rebbe via use-livecode <
>>> use-livecode@lists.runrev.com>:
>>> >
>>> > The late Mark Smith (the Bass Player) had written a library.
>>> >
>>> > 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.11.2020 um 16:36 schrieb Skip Kimpel via use-livecode <
>>> use-livecode@lists.runrev.com>:
>>> >>
>>> >> 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 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
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: MP3 ID3 tag writer

2020-11-24 Thread Skip Kimpel via use-livecode
Looking at that zip file, I don't see the library attached.  Also, does
anybody have an idea if what ID3 version this is compatible with?

SKIP

On Tue, Nov 24, 2020 at 12:37 PM Skip Kimpel  wrote:

> Thank you!
>
> SKIP
>
> On Tue, Nov 24, 2020 at 11:09 AM matthias rebbe via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> I just noticed, that the files are not available anymore.
>>
>> I've uploaded a zip archive of those files here
>>
>> https://dl.qck.nu/?dl=MarkSmith.zip
>>
>>
>> -
>> Matthias Rebbe
>> Life Is Too Short For Boring Code
>>
>> > Am 24.11.2020 um 16:59 schrieb matthias rebbe via use-livecode <
>> use-livecode@lists.runrev.com>:
>> >
>> > The late Mark Smith (the Bass Player) had written a library.
>> >
>> > 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.11.2020 um 16:36 schrieb Skip Kimpel via use-livecode <
>> use-livecode@lists.runrev.com>:
>> >>
>> >> 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 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
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: MP3 ID3 tag writer

2020-11-24 Thread Skip Kimpel via use-livecode
Thank you!

SKIP

On Tue, Nov 24, 2020 at 11:09 AM matthias rebbe via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I just noticed, that the files are not available anymore.
>
> I've uploaded a zip archive of those files here
>
> https://dl.qck.nu/?dl=MarkSmith.zip
>
>
> -
> Matthias Rebbe
> Life Is Too Short For Boring Code
>
> > Am 24.11.2020 um 16:59 schrieb matthias rebbe via use-livecode <
> use-livecode@lists.runrev.com>:
> >
> > The late Mark Smith (the Bass Player) had written a library.
> >
> > 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.11.2020 um 16:36 schrieb Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com>:
> >>
> >> 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 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
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


MP3 ID3 tag writer

2020-11-24 Thread Skip Kimpel via use-livecode
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 your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Best relational database for IOS / Android

2020-04-29 Thread Skip Kimpel via use-livecode
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 that would be the best move at this
point.

Suggestions?

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: Counting unique items in a file

2020-04-27 Thread Skip Kimpel via use-livecode
All of that works perfectly.  Thank you everybody!

Let's through a layer of complexity in here... each of of those names has
another column with a time associated with it, for instance "13:02:58"
 I would like to only show the LATEST time associated with that particular
name.

Premise behind this whole exercise:  I have a list of drivers and I want to
produce a report that shows the driver name, number of jobs (both of these
accomplished through the last script) and when they finished their last
delivery.

Should I just break this out into a separate function or would it make
sense to modify this function to fit these additional needs?

SKIP

On Mon, Apr 27, 2020 at 3:05 PM Skip Kimpel  wrote:

> Silly me... of course.  Thank you, Dunbarx for pointing out the obvious :)
>
> SKIP
>
> On Mon, Apr 27, 2020 at 2:27 PM dunbarx--- via use-livecode <
> 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
>>
>>
>> -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, 2020 1:52 pm
>> Subject: Re: Counting unique items in a file
>>
>> Thanks Dan!
>>
>> Upon very quick implementation, I am getting empty results back.  I think
>> I
>> need to play around with this a little bit more but I feel you got me on
>> the right track.
>>
>> Thanks again,
>>
>> SKIP
>>
>> On Mon, Apr 27, 2020 at 1:34 PM Dan Friedman 
>> wrote:
>>
>> > Skip,
>> >
>> > Haven't tested, but pope about this...
>> >
>> > function getUniqueNames inData,pColumn
>> >  put "" into uNames
>> >  set the itemDel to tab
>> >  repeat for each line l in inData
>> >    add 1 to uNames[item pColumn of l]
>> >  end repeat
>> >
>> >  return uNames
>> > end getUniqueNames
>> >
>> > 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 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 this it get wyyy too long :)
>> >
>> >Simple approach?
>> >
>> >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
>> >
>> >
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Counting unique items in a file

2020-04-27 Thread Skip Kimpel via use-livecode
Silly me... of course.  Thank you, Dunbarx for pointing out the obvious :)

SKIP

On Mon, Apr 27, 2020 at 2:27 PM dunbarx--- via use-livecode <
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
>
>
> -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, 2020 1:52 pm
> Subject: Re: Counting unique items in a file
>
> Thanks Dan!
>
> Upon very quick implementation, I am getting empty results back.  I think I
> need to play around with this a little bit more but I feel you got me on
> the right track.
>
> Thanks again,
>
> SKIP
>
> On Mon, Apr 27, 2020 at 1:34 PM Dan Friedman 
> wrote:
>
> > Skip,
> >
> > Haven't tested, but pope about this...
> >
> > function getUniqueNames inData,pColumn
> >  put "" into uNames
> >  set the itemDel to tab
> >  repeat for each line l in inData
> >add 1 to uNames[item pColumn of l]
> >  end repeat
> >
> >  return uNames
> > end getUniqueNames
> >
> > 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 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 this it get wyyy too long :)
> >
> >Simple approach?
> >
> >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
> >
> >
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Counting unique items in a file

2020-04-27 Thread Skip Kimpel via use-livecode
Thanks Dan!

Upon very quick implementation, I am getting empty results back.  I think I
need to play around with this a little bit more but I feel you got me on
the right track.

Thanks again,

SKIP

On Mon, Apr 27, 2020 at 1:34 PM Dan Friedman 
wrote:

> Skip,
>
> Haven't tested, but pope about this...
>
> function getUniqueNames inData,pColumn
>   put "" into uNames
>   set the itemDel to tab
>   repeat for each line l in inData
> add 1 to uNames[item pColumn of l]
>   end repeat
>
>   return uNames
> end getUniqueNames
>
> 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 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 this it get wyyy too long :)
>
> Simple approach?
>
> 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
>
>
___
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


Counting unique items in a file

2020-04-27 Thread Skip Kimpel via use-livecode
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 this it get wyyy too long :)

Simple approach?

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: Even Distribution

2020-04-17 Thread Skip Kimpel via use-livecode
Awesome. thank you!

On Fri, Apr 17, 2020 at 1:15 PM Alex Tweedly via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Or to do the full distribution ...
>
> put Njobs div Ndrivers into tMin
> put NJobs mod Ndrivers into tExtras
>
> repeat with i = 1 to NDrivers
> if i <= tExtras then
>allocate tMin+1
>else
>   allocate tMin
>end if
> end repeat
>
> However, say your drivers are sorted alphabetically, then before long
> Andy will realise that he is being allocated more jobs that Zebedee. You
> could (sometimes) reverse the order of drivers - but then Mary loses out
> on jobs compared to both Andy and Zebedee. Or you could randomize the
> order of the drivers - but maybe they're also pre-sorted by location.
>
> Instead, you want to even out the spread of extras across the drivers -
> so you need something like
>
> repeat with i = 1 to Ndrivers
> if tExtras > (Ndrivers-i)/2 then
>allocate tMin+1
>subtract 1 from tExtras
>else
>   allocate tMin
>end if
> end repeat
>
> (which still has a slight bias towards giving jobs to Zebedee - but it's
> so slight it will take probably take him years to notice :-)
>
> Alex.
>
> On 17/04/2020 05:28, Jerry Jensen via use-livecode wrote:
> >   Hi Skip,
> > Forgive me if this is not the answer you seek, 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 <
> use-livecode@lists.runrev.com> wrote:
> >>
> >> I have working on creating a loop that would divide the number of jobs
> by
> >> the number of users and then checking to see to see if it is evenly
> >> divisible but that is kind of where I am stuck.  Everything I have tried
> >> thus far has proven to be unsuccessful.
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Even Distribution

2020-04-17 Thread Skip Kimpel via use-livecode
Jerry,

You did not over simplify at all!  I used your basic concept and tweaked it
and then applied it to my nested repeats and BAM... got it.

Thanks again, everybody!

SKIP

On Fri, Apr 17, 2020 at 12:28 AM Jerry Jensen  wrote:

>  Hi Skip,
> Forgive me if this is not the answer you seek, 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 <
> use-livecode@lists.runrev.com> wrote:
> >
> > I have working on creating a loop that would divide the number of jobs by
> > the number of users and then checking to see to see if it is evenly
> > divisible but that is kind of where I am stuck.  Everything I have tried
> > thus far has proven to be unsuccessful.
>
>
___
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: Even Distribution

2020-04-16 Thread Skip Kimpel via use-livecode
I have working on creating a loop that would divide the number of jobs by
the number of users and then checking to see to see if it is evenly
divisible but that is kind of where I am stuck.  Everything I have tried
thus far has proven to be unsuccessful.

SKIP

On Thu, Apr 16, 2020 at 10:36 PM Skip Kimpel  wrote:

> Dev, I have already sorted the jobs out by proximity so I don't need to
> worry about that.  Just need the distribution piece down.  I agree, you
> have a good point an might prove valuable in the future.
>
> SKIP
>
> On Thu, Apr 16, 2020 at 10:33 PM Skip Kimpel  wrote:
>
>> Haha... Let me specify, I am looking to do this programmatically :)
>>
>> SKIP
>>
>> On Thu, Apr 16, 2020 at 10:31 PM Dev via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>>> Since you would probably 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.runrev.com> wrote:
>>> >
>>> > 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 the night thus far :)
>>> >
>>> > 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
>>> >
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Even Distribution

2020-04-16 Thread Skip Kimpel via use-livecode
Dev, I have already sorted the jobs out by proximity so I don't need to
worry about that.  Just need the distribution piece down.  I agree, you
have a good point an might prove valuable in the future.

SKIP

On Thu, Apr 16, 2020 at 10:33 PM Skip Kimpel  wrote:

> Haha... Let me specify, I am looking to do this programmatically :)
>
> SKIP
>
> On Thu, Apr 16, 2020 at 10:31 PM Dev via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> Since you would probably 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.runrev.com> wrote:
>> >
>> > 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 the night thus far :)
>> >
>> > 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
>> >
>>
>>
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Even Distribution

2020-04-16 Thread Skip Kimpel via use-livecode
Haha... Let me specify, I am looking to do this programmatically :)

SKIP

On Thu, Apr 16, 2020 at 10:31 PM Dev via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Since you would probably 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.runrev.com> wrote:
> >
> > 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 the night thus far :)
> >
> > 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
> >
>
>
> ___
> 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


Even Distribution

2020-04-16 Thread Skip Kimpel via use-livecode
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 the night thus far :)

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: Livecode and AWS Sql

2020-04-12 Thread Skip Kimpel via use-livecode
Matthias,

By the way, Actualtech´s ODBC drivers work perfectly. thank you for the
recommendation!

SKIP

On Sun, Apr 12, 2020 at 4:56 AM matthias rebbe via use-livecode <
use-livecode@lists.runrev.com> wrote:

>
>
> Skip,
>
> As i wrote in my previous post
> i am using Actualtech´s ODBC drivers. They are not free, but what i think
> they are cheap. They cost 39,- USD.
> https://www.actualtech.com/product_sqlserver.php
> There´s also a trial version available.
>
>
> There are also free ODBC drivers for MSSQL for Mac from Microsoft, but i
> 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
>
>
>
>
> > Am 12.04.2020 um 01:15 schrieb Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com>:
> >
> > I downloaded the ODBC Administrator for Mac but when I click to add a
> > connection, it has a blank drivers box.  Like you said, Bob, you need to
> > load the SQL drivers.  Where can I download these drivers from?   I
> > originally started down this path with not a ton of luck.
> >
> > Thank you,
> >
> > SKIP
> >
> > On Sat, Apr 11, 2020 at 7:12 PM Bob Sneidar via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> Same as on Windows, but the difference is that Microsoft has built in
> >> drivers for SQL Server, mySQL and some other things. The Mac does not.
> You
> >> have to download the ODBC Administrator (need the 64 bit version you
> know)
> >> and the drivers.
> >>
> >> This is why I created my Socket based Client Server apps. I will have
> the
> >> server reside on a Windows computer where 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.
> >>
> >> Bob S
> >>
> >>
> >>> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode <
> >> use-livecode@lists.runrev.com> wrote:
> >>>
> >>> Thank you Matthias,
> >>>
> >>> So how would you connect to a remote SQL database on a Mac?
> >>>
> >>> 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
> >>
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-12 Thread Skip Kimpel via use-livecode
I first started with the Microsoft driver options but had zero luck... this
was a very frustrating part of my learning curve with this project.

SKIP

On Sun, Apr 12, 2020 at 4:56 AM matthias rebbe via use-livecode <
use-livecode@lists.runrev.com> wrote:

>
>
> Skip,
>
> As i wrote in my previous post
> i am using Actualtech´s ODBC drivers. They are not free, but what i think
> they are cheap. They cost 39,- USD.
> https://www.actualtech.com/product_sqlserver.php
> There´s also a trial version available.
>
>
> There are also free ODBC drivers for MSSQL for Mac from Microsoft, but i
> 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
>
>
>
>
> > Am 12.04.2020 um 01:15 schrieb Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com>:
> >
> > I downloaded the ODBC Administrator for Mac but when I click to add a
> > connection, it has a blank drivers box.  Like you said, Bob, you need to
> > load the SQL drivers.  Where can I download these drivers from?   I
> > originally started down this path with not a ton of luck.
> >
> > Thank you,
> >
> > SKIP
> >
> > On Sat, Apr 11, 2020 at 7:12 PM Bob Sneidar via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> Same as on Windows, but the difference is that Microsoft has built in
> >> drivers for SQL Server, mySQL and some other things. The Mac does not.
> You
> >> have to download the ODBC Administrator (need the 64 bit version you
> know)
> >> and the drivers.
> >>
> >> This is why I created my Socket based Client Server apps. I will have
> the
> >> server reside on a Windows computer where 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.
> >>
> >> Bob S
> >>
> >>
> >>> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode <
> >> use-livecode@lists.runrev.com> wrote:
> >>>
> >>> Thank you Matthias,
> >>>
> >>> So how would you connect to a remote SQL database on a Mac?
> >>>
> >>> 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
> >>
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-12 Thread Skip Kimpel via use-livecode
Thank you everybody!  You have been a great help.

SKIP

On Sun, Apr 12, 2020 at 10:25 AM Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> This next week I will probably get my client-server thingummy going to
> where you can securely pass queries and return data, but I only use sqlYoga
> when I can help it, so you might have to modify it for your own purposes.
>
> Bob S
>
>
> > On Apr 12, 2020, at 2:09 AM, matthias rebbe via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> >> Am 12.04.2020 um 01:11 schrieb Bob Sneidar via use-livecode <
> use-livecode@lists.runrev.com>:
> >>
> >> Same as on Windows, but the difference is that Microsoft has built in
> drivers for SQL Server, mySQL and some other things.
> > Yes, MS Windows has included a SQL Server ODBC driver. But, if i
> remember correct, then you need more current ones if you want  to use
> special features of the news SQL Server versions.
> > We are still using the builtin ones, as our SQL Servers still are run in
> 2005 compatibility mode. I am not sure this is the correct expression, but
> i am sure you know what i mean.
> >
> >
> > It´s a pity that LC does not have built-in MSSQL drivers which allow to
> directly communicate with the MSSQL Server without the need of ODBC. It
> would make so much things easier.
> >
> >
> >
> >> The Mac does not. You have to download the ODBC Administrator (need the
> 64 bit version you know) and the drivers.
> >>
> >
> >
> >
> >> This is why I created my Socket based Client Server apps. I will have
> the server reside on a Windows computer where 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.
> >>
> >> Bob S
> >>
> >>
> >>> On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >>>
> >>> Thank you Matthias,
> >>>
> >>> So how would you connect to a remote SQL database on a Mac?
> >>>
> >>> 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
> >
> >
> >
> > -
> > Matthias Rebbe
> > Life Is Too Short For Boring Code
> >
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-11 Thread Skip Kimpel via use-livecode
I downloaded the ODBC Administrator for Mac but when I click to add a
connection, it has a blank drivers box.  Like you said, Bob, you need to
load the SQL drivers.  Where can I download these drivers from?   I
originally started down this path with not a ton of luck.

Thank you,

SKIP

On Sat, Apr 11, 2020 at 7:12 PM Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Same as on Windows, but the difference is that Microsoft has built in
> drivers for SQL Server, mySQL and some other things. The Mac does not. You
> have to download the ODBC Administrator (need the 64 bit version you know)
> and the drivers.
>
> This is why I created my Socket based Client Server apps. I will have the
> server reside on a Windows computer where 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.
>
> Bob S
>
>
> > On Apr 11, 2020, at 3:46 PM, Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > Thank you Matthias,
> >
> > So how would you connect to a remote SQL database on a Mac?
> >
> > 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
>
___
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: Livecode and AWS Sql

2020-04-11 Thread Skip Kimpel via use-livecode
Thank you Matthias,

So how would you connect to a remote SQL database on a Mac?

SKIP

On Sat, Apr 11, 2020 at 6:17 PM matthias rebbe via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Just an information about using ODBC connection strings in LC on Mac.
>
> Since LC version 7  it is not possible anymore to use odbc connection
> strings in LC on Mac OS.
> On Windows this is not a problem.
>
> see bug report  https://quality.livecode.com/show_bug.cgi?id=18151 from
> 2016.
>
>
> -
> Matthias Rebbe
> Life Is Too Short For Boring Code
>
> > Am 11.04.2020 um 23:46 schrieb Bob Sneidar via use-livecode <
> use-livecode@lists.runrev.com>:
> >
> > Hi all. I went through something similar of late. One thing to keep in
> mind, the ODBC driver can connect to a SQL server on another device, but
> your app that 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:
> >>
> >> 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 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;SERVER="&";DATABASE="&";UID="&";PWD="&"")
> >>> into gConnID*
> >>>
> >>>
> >>> 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
> >
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-11 Thread Skip Kimpel via use-livecode
gt;>
>>
>>
>> SKIP
>>
>>
>>
>> On Fri, Apr 10, 2020 at 10:53 AM Ralph DiMola via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>> From what I can see you will either need to install Xcode 11.4 or use a
>> previous version of the ODBC SW. But I’m starting to get out of my comfort
>> zone now. I do some Mac dev but I’m mainly a Windows developer.
>>
>>
>>
>> Ralph DiMola
>>
>> IT Director
>>
>> Evergreen Information Services
>>
>> rdim...@evergreeninfo.net
>>
>>
>>
>> From: Skip Kimpel [mailto:skiplon...@gmail.com]
>> Sent: Friday, April 10, 2020 10:35 AM
>> To: How to use LiveCode
>> Cc: Ralph DiMola
>> Subject: Re: Livecode and AWS Sql
>>
>>
>>
>> Unfortunately, I don't think it is that straight forward.  I went down
>> this path already.  The files that you can download are Windows MSI
>> installation files.  You can run it manually by using the following
>> commands:
>>
>>
>>
>> /usr/bin/ruby -e "$(curl -fsSL
>> https://raw.githubusercontent.com/Homebrew/install/master/install)"
>>
>> brew tap microsoft/mssql-release
>> https://github.com/Microsoft/homebrew-mssql-release
>>
>> brew update
>>
>> HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17
>> mssql-tools
>>
>>
>>
>> However, when I run the last command, I get:
>>
>> Error: Your Xcode (10.1) is too outdated.
>>
>> Please update to Xcode 11.4 (or delete it).
>>
>> Xcode can be updated from the App Store.
>>
>>
>>
>> Do I really need Xcode in order to install SQL?  I also thought I read
>> that 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-livecode@lists.runrev.com> wrote:
>>
>> https://www.microsoft.com/en-us/download/details.aspx?id=56567
>>
>>
>>
>> Ralph DiMola
>>
>> IT Director
>>
>> Evergreen Information Services
>>
>> rdim...@evergreeninfo.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 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?
>>
>> 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 DiMola via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>> Firewall port?
>>
>> Ralph DiMola
>> IT Director
>> Evergreen Information Services
>>
>> -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: 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;SERVER="&";DATABASE="&";UID="&";PW
>> D="&"")
>> into gConnID*
>>
>>
>> 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
>>
>>
>> ___
>> 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
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
e <
> use-livecode@lists.runrev.com> wrote:
>
> https://www.microsoft.com/en-us/download/details.aspx?id=56567
>
>
>
> Ralph DiMola
>
> IT Director
>
> Evergreen Information Services
>
> rdim...@evergreeninfo.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 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?
>
> 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 DiMola via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> Firewall port?
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
>
> -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: 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;SERVER="&";DATABASE="&";UID="&";PW
> D="&"")
> into gConnID*
>
>
> 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
>
>
> ___
> 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
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
Interestingly enough, I brought over everything to the Windows side to test
there and I STILL cannot connect!  This might go back to an AWS question OR
remote SQL question.  Ralph, do you normally connect to SQL via your local
machine/local network or do connect to remote SQL servers.  Going back in
my internal memory banks, I don't know if I have ever connected to a
remote, cloud based SQL server before.

SKIP

On Fri, Apr 10, 2020 at 1:31 PM Skip Kimpel  wrote:

> Good to know.
>
>
> SKIP
>
> On Fri, Apr 10, 2020 at 1:30 PM Ralph DiMola via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> You can have multiple versions of Xcode installed. For instance you can
>> have 10.1 and 11.4 installed. Point LC to 11.1. I have all of my Xcode
>> versions in a desktop folder and have none in applications. You just have
>> to make sure the proper version is active  for building.
>>
>>
>>
>> Display current version è xcode-select -print-path
>>
>> Change version è sudo xcode-select -switch Xcode.app
>>
>>
>>
>> Ralph DiMola
>>
>> IT Director
>>
>> Evergreen Information Services
>>
>> rdim...@evergreeninfo.net
>>
>>
>>
>> From: Skip Kimpel [mailto:skiplon...@gmail.com]
>> Sent: Friday, April 10, 2020 1:08 PM
>> To: How to use LiveCode
>> Cc: Ralph DiMola
>> Subject: Re: Livecode and AWS Sql
>>
>>
>>
>> Just a as follow up, I installed that Xcode 11.4, ran the previous script
>> and it looks like it installed properly. HOWEVER, I still cannot connect to
>> my SQL database.  Also, by doing that, my Mac mobile development
>> environment disappeared.  I have since uninstalled 11.4 and went back to
>> 10.1.
>>
>>
>>
>> Beyond frustrating... I must be getting old ;
>>
>>
>>
>> SKIP
>>
>>
>>
>> On Fri, Apr 10, 2020 at 10:56 AM Skip Kimpel 
>> wrote:
>>
>> I do appreciate your help, Ralph.  You and I are in the same boat in
>> regards to their comfort level having primarily worked in a Windows
>> environment in the past.
>>
>>
>>
>> SKIP
>>
>>
>>
>> On Fri, Apr 10, 2020 at 10:53 AM Ralph DiMola via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>> From what I can see you will either need to install Xcode 11.4 or use a
>> previous version of the ODBC SW. But I’m starting to get out of my comfort
>> zone now. I do some Mac dev but I’m mainly a Windows developer.
>>
>>
>>
>> Ralph DiMola
>>
>> IT Director
>>
>> Evergreen Information Services
>>
>> rdim...@evergreeninfo.net
>>
>>
>>
>> From: Skip Kimpel [mailto:skiplon...@gmail.com]
>> Sent: Friday, April 10, 2020 10:35 AM
>> To: How to use LiveCode
>> Cc: Ralph DiMola
>> Subject: Re: Livecode and AWS Sql
>>
>>
>>
>> Unfortunately, I don't think it is that straight forward.  I went down
>> this path already.  The files that you can download are Windows MSI
>> installation files.  You can run it manually by using the following
>> commands:
>>
>>
>>
>> /usr/bin/ruby -e "$(curl -fsSL
>> https://raw.githubusercontent.com/Homebrew/install/master/install)"
>>
>> brew tap microsoft/mssql-release
>> https://github.com/Microsoft/homebrew-mssql-release
>>
>> brew update
>>
>> HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17
>> mssql-tools
>>
>>
>>
>> However, when I run the last command, I get:
>>
>> Error: Your Xcode (10.1) is too outdated.
>>
>> Please update to Xcode 11.4 (or delete it).
>>
>> Xcode can be updated from the App Store.
>>
>>
>>
>> Do I really need Xcode in order to install SQL?  I also thought I read
>> that 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-livecode@lists.runrev.com> wrote:
>>
>> https://www.microsoft.com/en-us/download/details.aspx?id=56567
>>
>>
>>
>> Ralph DiMola
>>
>> IT Director
>>
>> Evergreen Information Services
>>
>> rdim...@evergreeninfo.net
>>
>> Phone: 518-636-3998 Ex:11
>>
>> Cell: 518-796-9332
>>
>>
>>
>> From: Skip Kimpel [mailto:skiplon...@gmail.com]
>> Sent: Friday, April 10, 2020

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
Good to know.


SKIP

On Fri, Apr 10, 2020 at 1:30 PM Ralph DiMola via use-livecode <
use-livecode@lists.runrev.com> wrote:

> You can have multiple versions of Xcode installed. For instance you can
> have 10.1 and 11.4 installed. Point LC to 11.1. I have all of my Xcode
> versions in a desktop folder and have none in applications. You just have
> to make sure the proper version is active  for building.
>
>
>
> Display current version è xcode-select -print-path
>
> Change version è sudo xcode-select -switch Xcode.app
>
>
>
> Ralph DiMola
>
> IT Director
>
> Evergreen Information Services
>
> rdim...@evergreeninfo.net
>
>
>
> From: Skip Kimpel [mailto:skiplon...@gmail.com]
> Sent: Friday, April 10, 2020 1:08 PM
> To: How to use LiveCode
> Cc: Ralph DiMola
> Subject: Re: Livecode and AWS Sql
>
>
>
> Just a as follow up, I installed that Xcode 11.4, ran the previous script
> and it looks like it installed properly. HOWEVER, I still cannot connect to
> my SQL database.  Also, by doing that, my Mac mobile development
> environment disappeared.  I have since uninstalled 11.4 and went back to
> 10.1.
>
>
>
> Beyond frustrating... I must be getting old ;
>
>
>
> SKIP
>
>
>
> On Fri, Apr 10, 2020 at 10:56 AM Skip Kimpel  wrote:
>
> I do appreciate your help, Ralph.  You and I are in the same boat in
> regards to their comfort level having primarily worked in a Windows
> environment in the past.
>
>
>
> SKIP
>
>
>
> On Fri, Apr 10, 2020 at 10:53 AM Ralph DiMola via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> From what I can see you will either need to install Xcode 11.4 or use a
> previous version of the ODBC SW. But I’m starting to get out of my comfort
> zone now. I do some Mac dev but I’m mainly a Windows developer.
>
>
>
> Ralph DiMola
>
> IT Director
>
> Evergreen Information Services
>
> rdim...@evergreeninfo.net
>
>
>
> From: Skip Kimpel [mailto:skiplon...@gmail.com]
> Sent: Friday, April 10, 2020 10:35 AM
> To: How to use LiveCode
> Cc: Ralph DiMola
> Subject: Re: Livecode and AWS Sql
>
>
>
> Unfortunately, I don't think it is that straight forward.  I went down
> this path already.  The files that you can download are Windows MSI
> installation files.  You can run it manually by using the following
> commands:
>
>
>
> /usr/bin/ruby -e "$(curl -fsSL
> https://raw.githubusercontent.com/Homebrew/install/master/install)"
>
> brew tap microsoft/mssql-release
> https://github.com/Microsoft/homebrew-mssql-release
>
> brew update
>
> HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17
> mssql-tools
>
>
>
> However, when I run the last command, I get:
>
> Error: Your Xcode (10.1) is too outdated.
>
> Please update to Xcode 11.4 (or delete it).
>
> Xcode can be updated from the App Store.
>
>
>
> Do I really need Xcode in order to install SQL?  I also thought I read
> that 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-livecode@lists.runrev.com> wrote:
>
> https://www.microsoft.com/en-us/download/details.aspx?id=56567
>
>
>
> Ralph DiMola
>
> IT Director
>
> Evergreen Information Services
>
> rdim...@evergreeninfo.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 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?
>
> 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 DiMola via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> Firewall port?
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
>
> -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: Livecode and AWS Sql
>
> Any trick to connecting 

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
Just a as follow up, I installed that Xcode 11.4, ran the previous script
and it looks like it installed properly. HOWEVER, I still cannot connect to
my SQL database.  Also, by doing that, my Mac mobile
development environment disappeared.  I have since uninstalled 11.4 and
went back to 10.1.

Beyond frustrating... I must be getting old ;

SKIP

On Fri, Apr 10, 2020 at 10:56 AM Skip Kimpel  wrote:

> I do appreciate your help, Ralph.  You and I are in the same boat in
> regards to their comfort level having primarily worked in a Windows
> environment in the past.
>
> SKIP
>
> On Fri, Apr 10, 2020 at 10:53 AM Ralph DiMola via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> From what I can see you will either need to install Xcode 11.4 or use a
>> previous version of the ODBC SW. But I’m starting to get out of my comfort
>> zone now. I do some Mac dev but I’m mainly a Windows developer.
>>
>>
>>
>> Ralph DiMola
>>
>> IT Director
>>
>> Evergreen Information Services
>>
>> rdim...@evergreeninfo.net
>>
>>
>>
>> From: Skip Kimpel [mailto:skiplon...@gmail.com]
>> Sent: Friday, April 10, 2020 10:35 AM
>> To: How to use LiveCode
>> Cc: Ralph DiMola
>> Subject: Re: Livecode and AWS Sql
>>
>>
>>
>> Unfortunately, I don't think it is that straight forward.  I went down
>> this path already.  The files that you can download are Windows MSI
>> installation files.  You can run it manually by using the following
>> commands:
>>
>>
>>
>> /usr/bin/ruby -e "$(curl -fsSL
>> https://raw.githubusercontent.com/Homebrew/install/master/install)"
>>
>> brew tap microsoft/mssql-release
>> https://github.com/Microsoft/homebrew-mssql-release
>>
>> brew update
>>
>> HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17
>> mssql-tools
>>
>>
>>
>> However, when I run the last command, I get:
>>
>> Error: Your Xcode (10.1) is too outdated.
>>
>> Please update to Xcode 11.4 (or delete it).
>>
>> Xcode can be updated from the App Store.
>>
>>
>>
>> Do I really need Xcode in order to install SQL?  I also thought I read
>> that 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-livecode@lists.runrev.com> wrote:
>>
>> https://www.microsoft.com/en-us/download/details.aspx?id=56567
>>
>>
>>
>> Ralph DiMola
>>
>> IT Director
>>
>> Evergreen Information Services
>>
>> rdim...@evergreeninfo.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 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?
>>
>> 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 DiMola via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>> Firewall port?
>>
>> Ralph DiMola
>> IT Director
>> Evergreen Information Services
>>
>> -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: 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;SERVER="&";DATABASE="&";UID="&";PW
>> D="&"")
>> into gConnID*
>>
>>
>> SKIP
>> __

Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
I do appreciate your help, Ralph.  You and I are in the same boat in
regards to their comfort level having primarily worked in a Windows
environment in the past.

SKIP

On Fri, Apr 10, 2020 at 10:53 AM Ralph DiMola via use-livecode <
use-livecode@lists.runrev.com> wrote:

> From what I can see you will either need to install Xcode 11.4 or use a
> previous version of the ODBC SW. But I’m starting to get out of my comfort
> zone now. I do some Mac dev but I’m mainly a Windows developer.
>
>
>
> Ralph DiMola
>
> IT Director
>
> Evergreen Information Services
>
> rdim...@evergreeninfo.net
>
>
>
> From: Skip Kimpel [mailto:skiplon...@gmail.com]
> Sent: Friday, April 10, 2020 10:35 AM
> To: How to use LiveCode
> Cc: Ralph DiMola
> Subject: Re: Livecode and AWS Sql
>
>
>
> Unfortunately, I don't think it is that straight forward.  I went down
> this path already.  The files that you can download are Windows MSI
> installation files.  You can run it manually by using the following
> commands:
>
>
>
> /usr/bin/ruby -e "$(curl -fsSL
> https://raw.githubusercontent.com/Homebrew/install/master/install)"
>
> brew tap microsoft/mssql-release
> https://github.com/Microsoft/homebrew-mssql-release
>
> brew update
>
> HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17
> mssql-tools
>
>
>
> However, when I run the last command, I get:
>
> Error: Your Xcode (10.1) is too outdated.
>
> Please update to Xcode 11.4 (or delete it).
>
> Xcode can be updated from the App Store.
>
>
>
> Do I really need Xcode in order to install SQL?  I also thought I read
> that 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-livecode@lists.runrev.com> wrote:
>
> https://www.microsoft.com/en-us/download/details.aspx?id=56567
>
>
>
> Ralph DiMola
>
> IT Director
>
> Evergreen Information Services
>
> rdim...@evergreeninfo.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 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?
>
> 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 DiMola via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> Firewall port?
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
>
> -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: 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;SERVER="&";DATABASE="&";UID="&";PW
> D="&"")
> into gConnID*
>
>
> 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
>
>
> ___
> 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
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
Unfortunately, I don't think it is that straight forward.  I went down this
path already.  The files that you can download are Windows MSI
installation files.  You can run it manually by using the following
commands:

/usr/bin/ruby -e "$(curl -fsSL
https://raw.githubusercontent.com/Homebrew/install/master/install)" brew
tap microsoft/mssql-release
https://github.com/Microsoft/homebrew-mssql-release brew update
HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17
mssql-tools

However, when I run the last command, I get:

Error: Your Xcode (10.1) is too outdated.

Please update to Xcode 11.4 (or delete it).

Xcode can be updated from the App Store.


Do I really need Xcode in order to install SQL?  I also thought I read that
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-livecode@lists.runrev.com> wrote:

> https://www.microsoft.com/en-us/download/details.aspx?id=56567
>
>
>
> Ralph DiMola
>
> IT Director
>
> Evergreen Information Services
>
> rdim...@evergreeninfo.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 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?
>
> 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 DiMola via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> Firewall port?
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
>
> -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: 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;SERVER="&";DATABASE="&";UID="&";PW
> D="&"")
> into gConnID*
>
>
> 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
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
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?

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 DiMola via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> Firewall port?
>>
>> Ralph DiMola
>> IT Director
>> Evergreen Information Services
>>
>> -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: 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;SERVER="&";DATABASE="&";UID="&";PW
>> D="&"")
>> into gConnID*
>>
>>
>> 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
>>
>>
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
Nope... 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 Services
>
> -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: 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;SERVER="&";DATABASE="&";UID="&";PW
> D="&"")
> into gConnID*
>
>
> 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
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Livecode and AWS Sql

2020-04-10 Thread Skip Kimpel via use-livecode
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 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;SERVER="&";DATABASE="&";UID="&";PWD="&"")
> into gConnID*
>
>
> 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


Livecode and AWS Sql

2020-04-09 Thread Skip Kimpel via use-livecode
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;SERVER="&";DATABASE="&";UID="&";PWD="&"")
into gConnID*


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: Problems locating Android SDK

2020-04-06 Thread Skip Kimpel via use-livecode
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.runrev.com> wrote:

> You may have read the path where tools are as being where you need to
> point LiveCode to. Point LiveCode to ~/Library/Android/SDK, and not
> ~/Library/Android/SDK/Tools
>
>
> > On Apr 6, 2020, at 11:32 AM, Richard Gaskin via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > Colin Holgate wrote:
> >
> > > On Apr 6, 2020, at 10:14 AM, Richard Gaskin wrote:
> > >>
> > >> I'm setting up a new machine for Android development.
> > >>
> > >> Where is the one-page list of steps on the livecode.com site that
> > >> reliably guides a new user through this for all supported platforms
> > >> (Mac, Win, Linux)?
> > >>
> > >> This one fails:
> > >>
> http://lessons.livecode.com/m/2571/l/625198-livecode-and-android-studio
> > >
> > > That link does work, and helps to solve the problem. The current
> > > Android Studio comes with Android 10 installed, and LiveCode needs
> > > Android 9.
> >
> > The link itself works, in that it goes to a page. :)
> >
> > But I have followed its instructions to install Android 9, and pointed
> my LC prefs to the folder shown in the screen shot, and LC reports:
> >
> >  The chosen folder is not a valid Android SDK. Please
> >  ensure that you have installed it correctly, and enabled
> >  support for 9.0 (API 28)
> >
> >
> > When I run Android Studio it all seems to work.  But LC says it doesn't.
> >
> > What did I miss?
> >
> > --
> > Richard Gaskin
> > Fourth World Systems
> > Software Design and Development for the Desktop, Mobile, and the Web
> > 
> > ambassa...@fourthworld.comhttp://www.FourthWorld.com
> >
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
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: Problems locating Android SDK

2020-04-05 Thread Skip Kimpel via use-livecode
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 MotoG6 on WiFi without a SIM
> card...USB... it is  really fast to build and take one variable out of the
> equation. (I don't trust the VMs... call me superstitious...)
>
> When I an "happy"  I put the SivaSiva.ipk on our web server and have
> good beta tester in four different countries. All with very different
> Android phones/Bandwidth
>
>
>
> On 4/5/20, 2:44 PM, "use-livecode on behalf of Colin Holgate via
> use-livecode"  use-livecode@lists.runrev.com> wrote:
>
> You could give the path that you are using. Also, did you have to set
> up any virtual machines? Long ago LiveCode was only happy if you had an
> Android 2.2 virtual device.
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Problems locating Android SDK

2020-04-05 Thread Skip Kimpel via use-livecode
okay, glad it is not just me then.

SKIP

On Sun, Apr 5, 2020 at 6:29 PM Colin Holgate via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I manually downloaded Tools from here:
>
> https://developer.android.com/studio
>
> And put it into the SDK folder. LiveCode is still not happy.
>
>
> > On Apr 5, 2020, at 4:09 PM, matthias rebbe via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > Hi Skip,
> >
> > the problem is that Android Studio 3.6.x does not install Android
> command line tools by default.
> >
> > this is an excerpt of the update LC lesson
> http://lessons.livecode.com/m/2571/l/625198-livecode-and-android-studio
> >
> >
> >
> > Update: Android Studio 3.6 has stopped to install the android command
> line tools by default. These tools were stored in the
> /Users/youruser/Library/Android/sdk/tools folder, and contained some
> necessary jar files that are needed to build for Android.
> >
> > You can still force Android Studio 3.6 to download these tools:
> >
> > - Launch Android Studio and go to Configure -> "SDK Manager"
> >
> > - In the new window open "System Settings -> Android SDK".
> >
> > - From there pick the tab "SDK Tools".
> >
> > - Uncheck the "Hide Obsolete Packages" option in the bottom of the
> window.
> >
> > - 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:
> >
> >
> >
> >
> >
> > HTH,
> >
> > -
> > Matthias Rebbe
> > Life Is Too Short For Boring Code
> >
> >> Am 05.04.2020 um 23:55 schrieb Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com>:
> >>
> >> Very helpful, thank you Colin. and I knew it would not be that easy.
> >> Now I get a message that says "The chosen folder is not a valid Android
> >> SDK.  Please ensure you have installed it correctly, and enabled support
> >> for 9.0 (api 28).   I went back into Android Studio and verified the
> path
> >> was correct and that I had checked the box for version 9.0, which I had.
> >> Any other suggestions for this new phase I am stuck at?
> >>
> >> SKIP
> >>
> >> On Sun, Apr 5, 2020 at 5:47 PM Colin Holgate via use-livecode <
> >> use-livecode@lists.runrev.com> wrote:
> >>
> >>> In Finder there is a Go menu, in which you can Go to Folder… Then you
> type
> >>> in the path to the hidden user library to get there. The same thing
> works
> >>> in open dialogs. When you are pointing LiveCode to the Android SDK,
> type
> >>> command-shift-g, and put in:
> >>>
> >>> ~/Library/Android/sdk/
> >>>
> >>> That path isn’t exactly right I’m sure, 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 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 to get there.
> >>>>
> >>>> Can anybody help?  This is driving me nuts because I  know it is a
> quick
> >>>> fix.
> >>>>
> >>>> Thanks,
> >>>>
> >>>> 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
> >>>
> >>>
> >>> ___
> >>> use-livecode mailing list
> >>> use-livecode@lists.runrev.com
> >>> Please visit this url to subscribe, unsubscribe and manage your
> >>> subscription 

Re: Problems locating Android SDK

2020-04-05 Thread Skip Kimpel via use-livecode
Thank you Matthias, however, I had done that already.  Unfortunately, the
problem still persists.

SKIP

On Sun, Apr 5, 2020 at 6:10 PM matthias rebbe via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Hi Skip,
>
> the problem is that Android Studio 3.6.x does not install Android command
> line tools by default.
>
> this is an excerpt of the update LC lesson
> http://lessons.livecode.com/m/2571/l/625198-livecode-and-android-studio
>
>
>
> Update: Android Studio 3.6 has stopped to install the android command line
> tools by default. These tools were stored in the
> /Users/youruser/Library/Android/sdk/tools folder, and contained some
> necessary jar files that are needed to build for Android.
>
> You can still force Android Studio 3.6 to download these tools:
>
> - Launch Android Studio and go to Configure -> "SDK Manager"
>
> - In the new window open "System Settings -> Android SDK".
>
> - From there pick the tab "SDK Tools".
>
> - Uncheck the "Hide Obsolete Packages" option in the bottom of the window.
>
> - 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:
>
>
>
>
>
> HTH,
>
> -
> Matthias Rebbe
> Life Is Too Short For Boring Code
>
> > Am 05.04.2020 um 23:55 schrieb Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com>:
> >
> > Very helpful, thank you Colin. and I knew it would not be that easy.
> > Now I get a message that says "The chosen folder is not a valid Android
> > SDK.  Please ensure you have installed it correctly, and enabled support
> > for 9.0 (api 28).   I went back into Android Studio and verified the path
> > was correct and that I had checked the box for version 9.0, which I had.
> > Any other suggestions for this new phase I am stuck at?
> >
> > SKIP
> >
> > On Sun, Apr 5, 2020 at 5:47 PM Colin Holgate via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> In Finder there is a Go menu, in which you can Go to Folder… Then you
> type
> >> in the path to the hidden user library to get there. The same thing
> works
> >> in open dialogs. When you are pointing LiveCode to the Android SDK, type
> >> command-shift-g, and put in:
> >>
> >> ~/Library/Android/sdk/
> >>
> >> That path isn’t exactly right I’m sure, 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 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 to get there.
> >>>
> >>> Can anybody help?  This is driving me nuts because I  know it is a
> quick
> >>> fix.
> >>>
> >>> Thanks,
> >>>
> >>> 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
> >>
> >>
> >> ___
> >> 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
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Problems locating Android SDK

2020-04-05 Thread Skip Kimpel via use-livecode
Very helpful, thank you Colin. and I knew it would not be that easy.
 Now I get a message that says "The chosen folder is not a valid Android
SDK.  Please ensure you have installed it correctly, and enabled support
for 9.0 (api 28).   I went back into Android Studio and verified the path
was correct and that I had checked the box for version 9.0, which I had.
Any other suggestions for this new phase I am stuck at?

SKIP

On Sun, Apr 5, 2020 at 5:47 PM Colin Holgate via use-livecode <
use-livecode@lists.runrev.com> wrote:

> In Finder there is a Go menu, in which you can Go to Folder… Then you type
> in the path to the hidden user library to get there. The same thing works
> in open dialogs. When you are pointing LiveCode to the Android SDK, type
> command-shift-g, and put in:
>
> ~/Library/Android/sdk/
>
> That path isn’t exactly right I’m sure, 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 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 to get there.
> >
> > Can anybody help?  This is driving me nuts because I  know it is a quick
> > fix.
> >
> > Thanks,
> >
> > 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
>
>
> ___
> 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


Problems locating Android SDK

2020-04-05 Thread Skip Kimpel via use-livecode
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 to get there.

Can anybody help?  This is driving me nuts because I  know it is a quick
fix.

Thanks,

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


Strange times, amazing projects

2020-04-03 Thread Skip Kimpel via use-livecode
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
pull out skill sets and take on projects / challenges that I have not done
in quite some time.  Actually, it is quite exhilarating.

I won't get into details about the project as a whole right now (but I
can't wait to share it with you all when it is done) but I have a challenge
that involves mapping and coordinates and I am trying to wrap my head
around how to accomplish it.

I have delivery zones built in Google Earth and I have delivery addresses.
I need to run through the list of delivery addresses to determine which
delivery zone they fall in.  Sounds simple (or maybe not) but I can't
figure out how to work out the coordinates of the address and filter it
within the perimeter coordinates of the zone.  Hopefully I explained this
clearly.

I realize I will probably have to first run the delivery addresses against
some database that will give me GPS coordinates which I can then use
against my delivery zone kml data.

Has anybody done this before?  Any suggestions?

As always, your input is GREATLY appreciated :)

Best regards,

SKIP KIMPEL
___
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: Preview HTML of a field

2018-08-15 Thread Skip Kimpel via use-livecode
Perfect... thank you.

SKIP

On Wed, Aug 15, 2018 at 11:22 AM Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> get the numToCodePoint of one of the bad characters. It may be your
> database encoding is an issue. If you are textencoding going in and
> textdecoding 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.runrev.com> wrote:
> >
> > 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
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Preview HTML of a field

2018-08-15 Thread Skip Kimpel via use-livecode
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@lists.runrev.com> wrote:

> I'd suggest using the "effective htmlText of field " as the
> effective keyword will add tags for the inherited styles of the field
> (like default font, etc.)
>
>
> On 8/15/2018 10:34 AM, AndyP via use-livecode wrote:
> > Add a browser widget and then
> >
> > set the htmlText of widget "Browser" to field "myField"
> >
> >
> >
> > -
> > Andy Piddock
> >
> >
> > My software never has bugs. It just develops random features.
> >
> > TinyIDE  a Free alternative minimalist IDE Plugin for LiveCode
> >
> >
> > Script editor Themer for LC http://2108.co.uk
> >
> > PointandSee is a FREE simple but full featured under cursor colour
> picker / finder.
> > http://www.pointandsee.co.uk  - made with LiveCode
> > --
> > Sent from:
> http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Preview HTML of a field

2018-08-15 Thread Skip Kimpel via use-livecode
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 via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I'd suggest using the "effective htmlText of field " as the
> effective keyword will add tags for the inherited styles of the field
> (like default font, etc.)
>
>
> On 8/15/2018 10:34 AM, AndyP via use-livecode wrote:
> > Add a browser widget and then
> >
> > set the htmlText of widget "Browser" to field "myField"
> >
> >
> >
> > -
> > Andy Piddock
> >
> >
> > My software never has bugs. It just develops random features.
> >
> > TinyIDE  a Free alternative minimalist IDE Plugin for LiveCode
> >
> >
> > Script editor Themer for LC http://2108.co.uk
> >
> > PointandSee is a FREE simple but full featured under cursor colour
> picker / finder.
> > http://www.pointandsee.co.uk  - made with LiveCode
> > --
> > Sent from:
> http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html
> >
> > ___
> > 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


Preview HTML of a field

2018-08-15 Thread Skip Kimpel via use-livecode
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 subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: [ANN] v2.2 of DB Lib

2018-06-19 Thread Skip Kimpel via use-livecode
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 better Unicode
> handling. Basically I've replaced old uniencode/unidecode based code with
> the new textencode/textdecode stuff.
>
> I've tried with some Cyrillic and Tamil text and it worked well.
>
> You can grab a GPL version from:
>
>   https://github.com/soapdog/livecode-dblib/releases/tag/v2.2
>
> And you can buy a commercial version from:
>
>   https://sowl.co/YpT7k
>
>  I will redo my own home page soon and list the LC stuff it is just not
> ready and I know some people needs these patches. I will work now on the
> new 3.0 release in which I will rewrite the remote database library PHP
> code to be better.
>
> om om
> andre
>
>
>
> --
> http://www.andregarzia.com -- All We Do Is Code.
> http://fon.nu -- minimalist url shortening service.
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Microsoft 365 Rest API

2017-10-12 Thread Skip Kimpel via use-livecode
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 Kimpel via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> > 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 community?
> > >
> > > ~Roger
> > >
> > >
> > > 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 best way
> for
> > > LC
> > > > to work with it is via their webAPI (as are most things) until v9 is
> > > ready.
> > > > But this still means a lot of stuff being put together outside of LC.
> > You
> > > > first need an Azure account setup to enable authentication. You then
> > need
> > > > someone conversant with c#, Visual Basic and .net to write the APIs
> > based
> > > > on the MS SDK. This then needs putting onto a .net server. From there
> > it
> > > is
> > > > really straight forward to set up a http header in LC and all of the
> > Post
> > > > and http calls to send and receive data.
> > > >
> > > > To be honest, the LC side of things is really simple, and our API guy
> > has
> > > > been really good at setting the whole thing up for us. We found him
> via
> > > > PeoplePerHour and is clearly one of the best in his field.
> > > >
> > > > It’s been a long process working out how to get it all to work
> together
> > > so
> > > > I’m happy I can now make it easier for members like you, saving you
> the
> > > > effort of fumbling around (like we did) to find a solution.
> > > >
> > > > PM me if and when you need more guidance and we can set up a Skype,
> > > > FaceTime or whatever.
> > > >
> > > > All the best
> > > >
> > > > Sean Cole
> > > > Pi Digital
> > > > s...@pidigital.co.uk
> > > >
> > > > > On 12 Oct 2017, at 12:52, Colin Kelly via use-livecode <
> > > > use-livecode@lists.runrev.com> wrote:
> > > > >
> > > > > Does anyone have any working livecode scripts/libraries to use with
> > the
> > > > Microsoft 365 Rest API for accessing Calendar entries?
> > > > >
> > > > >
> > > > >
> > > > > Any help much appreciated.
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > >
> > > > > Colin Kelly
> > > > >
> > > > >
> > > > >
> > > > > ___
> > > > > 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
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Microsoft 365 Rest API

2017-10-12 Thread Skip Kimpel via use-livecode
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 community?
>
> ~Roger
>
>
> 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 best way for
> LC
> > to work with it is via their webAPI (as are most things) until v9 is
> ready.
> > But this still means a lot of stuff being put together outside of LC. You
> > first need an Azure account setup to enable authentication. You then need
> > someone conversant with c#, Visual Basic and .net to write the APIs based
> > on the MS SDK. This then needs putting onto a .net server. From there it
> is
> > really straight forward to set up a http header in LC and all of the Post
> > and http calls to send and receive data.
> >
> > To be honest, the LC side of things is really simple, and our API guy has
> > been really good at setting the whole thing up for us. We found him via
> > PeoplePerHour and is clearly one of the best in his field.
> >
> > It’s been a long process working out how to get it all to work together
> so
> > I’m happy I can now make it easier for members like you, saving you the
> > effort of fumbling around (like we did) to find a solution.
> >
> > PM me if and when you need more guidance and we can set up a Skype,
> > FaceTime or whatever.
> >
> > All the best
> >
> > Sean Cole
> > Pi Digital
> > s...@pidigital.co.uk
> >
> > > On 12 Oct 2017, at 12:52, Colin Kelly via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> > >
> > > Does anyone have any working livecode scripts/libraries to use with the
> > Microsoft 365 Rest API for accessing Calendar entries?
> > >
> > >
> > >
> > > Any help much appreciated.
> > >
> > >
> > >
> > > --
> > >
> > > Colin Kelly
> > >
> > >
> > >
> > > ___
> > > 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
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

2017-10-12 Thread Skip Kimpel via use-livecode
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 best way for LC
> to work with it is via their webAPI (as are most things) until v9 is ready.
> But this still means a lot of stuff being put together outside of LC. You
> first need an Azure account setup to enable authentication. You then need
> someone conversant with c#, Visual Basic and .net to write the APIs based
> on the MS SDK. This then needs putting onto a .net server. From there it is
> really straight forward to set up a http header in LC and all of the Post
> and http calls to send and receive data.
>
> To be honest, the LC side of things is really simple, and our API guy has
> been really good at setting the whole thing up for us. We found him via
> PeoplePerHour and is clearly one of the best in his field.
>
> It’s been a long process working out how to get it all to work together so
> I’m happy I can now make it easier for members like you, saving you the
> effort of fumbling around (like we did) to find a solution.
>
> PM me if and when you need more guidance and we can set up a Skype,
> FaceTime or whatever.
>
> All the best
>
> Sean Cole
> Pi Digital
> s...@pidigital.co.uk
>
> > On 12 Oct 2017, at 12:52, Colin Kelly via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > Does anyone have any working livecode scripts/libraries to use with the
> Microsoft 365 Rest API for accessing Calendar entries?
> >
> >
> >
> > Any help much appreciated.
> >
> >
> >
> > --
> >
> > Colin Kelly
> >
> >
> >
> > ___
> > 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

LC on Raspberry Pi3

2017-09-01 Thread Skip Kimpel via use-livecode
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: What's Happening with TactileMedia?

2017-08-24 Thread Skip Kimpel via use-livecode
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:

> Sannyasin Brahmanathaswami wrote:
>
> > Scott's web site is offline.
>
> Raney, Rossi, McDonald, or someone else?
>
> --
>  Richard Gaskin
>  Fourth World Systems
>  Software Design and Development for the Desktop, Mobile, and the Web
>  
>  ambassa...@fourthworld.comhttp://www.FourthWorld.com
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Hackintosh

2017-08-01 Thread Skip Kimpel via use-livecode
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 (nowadays) old
> Foxconn H55 MS motherboard with and (nowadays) old Intel i7 processor.
> Working on this desktop machine (12 GB RM, 512 GB SSD) is even now still a
> pleasure beside the fact that I own a real MacBook Pro i7 which I use when
> I am on the road. The machine is booting Windows 10 Pro, Mac OS X El
> Captain and Ubuntu flawless (although configuration the Clover Bootloader
> took me a little more time than expected).
>
> The good thing is that nowadays Mac OS X is free available. The only thing
> I would advise you when you start to build a Hackintosh is to go buy a
> motherboard from GigaByte (UEFI Bios) which is nowadays much closest to the
> specs of an iMac etc. For Wifi/Bluetooth compatibility buy an PCIe
> Broadcomm card (native Apple support).
> For video stay to NVDIA (http://www.macbreaker.com/
> 2012/06/hackintosh-graphics-cards.html).
> Use Clover Bootloader for installation bootloader.
> A lot of information you can find on TonyMac which is one of the first
> pioneers: https://www.tonymacx86.com/
> I have passed in the beginning all the failures and successes… so if you
> encounter any problems just contact me if you need help.
>
> Most important: Yes, LiveCode (all versions) have worked on this machine
> without any problems.
>
> Goodluck,
> Erik
>
>
>
> On 01/08/17 21:36, "use-livecode on behalf of Dan Friedman via
> use-livecode"  use-livecode@lists.runrev.com> wrote:
>
> Greetings!
>
> Has anyone built their own Hackintosh computer?  If so, have you had
> any trouble working with XCode, iTunes Connect, Apple Developer tools,
> getting apps approved, etc.   I would like to build one (I’m not in love
> with Apple’s pre-built choices), but don’t want any hassles down the road.
> I wouldn’t put it past Apple to disallow an app if it wasn’t
> developed/built on an Apple Certified Mac.
>
> -Dan
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT: Hackintosh

2017-08-01 Thread Skip Kimpel via use-livecode
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, 2017 at 4:01 PM, Roger Eller via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I have only built one out of hobbyist curiosity, not for work.  In use I
> cannot tell the difference, but I have not submitted any apps to the app
> store.  I have built Android apps and loaded them onto my own devices
> without any problem.
>
> ~Roger
>
>
> On Tue, Aug 1, 2017 at 3:36 PM, Dan Friedman via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> > Greetings!
> >
> > Has anyone built their own Hackintosh computer?  If so, have you had any
> > trouble working with XCode, iTunes Connect, Apple Developer tools,
> getting
> > apps approved, etc.   I would like to build one (I’m not in love with
> > Apple’s pre-built choices), but don’t want any hassles down the road.  I
> > wouldn’t put it past Apple to disallow an app if it wasn’t
> developed/built
> > on an Apple Certified Mac.
> >
> > -Dan
> >
> >
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC Global - my experience

2017-06-17 Thread Skip Kimpel via use-livecode
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 questions and start new
> discussions... being an independent developer who can barely pay the bills,
> I appreciate not having to put a huge investment into lodging etc... All in
> all, the advantages of this setup far out weight the disadvantage of not
> having a few mails and going out drinking with y'all.
> 
> So my question is... can the Livecode folks setup a virtual bar?
> 
> 
> 
> -
> ---
> Greg (pink) Miller
> mad, pink and dangerous to code
> --
> View this message in context: 
> http://runtime-revolution.278305.n4.nabble.com/LC-Global-my-experience-tp4715908p4715965.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: [ANN] Introducing Remote DB Lib

2017-06-06 Thread Skip Kimpel via use-livecode
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 apps without writing SQL directly.
>
> This post is to introduce a great new feature called Remote DB Lib. As you
> may know from posts on the mailing list and forums, many developers would
> like to use DB Lib in their apps over the internet. Like all other database
> libraries that work on top of RevDB, DB Lib (until today) needed to connect
> directly to the database server to work and this is not a good solution for
> apps that work over the internet since exposing MySQL to the internet at
> large is a huge security risk.
>
> Today I am releasing the first version of a drop-in replacement library
> called **Remote DB Lib**. This new library has the same API as the current
> DB Lib but instead of working on top of RevDB, it works alongside a
> matching PHP file on your server, it is this PHP file that actually talks
> to the database server. The Remote DB Lib picks all your DB Lib calls and
> packs it on an encrypted message that is sent to the PHP file where it is
> decrypted and executed. This library is using state of the art AES 256
> encryption.
>
> More info at: andregarzia.com/en/blog/introducing-remote-dblib
>
> This new library is a part of the DB Lib product so all current customers
> should be receiving an update notice shortly. For those that don't have a
> license yet, this is a good time to get it and enhance the security of your
> apps.
>
> Cheers
>
> andre
>
>
> 
>
>
> --
> http://www.andregarzia.com -- All We Do Is Code.
> http://fon.nu -- minimalist url shortening service.
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Producing a list of duplicates

2017-03-22 Thread Skip Kimpel via use-livecode
Thanks for everybody's advice yes, I totally forgot to check the Master
Library!  That thing has saved me so many times.

SKIP

On Wed, Mar 22, 2017 at 3:01 PM, Tom Glod via use-livecode <
use-livecode@lists.runrev.com> wrote:

> MASTER LIBRARY? how did I miss thatthanks 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 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.
> > >
> >
> > repeat for each line theLin in theList
> >
> > add 1 to theVals[theLin]
> >
> > if theVals[theLin] > 1 then
> >
> > put theVals[theLin] into theDups[theLin]
> >
> > end if
> >
> > end repeat
> >
> >
> > theDups has duplicated addresses as it's keys, and the number of dups as
> > the values
> >
> > Or, you could extend and parse the actual email address out of each line,
> > and use *that* as the key, to catch situations like
> >
> > j...@doe.com
> >
> > <j...@doe.com> "John Doe"
> > <j...@doe.com> "Johnathan Doe"
> >
> > In that case, I'd probably put
> >
> > put theLin into theDups[theEmail][theVals[theEmail]]
> >
> > so that you get a list for each type
> >
> > --
> > Dr. Richard E. Hawkins, Esq.
> > (702) 508-8462
> > ___
> > 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
> >
>
>
>
> --
> *Tom Glod*
>
> CEO @ *MakeShyft R.D.A* - www.makeshyft.com
>
>
>
> Developer of *U.M.P* - www.IamUMP.com
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: [ANN] tinyDictionary

2017-03-22 Thread Skip Kimpel via use-livecode
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 uploaded a compact version of the dictionaries for LC 8.1 and up to
> > Livecodeshare
> >
> > http://livecodeshare.runrev.com/stack/825/tinyDictionary_0_7_7_7
> >
> > this is also accessible via "Sample Stacks" from inside LC.
> >
> > it is the result of Mike Kerners push to have a small footprint
> dictionary.
> >
> > James Hale contributed to tinyDict, thanks James.
> >
> > Comments bug reports either on the use-list or in the forum
> >
> > http://forums.livecode.com/viewtopic.php?f=67=28731=152646#p152646
> >
> > or mail me.
> >
> > Kind regards
> > Bernd
> >
> >
> >
> > --
> > View this message in context: http://runtime-revolution.
> 278305.n4.nabble.com/ANN-tinyDictionary-tp4713256.html
> > Sent from the Revolution - User mailing list archive at Nabble.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
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Producing a list of duplicates

2017-03-22 Thread Skip Kimpel via use-livecode
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 greatly appreciated!

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: LiveCode + Amazon CloudFront

2017-02-20 Thread Skip Kimpel via use-livecode
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 aware
> of mergAWS, but it ONLY works on iOS. We also need this for Android. Any
> suggestions???
> 
> We need this ASAP!
> 
> --Todd Fabacher
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


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

2017-02-05 Thread Skip Kimpel via use-livecode
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-livecode <
use-livecode@lists.runrev.com> wrote:

> Wow this is fantastic!
>
> Thank you so much for sharing what you’ve done, it really is remarkable
>
> Kind regards
>
> Dave
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Drag List Items Up and Down

2017-02-02 Thread Skip Kimpel via use-livecode
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 into tcl
>set the textcolor of line tcl of me to "red"
>if line tcl of me is empty then
>   exit mousedown
>end if
>put item 2 of the mouseLoc into tstarty
>put the effective textHeight of me into th
>repeat while the mouse is down
>   if item 2 of the mouseLoc - tstarty > (th/2) then
>  if within (field "myField", the mouseLoc) is true then
> lock screen
> put cr & line tcl of me after line tcl + 1 of me
> delete line tcl of me
> add 1 to tcl
> set the textcolor of line tcl of me to "red"
> add th to tstarty
> unlock screen
>  end if
>   else if tstarty - item 2 of the mouseLoc > (th/2) then
>  if within (field "myField", the mouseLoc) is true then
> lock screen
> put line tcl of me & cr before line tcl - 1 of me
> delete line tcl + 1 of me
> subtract 1 from tcl
> set the textcolor of line tcl of me to "red"
> subtract th from tstarty
> unlock screen
>  end if
>   end if
>  end repeat
>set the textcolor of line tcl of me to "black"
>set the hilitedLine of me to tcl
>
> end mouseDown
>
>
>
> -
> Andy Piddock
>
>
> My software never has bugs. It just develops random features.
>
> TinyIDE a Free alternative minimalist IDE Plugin for LiveCode
> TinyIDE
>
>
> Script editor Themer for LC http://2108.co.uk
>
> PointandSee is a FREE simple but full featured under cursor colour picker
> / finder.
> http://www.pointandsee.co.uk  - made with LiveCode
> --
> View this message in context: http://runtime-revolution.
> 278305.n4.nabble.com/Drag-List-Items-Up-and-Down-tp4712158p4712166.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Drag List Items Up and Down

2017-02-02 Thread Skip Kimpel via use-livecode
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
>
> Add a few lines
>
> In the field properties *check the Lock text* /it will not work without
> this/
>
>
> Add this to the field
>
> on mouseDown
>put word 2 of the clickLine into tcl
>set the textcolor of line tcl of me to "red"
>if line tcl of me is empty then
>   exit mousedown
>end if
>put item 2 of the mouseLoc into tstarty
>put the effective textHeight of me into th
>repeat while the mouse is down
>   if item 2 of the mouseLoc - tstarty > (th/2) then
>  lock screen
>  put cr & line tcl of me after line tcl + 1 of me
>  delete line tcl of me
>  add 1 to tcl
>  set the textcolor of line tcl of me to "red"
>  add th to tstarty
>  unlock screen
>   else if tstarty - item 2 of the mouseLoc > (th/2) then
>  lock screen
>  put line tcl of me & cr before line tcl - 1 of me
>  delete line tcl + 1 of me
>  subtract 1 from tcl
>  set the textcolor of line tcl of me to "red"
>  subtract th from tstarty
>  unlock screen
>   end if
>end repeat
>set the textcolor of line tcl of me to "black"
>set the hilitedLine of me to tcl
> end mouseDown
>
> This came from a question on one of the forums, not sure which and from
> whom.
>
>
>
>
> -
> Andy Piddock
>
>
> My software never has bugs. It just develops random features.
>
> TinyIDE a Free alternative minimalist IDE Plugin for LiveCode
> TinyIDE
>
>
> Script editor Themer for LC http://2108.co.uk
>
> PointandSee is a FREE simple but full featured under cursor colour picker
> / finder.
> http://www.pointandsee.co.uk  - made with LiveCode
> --
> View this message in context: http://runtime-revolution.
> 278305.n4.nabble.com/Drag-List-Items-Up-and-Down-tp4712158p4712163.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: It looks like Director is Finally Dead

2017-01-28 Thread Skip Kimpel via use-livecode
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 Director Podcast!
>
> Tom Bodine
>
>
>
> --
> View this message in context: http://runtime-revolution.
> 278305.n4.nabble.com/It-looks-like-Director-is-Finally-Dead-
> tp4711978p4712011.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: It looks like Director is Finally Dead

2017-01-27 Thread Skip Kimpel via use-livecode
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-livecode@lists.runrev.com> wrote:

> Thanks for the link. I’m going to post it on Marc Canter’s Facebook wall!
>
>
> > On Jan 27, 2017, at 10:03 AM, Klaus major-k via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > Hi Colin,
> >
> >> Am 27.01.2017 um 17:56 schrieb Colin Holgate via use-livecode <
> use-livecode@lists.runrev.com>:
> >>
> >> I can’t find any announcements from Adobe, and the article doesn’t
> provide links.
> >
> > there is in fact a link to an ADOBE blog:
> >  adobe-contribute-director-and-shockwave/>
> >
> > I have been using Director for years, its animation possibilities were
> AWESOME, wish we had (a fraction of) this in LC,
> > but scripting was a real pain in the arse!
> >
> > I never regretted my switch to MetaCard in 1999! ;-)
> >
> >> The logic in the article is a bit dumb. They say that Mac shockwave
> support is going to end, and so naturally they would get rid of the tool
> that makes shockwave content. But shockwave is only one part of what
> Director is good for.
> >> Anyway, I’ll keep trying to find an Adobe post about it.
> >>
> >>> On Jan 27, 2017, at 9:45 AM, Lynn Fredricks via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >>>  contribute-and-director-on-february-1-drop-shockwave-for-
> mac-support-on-march-14/>
> >
> > Best
> >
> > Klaus
> >
> > --
> > Klaus Major
> > http://www.major-k.de
> > kl...@major-k.de
> >
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [OT] Download Request

2017-01-11 Thread Skip Kimpel via use-livecode
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… when I check on them
> via iTunes Connect all things seem to be in order, but when I click on
> “Show in iTunes” it says the app isn’t available  in the U.S. store… and,
> well, I’m in the U.S….
>
> Is anyone outside of the U.S willing to check for me to see if you can
> download the app? It’s iPad only and  call “Number Tile Fill Up” … it’s
> free.
>
> I have contacted iTunes “help” but thought I’d see if I could gather a bit
> of data before they respond.
>
> Thanks in advance for your help.
>
> be well,
> randy
>
> Randy Hengst
> www.classroomFocusedSoftware.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