How Does This Work?

John Hemmer hemmerjohn at hotmail.com
Wed May 25 07:51:59 PDT 2005


I have run into a -v selection process that has me stumped.

The command line invoking the selection process is:

dreport database -f dummya -a -v pcbh -z process - "pc by bh" -p /dev/null

              prc.dummya does not exist,  out.dummya does exist.


(1)  A process named prc.pc has a line of code as follows

                 If:  MY le MO  and  pcbh  and  YR eq mid(MO,"4","2")
           Then: select

       MY is mm/yy  for example  03/05   and    MO is 05/05.  YR is a 2
digit
       year for example 03, 04 or 05 and MID(mo,"4","2") is 05.   pcbh  is
not
       defined anywhere in the selection process.  There is no processing
table
       named automatic (this is a SCO Unix system).

        Records do get selected.


(2)  When I remove  'and pcbh'  from the processing line and change it to
..

                 If:  MY le MO  and  YR eq mid(NO,"4","2")
           Then: select

        No Records get selected.

How does the first selection line work?

TIAA

John



More information about the Filepro-list mailing list