i have created a table named account (accountno,date,balance) and inserted some values into it.
date column has some null values.
if i use select statement like
SELECT BALANCE,OPENDATE INTO :WS-BAL,:WS-OPENDATE
FROM ACCOUNT WHERE ACCOUNTNO = :WS-ACCOUNTNO
the above code doesnot work for the null values and the above code works fine for non-null values
what is the solution to retreive null values?