array and revExecuteSQL

Bob Sneidar bobsneidar at
Mon May 13 11:07:26 EDT 2019

No because the array form uses a substitution method for SQL statements like "custom = ':1'" the :1 being replaced by the contents of tArray [1] when the SQL statement is assembled. I don't think you can use ":lattitude" in the select statement, but that would be an SQL limitation not an LC one. 

Bob S

> On May 8, 2019, at 02:47 , Ludovic THEBAULT via use-livecode <use-livecode at> wrote:
> hello
> when you use array with revExecuteSQL like :
> revExecuteSQL, dbID, tSQL, "tarray"
> can we use array wth keys as text and not number :
> tarray["latitude"] vs tarray[1]
> i’ve some bug with first syntax.
> Thanks for your light !

More information about the use-livecode mailing list