Skip to content

Hints on cursors

Invalid condition in WHERE clause

Editor provides errors for common typing mistakes in cursor where clause, such as <column> <operator> <column> where operator can be “=”, “!=”, “<>”, “>=”, “>”, “<=”, “<”.

Example of Incorrect Code:

CURSOR get_allocations IS         
    SELECT *         
    FROM &TAB_MAT_ALLOC         
    WHERE sequence_no = sequence_no       
    AND (qty_required - qty_issued) > 0;

Example of Correct Code:

CURSOR get_allocations IS         
    SELECT *         
    FROM &TAB_MAT_ALLOC         
    WHERE sequence_no = sequence_no_       
    AND (qty_required - qty_issued) > 0;

Actions Available:

  • Add an IgnoreCursorWhereClause.

This page is generated from IFS Developer Studio - for latest update, see help pages in the tool itself.