Just a heads up that I encountered this problem yesterday. It only affects screens from what one of my lead developers told me as they came across it before and diagnosed it. It is now in our list of hints and tips.

Problems have been found in screens when comparing a previously read file variable against a file variable in an SQL statement if the variable has not been flagged as Auto Repeat.

E.g.

SQL

SELECT FROM WVSL700 WHERE WVSL700.DEALER_CODE = :DEALER_CODE

ENDSQL



If the file variable DEALER_CODE has been read in a previous characteristic but is either not used on the screen or not flagged as Auto Repeat then there is the chance that :DEALER_CODE will send a Null value to Oracle (Even though UMSGing it will report a value for DEALER_CODE).


The solution is to set a scratch variable to DEALER_CODE.