Error 'Unable to understand after...OR (247) when Using AND OR Selection Criteria in Reports

Error 'Unable to understand after...OR (247) when Using AND OR Selection Criteria in Reports

Article summary

Did you find this summary helpful?

Thank you for your feedback

When using AND OR Selection Criteria in reports, the following errors can occur:

'Unable to understand after...'= ) OR (247)'
'Cannot understand expression involving OR operator. (247)'
'n:\found\fims\src\template\presict.i line 89..Invalid FOR, DO, REPEAT, or EDITING statement. (194)'

The errors occur if you have an OR clause across database tables.
You can have ANDs between database tables but you cannot have ORs.
Bracket placement will also impact the results and too many brackets or brackets placed in the wrong area can cause these errors to occur as well.

Was this article helpful?