Re: Livecode Future - End User Cost Extravaganza

[Skip Kimpel via use-livecode]

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

Having said that, one should take notice at radical licensing model change 
failures, such as Unity.  There are lessons to be learned out there.

For the record, I love LC and its power and simplicity.  I hope this all works 
out in the short term (and long term!)

Best regards,

SKIP KIMPEL

> On Jul 27, 2024, at 10:18 PM, Curry Kenworthy via use-livecode 
>  wrote:
> 
> 
> Mike:
> 
> > $440/device is not happening. even $100/device is not happening.
> > we are not paying $100/employee so they can run our payroll app,
> > for instance, on their phone.
> 
> Well said! You summed it up perfectly. Thanks.
> What LC tier would work for you?
> 
> My experience ...
> 
> Consulting clients, big and small, have real-life budgets!
> Many already have servers and don't want to pay arm and leg extra.
> 
> 5 to 10 users is considered modest, and they want it affordable.
> Most sure as heck don't want extra app fee if they hire one staff.
> 
> More attractive 'Internal/Bespoke Apps' pricing for real-life clients:
> 
> LC data: Halve the current user price BEFORE volume discounts.
> DIY data: 100 users per current user price! Honor system/trust.
> 
> Best wishes,
> 
> Curry Kenworthy
> 
> Radically Innovative Christian LiveCode Development
> "PASSION for Elegant, Efficient Code!"
> https://livecodeconsulting.com/
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

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

Re: AR applications?

[Skip Kimpel via use-livecode]

Wait… what?  I have been away from this list for a while, LC is not currently 
compilable??

SKIP

> On May 27, 2023, at 4:39 PM, harrison--- via use-livecode 
>  wrote:
> 
> Hi Skip,
> 
> Doubtful.  I would wait until after we have a compilable version of LC and 
> then it will be more possible.
> 
> Rick
> 
>> On May 27, 2023, at 12:26 PM, Skip Kimpel via use-livecode 
>>  wrote:
>> 
>> Has anybody done anything with LC and AR?
>> 
>> Curious minds want to know :)
>> 
>> SKIP
> 
> ___
> 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

AR applications?

[Skip Kimpel via use-livecode]

Has anybody done anything with LC and AR?

Curious minds want to know :)

SKIP

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

Livecode / Github

[Skip Kimpel via use-livecode]

Greetings!

Been a while since I have been on this list.  Working on a new project and
wondering if the backing up of Livecode files to Github was ever
implemented and created.  I know there was talk of it at one time.

I apologize if it has been in place for a while and I am just out of the
loop.  Actually, I HOPE that is the case!

Regards,

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: JSON to Datagrid

[Skip Kimpel via use-livecode]

To functions actually needed... need to be able to convert to a datagrid
and I will be also pumping this data into a SQL server.

SKIP

On Wed, Dec 8, 2021 at 11:15 AM Skip Kimpel  wrote:

> I have been googling a solution for this but have not found a solid
> solution for this.
>
> Can anybody lead me in the right direction on this?
>
> SKIP
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

JSON to Datagrid

[Skip Kimpel via use-livecode]

I have been googling a solution for this but have not found a solid
solution for this.

Can anybody lead me in the right direction on this?

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

Re: [ANN] Organize - A daily task manager

[Skip Kimpel via use-livecode]

After seeing it, I will take credit for it :)

SKIP

On Thu, Aug 26, 2021 at 12:10 PM Mark Smith via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Hi Martin, I’ll take the compliment (that was I, not Skip, who produced
> the app) 😊
>
> Your suggestion of having a switch to hide/show checked items on the main
> page is a good one, if I had more room. As it is, I’m pretty much cramming
> everything I can onto that page. The row menu could be an option but I’ve
> already got plans for unused real estate there. However, I'll add it to the
> list and keep thinking about it.
>
> All the best,
> Mark
>
>
> > On Aug 26, 2021, at 2:10 PM, Martin Koob via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > Hi Skip
> >
> > The app looks great.  I will definitely download and try it once it is
> in the app store.
> >
> > A couple comments from your YouTube demo:
> >
> > First  I really like how you can create items by tapping in white space.
> It reduces the complexity of the interface.
> >
> > Second is a suggestion regarding the showing and hiding of checked items.
> >
> > You went to settings to do that.  I think that would be better if you
> could do that from the main interface, say with a toggle button for show
> and hide checked, or drop down “view” menu.
> >
> >   View
> >   Unchecked
> >   Checked
> >All
> >    •••
> >
> > The ••• could be for the  ‘more…’ maybe that could open the settings or
> a dialog with other view options.
> >
> > Martin
> >
> >
> >> On Aug 26, 2021, at 7:48 AM, Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >>
> >> Thank you, Mark!
> >>
> >>> On Aug 26, 2021, at 5:55 AM, Mark Smith via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >>>
> >>> Hi Skip, I’ve sent you a direct link in email as well.
> >>>
> >>> Cheers,
> >>> Mark
> >>>
> >>>> On Aug 26, 2021, at 1:13 AM, Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >>>>
> >>>> Me as well!  Looks like a fantastic product.
> >>>>
> >>>> SKIP
> >>>>
> >>>>>> On Aug 25, 2021, at 8:08 PM, Marc Siskin via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >>>>>
> >>>>> Mark,
> >>>>>
> >>>>> I would like to test your app.  I need an invitation code in order
> to do so.
> >>>>>
> >>>>> If you still have space, please send me a code directly to my e-mail.
> >>>>>
> >>>>> Thanks,
> >>>>> Marc Siskin
> >>>>> ---
> >>>>> Marc Siskin, Learning Engineer
> >>>>> Manager, Modern Language Resource Center
> >>>>> Carnegie Mellon University
> >>>>> msis...@andrew.cmu.edu<mailto:msis...@andrew.cmu.edu>
> >>>>>
> >>>>>
> >>>>>> On Aug 25, 2021, at 4:57 PM, Mark Smith via use-livecode <
> use-livecode@lists.runrev.com<mailto:use-livecode@lists.runrev.com>>
> wrote:
> >>>>>
> >>>>> I am very pleased to announce a wide-beta release of my first iOS
> app; Organize -- a daily to-do list manager. There is a demo on Youtube (
> https://youtu.be/LtQ5O1Qk80w <https://youtu.be/LtQ5O1Qk80w>) and you can
> download and install the (final) beta version here... (
> https://testflight.apple.com/join/AysRGtVv <
> https://testflight.apple.com/join/AysRGtVv>). A really big thanks to
> everyone who has helped me along the way (you all know who you are!!). I
> would be delighted to have anyone interested kick the tires and provide
> feedback, advice and suggestions.
> >>>>>
> >>>>> Cheers,
> >>>>> Mark
> >>>>>
> >>>>> ___
> >>>>> use-livecode mailing list
> >>>>> use-livecode@lists.runrev.com<mailto: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
> >>>>>

Re: [ANN] Organize - A daily task manager

[Skip Kimpel via use-livecode]

Thank you, Mark!

> On Aug 26, 2021, at 5:55 AM, Mark Smith via use-livecode 
>  wrote:
> 
> Hi Skip, I’ve sent you a direct link in email as well. 
> 
> Cheers,
> Mark
> 
>> On Aug 26, 2021, at 1:13 AM, Skip Kimpel via use-livecode 
>>  wrote:
>> 
>> Me as well!  Looks like a fantastic product.
>> 
>> SKIP
>> 
>>>> On Aug 25, 2021, at 8:08 PM, Marc Siskin via use-livecode 
>>>>  wrote:
>>> 
>>> Mark,
>>> 
>>> I would like to test your app.  I need an invitation code in order to do so.
>>> 
>>> If you still have space, please send me a code directly to my e-mail.
>>> 
>>> Thanks,
>>> Marc Siskin
>>> ---
>>> Marc Siskin, Learning Engineer
>>> Manager, Modern Language Resource Center
>>> Carnegie Mellon University
>>> msis...@andrew.cmu.edu<mailto:msis...@andrew.cmu.edu>
>>> 
>>> 
>>>> On Aug 25, 2021, at 4:57 PM, Mark Smith via use-livecode 
>>>> mailto:use-livecode@lists.runrev.com>> 
>>>> wrote:
>>> 
>>> I am very pleased to announce a wide-beta release of my first iOS app; 
>>> Organize -- a daily to-do list manager. There is a demo on Youtube 
>>> (https://youtu.be/LtQ5O1Qk80w <https://youtu.be/LtQ5O1Qk80w>) and you can 
>>> download and install the (final) beta version here... 
>>> (https://testflight.apple.com/join/AysRGtVv 
>>> <https://testflight.apple.com/join/AysRGtVv>). A really big thanks to 
>>> everyone who has helped me along the way (you all know who you are!!). I 
>>> would be delighted to have anyone interested kick the tires and provide 
>>> feedback, advice and suggestions.
>>> 
>>> Cheers,
>>> Mark
>>> 
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com<mailto: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: [ANN] Organize - A daily task manager

[Skip Kimpel via use-livecode]

Me as well!  Looks like a fantastic product.

SKIP

> On Aug 25, 2021, at 8:08 PM, Marc Siskin via use-livecode 
>  wrote:
> 
> Mark,
> 
> I would like to test your app.  I need an invitation code in order to do so.
> 
> If you still have space, please send me a code directly to my e-mail.
> 
> Thanks,
> Marc Siskin
> ---
> Marc Siskin, Learning Engineer
> Manager, Modern Language Resource Center
> Carnegie Mellon University
> msis...@andrew.cmu.edu
> 
> 
> On Aug 25, 2021, at 4:57 PM, Mark Smith via use-livecode 
> mailto:use-livecode@lists.runrev.com>> wrote:
> 
> I am very pleased to announce a wide-beta release of my first iOS app; 
> Organize -- a daily to-do list manager. There is a demo on Youtube 
> (https://youtu.be/LtQ5O1Qk80w ) and you can 
> download and install the (final) beta version here... 
> (https://testflight.apple.com/join/AysRGtVv 
> ). A really big thanks to 
> everyone who has helped me along the way (you all know who you are!!). I 
> would be delighted to have anyone interested kick the tires and provide 
> feedback, advice and suggestions.
> 
> Cheers,
> Mark
> 
> ___
> 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: Need to populate array into datagrid

[Skip Kimpel via use-livecode]

So yes, I have tried this method but I am only getting the first element to
appear in the data grid ("1,2") in each row
None of the other details appear in the datagrid.

SKIP

On Tue, Aug 10, 2021 at 3:24 PM Mark Smith  wrote:

> Hi Skip, I’m not sure if this is what you are looking for but if you want
> to set the datagrid to display the data in an array you use:
>
> set the dgData of group "DataGrid" to pDataArray
>
> If your data is just delimited text you can use:
>
> *set* the dgText of *group* "DataGrid" to pData
>
> Either way tiggers the LayoutControl and FillInData handlers in the
> datagrid, so these need to be the same as (or be modified to meet) the
> structure of the incoming data.
>
> There is more in the dictionary under dgData and dgText.
>
> Mark
>
>
> On Aug 10, 2021, at 7:52 PM, Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> What is the best way to do this?  I have searched my old code, online
> results, etc and cannot find a clear cut answer.  Having said that, it has
> been a VERY long time since I have done this so I am part of the "use it or
> lose it" club right now.
>
> Any help would be greatly appreciated!
>
> SKIP
> ___
> 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

Need to populate array into datagrid

[Skip Kimpel via use-livecode]

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

Any help would be greatly appreciated!

SKIP
___
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: Most streamlined method to get data

[Skip Kimpel via use-livecode]

This is why you have to love this group.. never knew that the code
csvToText existed.   It worked like a charm!!!

Thank you so much everybody for your help with this puzzle!

SKIP

On Sun, Aug 1, 2021 at 7:39 PM Alex Tweedly via use-livecode <
use-livecode@lists.runrev.com> wrote:

> It looks like all the "thousand dollar+" amounts are quoted - i.e. it's
> an example of a regular CSV file - ugly but predictable.
>
> Did you try the CSVToTab converter ?
>
>
> https://github.com/macMikey/csvToText
> <https://github.com/macMikey/csvToText>
>
> Alex.
>
> On 01/08/2021 20:39, Skip Kimpel via use-livecode wrote:
> > So to give you a full sense of the ugliness of the CSV I am working with,
> > here it is:  (trying to add certain columns but because some columns have
> > multiple "thousand dollar+ amounts, it throws doing an item count.  Need
> to
> > get rid of all dollar signs (easy) and all the commas that are part of a
> > thousand+ dollar amount)
> > ---
> >
> >
> > ,3rd Party,Bakery,Bar,Catering,Delivery,Dine In,Drive Thru,Take
> > Out,,Vending,Total,
> >
> > 8:00 AM,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$406.43,,$0.00,$406.43,
> >
> > 9:00 AM,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,,$0.00,$0.00,
> >
> > 10:00
> AM,$40.74,$0.00,$0.00,$0.00,$0.00,$52.41,$0.00,$200.69,,$0.00,$293.84,
> >
> > 11:00
> >
> AM,$538.14,$3.29,$0.00,$0.00,$0.00,$581.30,$0.00,$165.93,,$0.00,"$1,288.66",
> >
> > 12:00
> >
> PM,$184.11,$3.29,$0.00,$0.00,$0.00,$745.68,$0.00,$274.36,,$0.00,"$1,207.44",
> >
> > 1:00
> > PM,$89.06,$12.87,$0.00,$0.00,$0.00,$741.65,$0.00,$132.26,,$0.00,$975.84,
> >
> > 2:00
> > PM,$216.86,$12.47,$0.00,$0.00,$0.00,$604.86,$0.00,$90.32,,$0.00,$924.51,
> >
> > 3:00
> PM,$160.69,$0.00,$0.00,$0.00,$0.00,$404.66,$0.00,$37.86,,$0.00,$603.21,
> >
> > 4:00
> > PM,$68.31,$33.71,$0.00,$0.00,$0.00,$349.46,$0.00,$323.34,,$0.00,$774.82,
> >
> > 5:00
> >
> PM,$286.31,$0.00,$0.00,$0.00,$0.00,$625.92,$0.00,$253.94,,$0.00,"$1,166.17",
> >
> > 6:00
> >
> PM,$500.66,$36.11,$0.00,$0.00,$0.00,$790.25,$0.00,$609.95,,$0.00,"$1,936.97",
> >
> > 7:00
> >
> PM,$224.81,$26.95,$0.00,$0.00,$0.00,"$1,038.03",$0.00,$137.17,,$0.00,"$1,426.96",
> >
> > 8:00 PM,$0.00,$0.00,$0.00,$0.00,$0.00,$55.46,$0.00,$7.10,,$0.00,$62.56,
> >
> > 9:00 PM,$0.00,$0.00,$0.00,$0.00,$0.00,$2.75,$0.00,$0.00,,$0.00,$2.75,
> >
> > 10:00 PM,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,,$0.00,$0.00,
> >
> >
> Total,"$2,309.69",$128.69,$0.00,$0.00,$0.00,"$5,992.43",$0.00,"$2,639.35",,$0.00,"$11,070.16",
> >
> > Page 1 of 1
> >
> > On Thu, Jul 29, 2021 at 1:41 PM Mark Wieder via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> On 7/29/21 9:24 AM, Ben Rubinstein via use-livecode wrote:
> >>> As grepophile, I'd go for some variation on
> >> While I heartily approve of Ben's use of grep, here's another approach
> >> using an array. Note that is somewhat specific to your data set, and
> >> from the looks of the data my guess is that you're heading down the path
> >> of csv madness.
> >>
> >> on mouseUp pMouseBtnNo
> >>  local tVar, tHeader, tCount, tOriginal
> >>
> >>  put field 1 into tVar
> >>  put line 1 of tVar into tHeader
> >>  delete line 1 of tVar
> >>  split tVar by cr
> >>
> >>  repeat for each key tKey in tVar
> >> # transform "$8,303.32" into "$8303.32"
> >> repeat for each trueword tTrueWord in tVar[tKey]
> >>put tTrueWord into tOriginal
> >>replace comma with empty in tTrueWord
> >>replace tOriginal with tTrueWord in tVar[tKey]
> >> end repeat
> >> # now we can deal with commas as itemDelimiters
> >> put 1 into tCount
> >> repeat for each item tWord in tVar[tKey]
> >>put tWord into tVar[tKey][tCount]
> >>add 1 to tCount
> >> end repeat
> >>  end repeat # for each key tKey in tVar
> >>
> >>  # now pick out the desired total
> >>  local tTotal, tOffset
> >>  put itemoffset("Total", tHeader) into tOffset
> >>  put tVar[5][tOffset] into tTotal
> >>

Re: Most streamlined method to get data

[Skip Kimpel via use-livecode]

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


,3rd Party,Bakery,Bar,Catering,Delivery,Dine In,Drive Thru,Take
Out,,Vending,Total,

8:00 AM,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$406.43,,$0.00,$406.43,

9:00 AM,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,,$0.00,$0.00,

10:00 AM,$40.74,$0.00,$0.00,$0.00,$0.00,$52.41,$0.00,$200.69,,$0.00,$293.84,

11:00
AM,$538.14,$3.29,$0.00,$0.00,$0.00,$581.30,$0.00,$165.93,,$0.00,"$1,288.66",

12:00
PM,$184.11,$3.29,$0.00,$0.00,$0.00,$745.68,$0.00,$274.36,,$0.00,"$1,207.44",

1:00
PM,$89.06,$12.87,$0.00,$0.00,$0.00,$741.65,$0.00,$132.26,,$0.00,$975.84,

2:00
PM,$216.86,$12.47,$0.00,$0.00,$0.00,$604.86,$0.00,$90.32,,$0.00,$924.51,

3:00 PM,$160.69,$0.00,$0.00,$0.00,$0.00,$404.66,$0.00,$37.86,,$0.00,$603.21,

4:00
PM,$68.31,$33.71,$0.00,$0.00,$0.00,$349.46,$0.00,$323.34,,$0.00,$774.82,

5:00
PM,$286.31,$0.00,$0.00,$0.00,$0.00,$625.92,$0.00,$253.94,,$0.00,"$1,166.17",

6:00
PM,$500.66,$36.11,$0.00,$0.00,$0.00,$790.25,$0.00,$609.95,,$0.00,"$1,936.97",

7:00
PM,$224.81,$26.95,$0.00,$0.00,$0.00,"$1,038.03",$0.00,$137.17,,$0.00,"$1,426.96",

8:00 PM,$0.00,$0.00,$0.00,$0.00,$0.00,$55.46,$0.00,$7.10,,$0.00,$62.56,

9:00 PM,$0.00,$0.00,$0.00,$0.00,$0.00,$2.75,$0.00,$0.00,,$0.00,$2.75,

10:00 PM,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,$0.00,,$0.00,$0.00,

Total,"$2,309.69",$128.69,$0.00,$0.00,$0.00,"$5,992.43",$0.00,"$2,639.35",,$0.00,"$11,070.16",

Page 1 of 1

On Thu, Jul 29, 2021 at 1:41 PM Mark Wieder via use-livecode <
use-livecode@lists.runrev.com> wrote:

> On 7/29/21 9:24 AM, Ben Rubinstein via use-livecode wrote:
> > As grepophile, I'd go for some variation on
>
> While I heartily approve of Ben's use of grep, here's another approach
> using an array. Note that is somewhat specific to your data set, and
> from the looks of the data my guess is that you're heading down the path
> of csv madness.
>
> on mouseUp pMouseBtnNo
> local tVar, tHeader, tCount, tOriginal
>
> put field 1 into tVar
> put line 1 of tVar into tHeader
> delete line 1 of tVar
> split tVar by cr
>
> repeat for each key tKey in tVar
># transform "$8,303.32" into "$8303.32"
>repeat for each trueword tTrueWord in tVar[tKey]
>   put tTrueWord into tOriginal
>   replace comma with empty in tTrueWord
>   replace tOriginal with tTrueWord in tVar[tKey]
>end repeat
># now we can deal with commas as itemDelimiters
>put 1 into tCount
>repeat for each item tWord in tVar[tKey]
>   put tWord into tVar[tKey][tCount]
>   add 1 to tCount
>end repeat
> end repeat # for each key tKey in tVar
>
> # now pick out the desired total
> local tTotal, tOffset
> put itemoffset("Total", tHeader) into tOffset
> put tVar[5][tOffset] into tTotal
> breakpoint
> end mouseUp
>
> --
>   Mark Wieder
>   ahsoftw...@gmail.com
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Most streamlined method to get data

[Skip Kimpel via use-livecode]

I have a variable that contains:

,Name,,,Quantity,Total,,,Percent

,Dine In,,,189,"$4,812.71",,,57.96%

,Take Out,,,72,"$1,676.43",,,20.19%

,3rd Party,,,54,"$1,779.35",,,21.43%

,Bakery,,,3,$34.83,,,0.42%

,Total,,,318,"$8,303.32",,,


What is the best way to get 8303.32 from that last line.  Obviously, the
complexity is the commas and getting rid of the dollar sign as well.


I know I am going to kick myself when somebody answers I am blank this
morning.  (NEED MORE COFFEE!)


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: Also looking for MSSQL integration person

[Skip Kimpel via use-livecode]

try_cast worked!!!  I converted those fields, using that technique, into a
varchar and BAM!

Thank you, Bob!

SKIP

On Mon, Jul 26, 2021 at 7:29 PM Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> > MSSQL has a try_cast snf cast function.
>
> That should read MSSQL has a try_cast AND cast function.
>
> Bob S
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Also looking for MSSQL integration person

[Skip Kimpel via use-livecode]

Actually, just looked and another field that is nchar(10) is also receiving
the "?" result so it has nothing to do with the "max" parameter.


SKIP

On Mon, Jul 26, 2021 at 6:54 PM Skip Kimpel  wrote:

> I think it is how I have everything setup something is getting lost in
> translation.  Keep in mind it is only two fields I am getting the "?"
> results back instead of the text contained inside.  The MSSQL data types of
> those two fields are: nvarchar(max).   Interestingly enough, I have other
> nvarchar fields coming through just fine but the difference is the "(max)"
> piece.
>
> It is a Azure SQL server and because I have not been able to figure out
> how to do a direct connection to it, I am using an ODBC connector with
> 32/64-bit ODBC Driver 13 for SQL server.
>
> Does this help at all?  I went through all the encoding types but they all
> failed using the textEncode when I say fail, I mean not the desired
> result.
>
> Maybe I hone in on the "max" piece of that code??
>
>
> SKIP
>
> On Mon, Jul 26, 2021 at 5:01 PM Paul Dupuis via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> I can't help you figure it out, but text coming through as questions
>> marks is almost always and text encoding issue.
>>
>> For example, if the text is stored in the mySQL database as UTF8, then
>> after fetching it in LiveCode nd before placing it in a field, you need
>> to textDecode(,"UTF8") (see the textDecode
>> dictionary entry)
>>
>> If you are going the other way, text entered into a LiveCode field needs
>> to be textEncode(,"UTF") before storing in the database.
>>
>> You need to either look up what encoding you table(s) are using or set
>> the encoding of the table(s) in the database to what you want and then
>> perform the appropriate textEncode or textDecode operations in LC
>>
>>
>>
>> On 7/26/2021 4:44 PM, Skip Kimpel via use-livecode wrote:
>> > I have MSSQL data flowing into my project but two data input fields are
>> > coming through as "?" instead of the actual text.
>> >
>> > WIlling to pay someone to help me figure this out.
>> >
>> > Please contact me directly at s...@magicgate.com
>> >
>> >
>> > Thank you!
>> >
>> > SKIP
>> > ___
>> > use-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: Also looking for MSSQL integration person

[Skip Kimpel via use-livecode]

I think it is how I have everything setup something is getting lost in
translation.  Keep in mind it is only two fields I am getting the "?"
results back instead of the text contained inside.  The MSSQL data types of
those two fields are: nvarchar(max).   Interestingly enough, I have other
nvarchar fields coming through just fine but the difference is the "(max)"
piece.

It is a Azure SQL server and because I have not been able to figure out how
to do a direct connection to it, I am using an ODBC connector with
32/64-bit ODBC Driver 13 for SQL server.

Does this help at all?  I went through all the encoding types but they all
failed using the textEncode when I say fail, I mean not the desired
result.

Maybe I hone in on the "max" piece of that code??


SKIP

On Mon, Jul 26, 2021 at 5:01 PM Paul Dupuis via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I can't help you figure it out, but text coming through as questions
> marks is almost always and text encoding issue.
>
> For example, if the text is stored in the mySQL database as UTF8, then
> after fetching it in LiveCode nd before placing it in a field, you need
> to textDecode(,"UTF8") (see the textDecode
> dictionary entry)
>
> If you are going the other way, text entered into a LiveCode field needs
> to be textEncode(,"UTF") before storing in the database.
>
> You need to either look up what encoding you table(s) are using or set
> the encoding of the table(s) in the database to what you want and then
> perform the appropriate textEncode or textDecode operations in LC
>
>
>
> On 7/26/2021 4:44 PM, Skip Kimpel via use-livecode wrote:
> > I have MSSQL data flowing into my project but two data input fields are
> > coming through as "?" instead of the actual text.
> >
> > WIlling to pay someone to help me figure this out.
> >
> > Please contact me directly at s...@magicgate.com
> >
> >
> > Thank you!
> >
> > SKIP
> > ___
> > use-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

Also looking for MSSQL integration person

[Skip Kimpel via use-livecode]

I have MSSQL data flowing into my project but two data input fields are
coming through as "?" instead of the actual text.

WIlling to pay someone to help me figure this out.

Please contact me directly at s...@magicgate.com


Thank you!

SKIP
___
use-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

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

[Skip Kimpel via use-livecode]

I have a project on my plate that needs some assistance with an API
integration.  Need some help kicking it off and getting
everything connected... from there on out, I can make the "calls" but need
the initial assistance.

Anybody interested in taking this on?  Obviously I will pay you for your
work.  You can contact me directly at s...@magicgate.com.

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

Problems with text data fields pulling from SQL

[Skip Kimpel via use-livecode]

I am pulling data from an Azure MS SQL database using an ODBC connection.
All data comes across just fine EXCEPT for data with field types of
NVARCHAR(Max).

When those fields arrive to LC, it shows up as a question mark "?".

Any reason why this would happen?   Any resolution to this?

Best regards,

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: MP3 ID3 tag writer

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PWD="&tDatabasePassword&"")
> >>> 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

[Skip Kimpel via use-livecode]

;
>>
>>
>> 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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PW
>> D="&tDatabasePassword&"")
>> 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

[Skip Kimpel via use-livecode]

vecode <
> 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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PW
> D="&tDatabasePassword&"")
> 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

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

Re: Livecode and AWS Sql

[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 to an AWS Sql instance?  I am using some of

Re: Livecode and AWS Sql

[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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PW
>> D="&tDatabasePassword&"

Re: Livecode and AWS Sql

[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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PW
> D="&tDatabasePassword&"")
> 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

[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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PW
> D="&tDatabasePassword&"")
> 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

[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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PW
>> D="&tDatabasePassword&"")
>> 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

[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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PW
> D="&tDatabasePassword&"")
> 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

[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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PWD="&tDatabasePassword&"")
> 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

[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="&myServerAddress&";DATABASE="&myDB&";UID="&tDatabaseUser&";PWD="&tDatabasePassword&"")
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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

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

[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

[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

[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

[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

[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

[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
> >
> >  "John Doe"
> >  "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

[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&t=28731&p=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

[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

[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

[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

[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

[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

[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

[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

[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