I have never had a problem with the query action, but I have started using the direct dbms more and more. With the direct dbms actions, I can cut the command out of my R:base code and paste it into the direct dbms and not have to re-type it.
I have a feeling that Ben's or Bill's answer or both may solve your problem. I am sure ID is a reserved word (might cause a problem), and column names can not be over 18 chars (defiantly cause a problem). Troy ===== Original Message from [EMAIL PROTECTED] at 10/18/02 2:14 pm >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
