Thanks Troy ----- Original Message ----- From: "Troy Sosamon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, August 28, 2004 1:04 PM Subject: [RBG7-L] - RE: Mimer SQL for developers
> 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 >
