Finding blank date field

M

markc

New Member
My Progress (8.3C) programming skills are limited so hopefully my question is an easy one for more experienced programmers. I am trying to create a report that would look for an empty date field then display the associated job number. Our RMA screen has a Closed field that a date is entered when an RMA is completed. The report is looking for uncompleted RMA jobs that have an empty closed date field. The field schema is rmaitem.datefld. I have tried FOR EACH rmaitem where rmaitem.datefld = NULL: or FOR EACH rmaitem where rmaitem.datefld = " ": and also tried FOR EACH rmaitem where rmaitem.datefld = / / : . I have even tried FOR EACH rmaitem where rmaitem.datefld = _ _ / _ _ / _ _ _ _: . I receive a syntax error for each of the above.

If I do the following:

FOR EACH rmaitem:
DISPLAY rmaitem.rma-num
rmaitem.datefld with stream-io.
END.

The display will list dates and RMA number with an occassional blank spot designating an empty date field. I do not know what is used to represent the blank field in order to query. I could use the above small program but I would rather just display only the RMA with blank datefields.
Thanks for any advice!
 
markc said:
My Progress (8.3C) programming skills are limited so hopefully my question is an easy one for more experienced programmers. I am trying to create a report that would look for an empty date field then display the associated job number. Our RMA screen has a Closed field that a date is entered when an RMA is completed. The report is looking for uncompleted RMA jobs that have an empty closed date field. The field schema is rmaitem.datefld. I have tried FOR EACH rmaitem where rmaitem.datefld = NULL: or FOR EACH rmaitem where rmaitem.datefld = " ": and also tried FOR EACH rmaitem where rmaitem.datefld = / / : . I have even tried FOR EACH rmaitem where rmaitem.datefld = _ _ / _ _ / _ _ _ _: . I receive a syntax error for each of the above.

If I do the following:

FOR EACH rmaitem:
DISPLAY rmaitem.rma-num
rmaitem.datefld with stream-io.
END.

The display will list dates and RMA number with an occassional blank spot designating an empty date field. I do not know what is used to represent the blank field in order to query. I could use the above small program but I would rather just display only the RMA with blank datefields.
Thanks for any advice!
Click to expand...

Hi Mark,

You were in the right direction. In progress null is represented by a question mark (?).

Try this -

Code: 
for each  RMAItem 
    where RMAItem.DateFld = ? /* null */
    no-lock: /* remember to add no-lock for the buffer, if there are no updates and/or locking isn't desired */

    display
        RMAItem.ItemNum
        RMAItem.DateFld.

end. /* each */
Hope this helps.
 
You must log in or register to reply here.
Back
Top