There is a web site: developer.mimer.com/validator
That you can use to test your SQL statements.
I keyed in "choose xx from tblname" (without the quotes)
and got:
choose xx from tblname
^---
syntax error: from tblname
correction: JOIN tblname
^
syntax error: <end>
expected: . { <ascii identifier> <delimited identifier> <identifier>
<unicode identifier> AS CROSS FULL INNER JOIN LEFT NATURAL ON
RIGHT TABLESAMPLE USING UNION
correction: ON <identifier> <end>
So is our use of the choose statement non-standard sql?
I tried choose xx from #values for (a & b) from tblname
it doesn't recognize the # values or the for
So I am guessing these are R:Base extensions.
comments requested!
Bernie Lis
