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.heaf...@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 <mo...@sweattechnologies.com
>> <mailto:mo...@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.heaf...@icloud.com
>>> <mailto:t.heaf...@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@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
>>
>> --
>> 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@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
