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