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