array and revExecuteSQL
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  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.
> On May 8, 2019, at 02:47 , Ludovic THEBAULT via use-livecode <use-livecode at lists.runrev.com> wrote:
> 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
> i’ve some bug with first syntax.
> Thanks for your light !
More information about the Use-livecode