JWalker81
Active Member
In Dream Writer, we know we can use precede a field name with & in order to use that field name as a value in data selection.
Example, in the data selection screen I can enter:
Next status EQ &SDLTTR
to get records where the next and last statuses are equal. This works fine.
However, when we try to do this with two numeric fields that are defined identically in DD and both are data item class DATEW, we get a 'date field invalid or missing' message for the field name in the VALUE clause.
We know this is because of data editing as specified in F98301 (dream writer master parameters). If we make DEEC in F98301 blank, the DW will take the field name and it will run. However, we do not like the idea of having to go in and directly manipulate the file just to get functionality that should realistically be available from within the DW program itself. Nor do we want to change the data item class. Finally, we're uncertain that we will be able to use this method and get the expected result if we change the value to be calculated such as (SDDRQJ + 30) - although that will be our next test.
So, does anyone know of another way (the 'right' way?) to be able to directly use a numeric DATEW class field name as a value in DW data selection so that its value can be compared against another numeric DATEW class field?
Regards,
jw
World A7.3 cum:not really
Example, in the data selection screen I can enter:
Next status EQ &SDLTTR
to get records where the next and last statuses are equal. This works fine.
However, when we try to do this with two numeric fields that are defined identically in DD and both are data item class DATEW, we get a 'date field invalid or missing' message for the field name in the VALUE clause.
We know this is because of data editing as specified in F98301 (dream writer master parameters). If we make DEEC in F98301 blank, the DW will take the field name and it will run. However, we do not like the idea of having to go in and directly manipulate the file just to get functionality that should realistically be available from within the DW program itself. Nor do we want to change the data item class. Finally, we're uncertain that we will be able to use this method and get the expected result if we change the value to be calculated such as (SDDRQJ + 30) - although that will be our next test.
So, does anyone know of another way (the 'right' way?) to be able to directly use a numeric DATEW class field name as a value in DW data selection so that its value can be compared against another numeric DATEW class field?
Regards,
jw
World A7.3 cum:not really
