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.
