Selection date question
Don Coleman
dcoleman at dgcreact.com
Fri Feb 18 13:08:02 PST 2005
I have a series of reports (3) different menu selections which function
as follows:
DPRODIR -K to remove previous selection criteria
*CLERK to add 19 different selction criteria (2 date fields and 17 YESNO
fields)
*REPORT to post data from an archive file to a temporary posting file
*REPORT to post data from a working file to the same temporary posting file
*REPORT to print the data with data combined from the archive and
working files
The archive and working files have identical maps. Their only
difference is the archive file contains orders processed previously.
The working file contains only open orders and those orders processed on
a given day are archived each night. The data posting and reports
function as designed. However, since I am processing from multiple
files I had to post the date range fields to a control file and could
not simply use -R to pass the parameter.
Originally, only one person was running these reports. Now however,
more than one person is running them and I am concerned that before one
process is completed another person will start another process with
different selection criteria (-V table). Hence the second person
running the report could affect the results of person #1 running their
report depending on where in the process person #1 was. Does anyone
have any suggestions for isolating the record being used for one person
only short of something like this:
Menu selection #1 posts to record #1 in control file
Menu selection #2 posts to record #2 in control file
...
This method would not work well for two people running the same report
at the same time. I would appreciate any better ideas. Thanks and have
a good weekend.
Don Coleman
More information about the Filepro-list
mailing list