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> 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> 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
>> 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/>
> Software development services
> Bespoke application development for vertical markets
>
> mergExt <http://mergext.com/> - There's an external for that!
>
> _______________________________________________
> use-livecode mailing list
> use-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
