CHOOSE is not a SQL command, but an R:Base extension.
--- Bernard Lis <[EMAIL PROTECTED]> wrote:
> 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
>
>
=====
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
