Kbase P40302: Missing quotes causes error "RB-FILTER contains an error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/09/2003 |
|
Status: Unverified
SYMPTOM(s):
REPORT BUILDER Syntax Error: "RB-FILTER contains an error at offset nnn: unrecognized name or operator"
Using Report Builder.
CAUSE:
The RB-FILTER condition is making a comparison with a character constant that is not between quotes.
FIX:
Add quotes to the constant you are assembling for the Report Builder filter:
Example:
RUN aderb/_printrb.p("c:\Progress\Wrk\reports.prl", /* RB-REPORT-LIBRARY */
"Report1", /* RB-REPORT-NAME */
"", /* RB-DB-CONNECTION */
"O", /* RB-INCLUDE-RECORDS */
"Customer.state = 'MA'", /* RB-FILTER (note the single quotes) */
"", /* RB-MEMO-FILE */
"D", /* RB-PRINT-DESTINATION */
"", /* RB-PRINTER-NAME */
"", /* RB-PRINTER-PORT */
"", /* RB-OUTPUT-FILE */
0, /* RB-NUMBER-COPIES - zero */
0, /* RB-BEGIN-PAGE - zero */
0, /* RB-END-PAGE - zero */
no, /* RB-TEST-PATTERN */
"", /* RB-WINDOW-TITLE */
yes, /* RB-DISPLAY-ERRORS */
yes, /* RB-DISPLAY-STATUS */
no, /* RB-NO-WAIT */
""). /* RB-OTHER-PARAMETES */