Razzak, The build is 7.6.8.30111. The string for vchoice is WHERE Control# IN (020402ga,020411ne,020416ks). This is what it should be.
As I mentioned, if I type everything into the WHERE builder, all works fine. It only gives me the error when I double click on the buttons and it brings up OrderHeader.Control# IN (etc,etc,etc,) 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.
