Steve, I wonder about the column named ID. ID may be a reserved word in R:Base, short for IDENTIFIED BY.
Bill On Fri, 18 Oct 2002 15:14:18 -0500, Fogelson, Steve wrote: >Troy, > >Thanks for the quick response. It is a query action in a method, not a >direct dbms action. > >Do quety actions have trouble with syntax sometimes. > >Thanks > >Steve > >-----Original Message----- >From: Troy Sosamon [mailto:tsosamon@;eapintl.com] >Sent: Friday, October 18, 2002 2:56 PM >To: Multiple recipients of list witango-talk >Subject: RE: Witango-Talk: StoreFront to Oterro/R:Base > > >Is this a direct dbms action? >I have found that sometimes on the direct dbms actions if the command is on >multiple lines and the where clause has parens in it, it will cause an >error. >Try putting the entire command on one line. > >Troy Sosamon > >===== Original Message from [EMAIL PROTECTED] at 10/18/02 1:32 pm >>Thanks for the help so far in porting this to R:Base. Making some progress. >> >>I am running into syntax errors in some querys. Error is below. >> >>[Search Action] [183] ShowProductSelector >>[Query] [183] SELECT >> D1.Namex,D1.ID,D1.SelectionItemNumber,D2.ItemNumber,P3.Namex, P3.ID FROM >>Department D1,DepartmentProducts D2,Product P3 WHERE (D1.SelectionList<>0 >>AND D1.Disabled=0 AND P3.Disabled=0) AND ((D1.ID=D2.DepartmentID) AND >>(P3.ID=D2.ProductID)) ORDER BY 3 ASC,4 ASC >>[Error] [183] 2367 [RBTI][Oterro ODBC Driver][Store]-ERROR- Syntax error >>(2367) 37000 >>[Error] [183] -101 General error during data source operation. >>[Error] [300] [Microsoft][ODBC Driver Manager] Function sequence error >S1010 >> >> >>Anybody see anything I should check. I must be missin gthe obvious. >> >>Thanks >> >>Steve Fogelson >>Internet Commerce Solutions >> __________________________________________________________ ______________ >>TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body > >_________________________________________________________ _______________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body >_________________________________________________________ _______________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body