Re: arrays with merge

2015-06-05 Thread Terence Heaford
Also tried it with one space after array as put merge("SELECT [[tColumns]] FROM '[[tTable]]' [[myArray["test”] ]] [[tSortOrder]]") into tSQL Still got a syntax error. LC 6.7.5 Mac. Is there a solution? All the best Terry > On 5 Jun 2015, at 07:55, Terence Heaford wrote: > > Did this a

Re: arrays with merge

2015-06-05 Thread Terence Heaford
Did this and I still get a syntax error. put merge("SELECT [[tColumns]] FROM '[[tTable]]' [[ myArray["test”] ]] [[tSortOrder]]") into tSQL Any ideas Thanks Terry > On 5 Jun 2015, at 07:42, Monte Goulding wrote: > > Add a space between the array bracket and the merge brackets > >> On 5 Jun

Re: arrays with merge

2015-06-05 Thread Lyn Teyla
> Terence Heaford wrote: > > This line gives a syntax error, obviously because an array does not work in > merge? > > put merge("SELECT [[tColumns]] FROM '[[tTable]]' [[myArray["test"]]] > [[tSortOrder]]") into tSQL > > Is there a way around this or do I have to resort to using &? Method 1

Re: arrays with merge

2015-06-05 Thread Lyn Teyla
> function myArray pString > return myArrayTest[pString] > end myArray Small typo: myArrayTest[pString] should of course be: myArray[pString] ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscr

Re: arrays with merge

2015-06-05 Thread Ali Lloyd
Hi, The reason put merge("SELECT [[tColumns]] FROM '[[tTable]]' [[myArray["test"]]] [[tSortOrder]]") into tSQL doesn't work is the double quote around "test". Merge should work fine with arrays (I should know because bug 11274 was one of the first I ever fixed!) You can either use & and quote t

Re: arrays with merge

2015-06-05 Thread Terence Heaford
Interestingly it works without quotes around test. It does work but should it? This suggests the only reason for quotes in array keys is in case you have a two word key? put merge("SELECT [[tColumns]] FROM '[[tTable]]' [[myArray[test]]] [[tSortOrder]]") into tSQL All the best Terry > On 5

Re: arrays with merge

2015-06-05 Thread Ali Lloyd
Yes, that is LiveCode 'unquoted literal' mechanism - It is the same as, for example, (if you have strict compilation off) *put* tTest & "sdfsdf" -- puts tTestsdfsdf into the message box When a variable has not been declared, any tokens that are not keywords are treated as strings. On 5 June 20

Re: Clock

2015-06-05 Thread BNig
Roger, this is probably due to the limited processing power of the android-watch This is similar to iOS back when I made the scrollers. At the time iPhones had trouble mixing all the blend modes fast enough. So I build in a cheat. The command is "makeiOSReady" it is located in the script of the g

Re: Clock

2015-06-05 Thread Roger Eller
Wow, you really thought of everything. Thanks Bernd! I'll try this as soon as possible. ~Roger On Jun 5, 2015 5:39 AM, "BNig" wrote: > Roger, > > this is probably due to the limited processing power of the android-watch > > This is similar to iOS back when I made the scrollers. At the time iPh

Re: arrays with merge

2015-06-05 Thread Mike Bonner
As ali said, the unquoted key is only an issue if there is a declared variable, at which point the key becomes whatever is in that variable. (or if its a keyword of course) I use the "store the string elsewhere" method. When creating merge strings for later use, I either create them using the pro

RE: arrays with merge

2015-06-05 Thread Ralph DiMola
5,4,3,2,1 Here comes Peter with "Always use strict compilation mode" Followed by my +1 Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -Original Message- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Mike Bonner Sent:

RE: arrays with merge

2015-06-05 Thread Peter Haworth
Well I missed the countdown so I'll +1your post. Pete lcSQL Software On Jun 5, 2015 7:04 AM, "Ralph DiMola" wrote: > 5,4,3,2,1 Here comes Peter with "Always use strict compilation mode" > Followed by my +1 > > Ralph DiMola > IT Director > Evergreen Information Services > rdim...@evergreeninf

Re: arrays with merge

2015-06-05 Thread Dr. Hawkins
On Fri, Jun 5, 2015 at 7:31 AM, Peter Haworth wrote: > Well I missed the countdown so I'll +1your post. > and I'll +2. The things that I would most like to add to livecode would be strict compilation being the default, absolute case sensitivity (unless turned off for comparisons), and strong ty

Re: arrays with merge

2015-06-05 Thread Ali Lloyd
In that case I can highly recommend trying LiveCode Builder ;-) On 5 June 2015 at 16:13, Dr. Hawkins wrote: > On Fri, Jun 5, 2015 at 7:31 AM, Peter Haworth wrote: > > > Well I missed the countdown so I'll +1your post. > > > > and I'll +2. > > The things that I would most like to add to livecode

Re: LiveCode 8 and a new video player?

2015-06-05 Thread Richard Gaskin
Mark Talluto wrote: On Jun 4, 2015, at 5:06 PM, Richard Gaskin wrote: Besides, RunRev has already decided to support media playback on Linux. The only new question I'm raising here is whether it needs to wait for The Ultimate Widget, or could we please have a few lines of C++ to tide us over f

Re: arrays with merge

2015-06-05 Thread J. Landman Gay
On June 5, 2015 10:13:03 AM CDT, "Dr. Hawkins" wrote: > >The things that I would most like to add to livecode would be strict >compilation being the default, absolute case sensitivity (unless turned off >for comparisons), and strong typing of variables. Oh, and c-style >variable scoping. In that

Re: arrays with merge

2015-06-05 Thread Peter TB Brett
On 2015-06-05 17:22, Ali Lloyd wrote: On 5 June 2015 at 16:13, Dr. Hawkins wrote: On Fri, Jun 5, 2015 at 7:31 AM, Peter Haworth wrote: > Well I missed the countdown so I'll +1your post. > and I'll +2. The things that I would most like to add to livecode would be strict compilation being th

cant't find the textFont of formatted text?

2015-06-05 Thread Dr. Hawkins
inside of a loop through the fields, I have put thFld & cr & the formattedText of thFld \ & cr & exists(the textFont of word 1 to -1 of the formattedText of thFld) put the textFont of word 1 to -1 of the formattedText of thFld On a particular field, I get field id 3132 of stack "rawForms" Es

Re: cant't find the textFont of formatted text?

2015-06-05 Thread Mark Waddingham
On 2015-06-05 20:13, Dr. Hawkins wrote: inside of a loop through the fields, I have put thFld & cr & the formattedText of thFld \ & cr & exists(the textFont of word 1 to -1 of the formattedText of thFld) put the textFont of word 1 to -1 of the formattedText of thFld On a particular field, I

Simple .lc Script to INSERT data...?

2015-06-05 Thread JOHN PATTEN
Hi All, I must be missing something simple and I can’t find it… I have a mysql database with one table and one field. Varchar(1000) I have a LiveCode project with one button and the following code: on mouseUp put urlEncode(the name of target) into tName put "object_name=" & tName into Arg

Re: Simple .lc Script to INSERT data...?

2015-06-05 Thread Matthias Rebbe | M-R-D
John, if you post data to a livecode server script then you need to use $_post[] instead of $_get $_get[] is used if you add the parameters to the url like put URL ("http://username.on-rev.com/ipad_1/add_datga_2.lc?object_name=“ & tName) into tResult Regards, Matthias > Am 06.06.2015 um

Re: Simple .lc Script to INSERT data...?

2015-06-05 Thread JOHN PATTEN
Thanks Matthias, I did try both ways $_POST and $_GET. I get the same results; a new record is created but the fields are empty. By the way, the "LiveCode Cloud" tutorials show $_POST for inserting new record too. I’ll keep looking :) > On Jun 5, 2015, at 3:39 PM, Matthias Rebbe | M-R-D >

Re: Simple .lc Script to INSERT data...?

2015-06-05 Thread Mike Bonner
You're putting your data to post into ArgList And you're posting tArgList If thats not a typo here, I suspect its the typo culprit there. On Fri, Jun 5, 2015 at 5:01 PM, JOHN PATTEN wrote: > Thanks Matthias, > > I did try both ways $_POST and $_GET. I get the same results; a new > record is cr

Re: cant't find the textFont of formatted text?

2015-06-05 Thread Dr. Hawkins
On Fri, Jun 5, 2015 at 11:20 AM, Mark Waddingham wrote: > > The 'formattedText' property of a field is a string so the expression: > the textFont of word 1 to -1 of the formattedText of thFld > > Does this: > T1 = evaluate the formattedText of thFld > T2 = word 1 to -1 of T1 > return the

Re: LiveCode 8 and a new video player?

2015-06-05 Thread Kay C Lan
This is probably thread drift but video playback is so 20th century. I had an old acquaintance pass through town and we caught up. He's working for a start up that's doing something similar to Google Glass. He had a demo unit to show me. The googles worked with any users phone (or iPod touch) but

Re: "breakpoint" gets edited out of cut/paste in IDE?

2015-06-05 Thread Kay C Lan
Defintely not! I use hard breakpoints almost exclusively and copy and paste scripts from one object to another within the same stack as well as to different stacks altogether on a regular basis and I've never seen this. I'm currently on OS X 10.9.5 LC 6.6.5 and 7.0.5 but I've been copying and pas