arrays with merge

[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 Jun 2015, at 10:13, Ali Lloyd <ali at runrev.com> wrote:
> 
> 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 to build the correct string