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
