Hi,

I have sample procedure, It is like below

--------------------------------------------------------------
DEFINE FILE CAR
DATE_VAR/YYMD=DATEADD('20121230','D',-1);
END

TABLE FILE CAR
PRINT DATE_VAR *
END
-RUN
--------------------------------------------------------------

In the second statement when I remove *, It does not return anything, It is not able to return only DATE_VAR defined variable.
If I return with * or any other column, It works fine.

Any one have idea about other workout, My requirement is to only return DATE_VAR.

Note: DATE_VAR in this case is static, but it will be coming from File in real.

Thanks,

This message has been edited. Last edited by: <Kathryn Henning>,

You should see this error message:

(FOC493) NO ACCESSIBLE FIELDS ARE MENTIONED IN THE REQUEST

This means that no real columns were specified in the DEFINE or the report.

Try the following:

DEFINE FILE CAR
DATE_VAR/YYMD WITH COUNTRY=DATEADD('20121230','D',-1);
END

TABLE FILE CAR
PRINT DATE_VAR 
END
-RUN

Or the following:

DEFINE FILE CAR
DATE_VAR/YYMD=DATEADD('20121230','D',-1);
END

TABLE FILE CAR
PRINT 
COUNTRY NOPRINT
DATE_VAR 
END
-RUN

If you're expecting only one row in the report, you will have to add WHERE RECORDLIMIT EQ 1

Thanks, Francis

That is helpful.

Thanks again,