arrays with merge

[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 <terry.heaford at me.com> wrote:
> 
> 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 <monte at sweattechnologies.com <mailto:monte at sweattechnologies.com>> wrote:
>> 
>> Add a space between the array bracket and the merge brackets
>> 
>>> On 5 Jun 2015, at 4:27 pm, Terence Heaford <t.heaford at icloud.com <mailto:t.heaford at icloud.com>> 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 &?
>>> 
>>> All the best
>>> 
>>> Terry
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>
>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> --
>> M E R Goulding <http://goulding.ws/ <http://goulding.ws/>> 
>> Software development services
>> Bespoke application development for vertical markets
>> 
>> mergExt <http://mergext.com/ <http://mergext.com/>> - There's an external for that!
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>