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.heaf...@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." _______________________________________________ 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
