Razzak, I just traced the code again and when using the buttons the vchoice string ends up WHERE OrderHeader.Control# IN (020402ga,020411ne,020416ks) and gives me the error and does not print the report.
It dose not like the "OrderHeader." Part of the result evidently. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, February 05, 2010 12:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Interesting Error message At 12:39 PM 2/5/2010, Jim Belisle wrote: >Using the latest 7.6 RBASE. >Below is the code I use to bring up the WHERE builder for the >OrderHeader table. This will print a report based of course >on the WHERE clause. > >SET ERROR MESSAGE 2045 OFF >CHOOSE vchoice FROM #WHERE IN OrderHeader >SET VAR vcount INTEGER = 0 >SELECT COUNT (*) INTO vcount IND vin0 FROM OrderHeader &vchoice >IF vcount > 0 THEN > PRINT KPRPartNeedIrv2010 &vchoice >ELSE >Etc, etc > >If we type in the column name Control# IN (etc,etc) the report >prints to the screen as it should. If we use the WHERE builder >buttons (double clicking on the columns we want to use) this >error comes up: > >'Correlation OrderHeader not found ERROR 2366.' What is the Build of R:BASE 7.6? What is the resulting string (command/syntax) for "vChoice"? To review, either TRACE or BREAK (RETURN) the routine before PRINTing the report and see the resulting string. Carefully reading the string should provide you with some Blue's Clues... Very Best R:egards, Razzak.
