Selection set problem using -rx

Ray Scheel ray.scheel at wsdtx.org
Thu May 27 11:24:37 PDT 2004


I'm having inconsistent results with a pair of selection sets which use @px
and @py.  

In my test area, using copies of the source (@yr) key, data, and map I
copied from production a few days ago, everything selects correctly and I
get the results I expect.

Today, when I moved this set of files into production, two of the four quit
selecting, even though all are called from the same shell script in the same
manner and have the relevant fields (year and month) in the same spots. 

I can't figure out what might be causing the selection failure on only 2
tables and only on one machine.  The only consistent theme I've found is the
two that work have "_tea" in the name of the table and are the last two
files in the loop I have running this processing.  

The point of the processing involved is to rebuild the raw information in
the monthly qualifiers after the end of the month processing is complete so
they contain the reconciled data placed in yr from the working month file.

Relevant info:

Production
Filepro: 5.0.00/5.0.11aR4
Linux tyler 2.4.20-6smp #1 SMP Thu Feb 27 09:59:40 EST 2003 i686 i686 i386
GNU/Linux 

Test machine
Filepro: 04.08.00/5.0.11aR4 
Linux fpdev 2.4.20-20.8 #1 Mon Aug 18 14:59:07 EDT 2003 i686 i686 i386
GNU/Linux

Selects nothing:
/appl/fp/rreport att_cla -fp yr_to_month -s yr_to_month -m yr -u -rx 03 -ry
2004
(As written, this never hits report processing. It will work if specify a
selection set where the passed values are instead "hard coded" in the set,
and processing then "sees" the passed values, so its only the selection set
not working as expected.)

Selects as expected:
/appl/fp/rreport att_cla_tea -fp yr_to_month -s yr_to_month -m yr -u -rx 03
-ry 2004

Syntax from calling script when running automated (note only att_stu and
att_cla fail to select):
cp_files()                    #/**** copy yr records to qualifier
{
   for i in att_stu att_cla att_cla_tea att_tea_plan
   do
      $dir $i -m $month -k -l     #/**** kill existing qualifier
      $fp $i -fp yr_to_month -s yr_to_month -m yr -u -rx $month -ry $year
   done                            #/**** rebuild monthly qualifier
}


::::::::::::::
att_cla/map
::::::::::::::
unitcd ; code of unit:  2:allup:
clanum ; number of class on unit:  5:.0:
year ; year of record:  4:.0:
month ; month of record:  2:allup:
clacd ; code of class: 11:allup:
syscd ; system code for class:  1:allup:
...

::::::::::::::
att_cla_tea/map
::::::::::::::
unitcd ; code of unit:  2:allup:
teacd ; teacher code:  5:allup:
year ; year of record:  4:.0:
month ; month of record:  2:#:
clanum ; class number:  5:.0:
lname ; teacher lastname: 15:allup:
fname ; teacher firstname: 12:allup:
...

::::::::::::::
att_cla/sel.yr_to_month
::::::::::::::
:4:eqf:@px
:3:eqf:@py

::::::::::::::
att_cla_tea/sel.yr_to_month
::::::::::::::
:4:eqf:@px
:3:eqf:@py

-rw-------    1 filepro  sys         59392 May 27 09:42 att_cla/index03.A
-rw-------    1 filepro  sys         21504 May 27 09:42 att_cla/index03.B
-rw-------    1 filepro  sys         17408 May 27 09:42 att_cla/index03.C
-rw-------    1 filepro  sys         24576 May 27 09:42 att_cla/index03.D
-rw-------    1 filepro  sys         55296 May 27 09:42 att_cla/index03.E
-rw-------    1 filepro  sys        167936 May 27 12:17 att_cla/indexyr.A
-rw-------    1 filepro  sys         47104 May 27 12:17 att_cla/indexyr.B
-rw-------    1 filepro  sys         40960 May 27 12:17 att_cla/indexyr.C
-rw-------    1 filepro  sys         92160 May 27 12:19 att_cla/indexyr.D
-rw-------    1 filepro  sys        160768 May 27 12:17 att_cla/indexyr.E
-rwxrwxrwx    1 filepro  sys        397684 Apr  2 09:05 att_cla/key03
-rwxrwxrwx    1 filepro  sys       1190308 May 25 12:10 att_cla/keyyr
-rwxrwxrwx    1 filepro  csd          1288 Oct 28  2003 att_cla/map
-rwxrwxrwx    1 filepro  sys          1724 May 27 11:30
att_cla/prc.yr_to_month
-rwxrwxrwx    1 filepro  sys            63 May 21 14:18
att_cla/sel.yr_to_month
-rw-------    1 filepro  sys        478208 May 27 09:43
att_cla_tea/index03.A
-rw-------    1 filepro  sys        366592 May 27 09:43
att_cla_tea/index03.B
-rw-------    1 filepro  sys       1342464 May 25 12:11
att_cla_tea/indexyr.A
-rw-------    1 filepro  sys       1103872 May 27 11:51
att_cla_tea/indexyr.B
-rwxrwxrwx    1 filepro  sys       1056078 Apr  2 09:05 att_cla_tea/key03
-rwxrwxrwx    1 filepro  sys       3171924 May 25 12:11 att_cla_tea/keyyr
-rwxrwxrwx    1 filepro  csd           387 Nov 12  1998 att_cla_tea/map
-rwxrwxrwx    1 filepro  sys          1724 May 27 10:52
att_cla_tea/prc.yr_to_month
-rwxrwxrwx    1 filepro  sys            63 May 26 16:05
att_cla_tea/sel.yr_to_month


Ray Scheel               ray.scheel at wsdtx.org 
Windham School District     Computer Services
Programmer                       936-291-5206 


More information about the Filepro-list mailing list