Hi, There is no Query action, the query is the resulting SQL statement from a Search action or DirectDBMS. or in other words this is the sql statement sent to the database.
Actually, the column name "SelectionItemNumber" is greater that 18 characters You can rename this column and the fix the common.tcf to reflect the change Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-witango-talk@;witango.com] On Behalf Of Fogelson, Steve Sent: Friday, October 18, 2002 1:14 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: StoreFront to Oterro/R:Base 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
