Field Not Found Error and Lookup

[Larry Dannenberg]

Hi,

 

Please help me with the following (hopefully) simple problem.

 

I am using filePro in a SCO Unix environment. I want to do a lookup on a
specific record number in the file MRiif (See line 34).

 

When I do this, I get the "Field not found " error message below. 

 

What field is filePro looking for in the error message shown below? The
field IS there as seen in the debug message I sent to the screen (below).

 

DEBUG MESSAGE TO SCREEN

    ┌─────────────────────────────────────────────────────────────────────┐

│ MRattenddays(32)sj=    2979   habfile(62)sv=    4382                │

│ Name= XXXXXX, JESSICA          Name= XXXXXX, JESSICA iif(5)=0910054 │

└───────────────────────────────────────────────────── Press  Enter   ┘

 

ERROR MESSAGE

*** A filePro Error Has Occurred ***

 

On File:

 

Input Processing

Line Number: 37

 

goto selct1

^

Field not found.

Lookup has not been performed.

 

CODE EXCERPT

 

31  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -  -

       . If: 'MRattenddays (32) corresponds to the habfile @rn           .

       Then: sj(8,.0)=32       'Field 32 in MRattenddays is a (5,.0) type.

 32  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

       . If: '@rn has 8 char                                             .

       Then: lookup hab = habfile  r=(sj)   -n                           .

 33  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

       . If: 'The IIF Link# (MRiif record #) is in hab(62)               .

       Then: sv(8,.0)=hab(62)                                            .

 34  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

       . If: 'relate MRatteddays to MRiif                                .

       Then: lookup iif = MRiif  r=(sv)   -n                             .

 35  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

***1   . If: 'DEBUG                                                      .

       Then: msgbox "MRattenddays(32)sj="&sj&"habfile(62)sv="&sv

&"\nName="<33{","<34&"  Name="<hab(1){","<hab(2)<"iif(5)="&iif(5)

 36  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -     .


    If: @SK eq "BRKY"                                               .

       Then: exit                                                        .

 37  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

       . If: iif(5) eq "0910036"                                         .

       Then: goto selct1                                                 .

 38  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

       . If: iif(5) eq "0910027"                                         .

       Then: goto selct1                                                 .

 39  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

       . If: iif(5) eq "0910241"                                         .

       Then: goto selct1                                                 .

 40  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

       . If: iif(5) eq "0910161"                                         .

       Then: goto selct1                                                 .

 41  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

       . If: iif(5) eq "0910198"                                         .

       Then: goto selct1 

 42  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -     .

    If:                                                             .

       Then: goto term1                                                  .

 43  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

selct1 . If: dd ge sd and dd le ed                                       .

       Then: select;end                                                  .

 44  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - -

term1  . If:                                                             .

       Then: close hab;close iif;end                                     .

 45  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   - .
If:'************************************************************.

       Then: '*****        SUBROUTINES                                   .

.

.

.

File: MRattenddays─────────────────────────────Processing: bylocdatemnseli

 

 

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

Larry Dannenberg

Butler County MRDD

155 Donald Drive

Fairfield, OH  45014

(513) 867-5962 ext. 35

HYPERLINK "mailto:debbies at butlermrdd.org"larryd at butlermrdd.org

HYPERLINK "http://www.butlermrdd.org"www.butlermrdd.org

 

 

CONFIDENTIALITY NOTE: This message is intended for use only by 
the individual or entity to which it is addressed and may contain 
information that is privileged, confidential, and exempt from disclosure 
under applicable law. If the reader of this message is not the intended 
recipient, or the employee or agent responsible for delivering this 
message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication or any 
attachments is strictly prohibited. If you have received this 
communication in error, please erase all copies of the message and its 
attachments and notify the sender immediately.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20050811/ce438995/attachment-0001.html