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