How Does This Work?

[John Hemmer]

----- Original Message ----- 
From: "Doug Luurs" <doug at borisch.com>
To: "John Hemmer" <hemmerjohn at hotmail.com>
Sent: Wednesday, May 25, 2005 11:32 AM
Subject: RE: How Does This Work?


If:  MY le MO  and  YR eq mid(NO,"4","2")
                             ^^^^^^ --- MO ?
  
Hope that's a Typo ..  That's would be why ... 

-------------------------------------------------------------

Doug,


It's a Typo... It actually is:

If:  MY le MO  and  YR eq mid(MO,"4","2")
                                                     -----
Thanks,

John


-----Original Message-----
From: filepro-list-bounces+doug=borisch.com at lists.celestial.com
[mailto:filepro-list-bounces+doug=borisch.com at lists.celestial.com] On
Behalf Of John Hemmer
Sent: Wednesday, May 25, 2005 10:52 AM
To: 'filePro mailing list'
Subject: How Does This Work?


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

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list

-------------------------------------------------------------

Doug,


It's a Typo in my email message... 

I actually changed the processing line to:

If:  MY le MO  and  YR eq mid(MO,"4","2")
                                                     -----
Thanks,

John