revDataFromQuery with variable list question

Terence Heaford t.heaford at btinternet.com
Sat Mar 15 12:38:40 EDT 2014


This would be my interpretation:


select "date","type","description","amount","balance","category","recID" from “MyTable" order by "date” asc


All the best

Terry
 
On 15 Mar 2014, at 16:16, Terence Heaford <t.heaford at btinternet.com> wrote:

> "Use single-quotes, not double-quotes, around string literals in SQL. This is what the SQL standard requires….
> SQL uses double-quotes around identifiers (column or table names) that contains special characters or which are keywords. So double-quotes are a way of escaping identifier names. Hence, when you say column1="column1" that is equivalent to column1=column1 which is obviously always true."




More information about the use-livecode mailing list