array and revExecuteSQL

Bob Sneidar bobsneidar at iotecdigital.com
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 lists.runrev.com> 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