Choose is not a SQL command. It is an R:base specific command. Select, insert, update, delete, and alter are all SQL commands.
Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Saturday, August 28, 2004 10:57 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Mimer SQL for developers 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
