arrays with merge

Terence Heaford t.heaford at icloud.com
Fri Jun 5 03:11:51 EDT 2015


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> 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> 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
>> 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode




More information about the Use-livecode mailing list