I am trying to create simple Flex Business rule. I am trying to force the usage of Closing Codes if user is trying to close "Breakdown" type of work. SQL querry (which does not work) is: SELECT NULL
FROM R5EVENTS
WHERE EVT_SQLIDENTITY =:ROWID
AND EVT_JOBTYPE = 'BRKD'
AND EVT_TYPE = 'JOB'
AND EVT_STATUS='C'
AND (EVT_REQM IS NULL
OR EVT_FAILURE IS NULL
OR EVT_CAUSE IS NULL
OR EVT_ACTION IS NULL) Thsi one triggers on any update of R5EVENTS table (WO insert/updates, new Positions etc.) What am I doing wrong? Can somebody pls advise me...
Try putting in a error condition
SELECT count(*) into some_field
FROM R5EVENTS
WHERE EVT_SQLIDENTITY =:ROWID
AND EVT_JOBTYPE = 'BRKD'
AND EVT_TYPE = 'JOB'
AND EVT_STATUS='C'