Associated Fields

George Simon GSimon at americanriverintl.com
Tue Dec 30 07:54:14 PST 2008


  

Just came across this in filePro SCO Unix rclerk version 05.0.08R4

 

Browse format screen looks something like this:

 

Control #        Date               Receipt No.   Stat     Consignee
Rec. No.

*800               *@c4              *a1                  *b1      *999
*@rn

 

Here is the problem.  When in IUA looking using an index built on field
a1, a1 shows the correct value for each instance of the associated
fields but b1 shows only the value of the first instance of associated
field a1.  So the browse screen looks like this:

 

Control #             Date          Receipt No.   Stat     Consignee
Rec. No.

        235         12/30/2008           1000.0       R       EUROSPORTS
RIMS                   1

        235         12/30/2008           1010.0       R       EUROSPORTS
RIMS                   1

        235         12/30/2008           1020.0       R       EUROSPORTS
RIMS                   1

        235         12/30/2008           1030.0       R       EUROSPORTS
RIMS                   1

        235         12/30/2008           1040.0       R       EUROSPORTS
RIMS                   1

        235         12/30/2008           1050.0       R       EUROSPORTS
RIMS                   1

        235         12/30/2008           1060.0       R       EUROSPORTS
RIMS                   1

 

When it should look something like this:

 

Control #             Date          Receipt No.   Stat     Consignee
Rec. No.

        235         12/30/2008           1000.0       R       EUROSPORTS
RIMS                   1

        235         12/30/2008           1010.0       O       EUROSPORTS
RIMS                   1

        235         12/30/2008           1020.0       O       EUROSPORTS
RIMS                   1

        235         12/30/2008           1030.0       O       EUROSPORTS
RIMS                   1

        235         12/30/2008           1040.0       O       EUROSPORTS
RIMS                   1

        235         12/30/2008           1050.0       O       EUROSPORTS
RIMS                   1

        235         12/30/2008           1060.0       O       EUROSPORTS
RIMS                   1

 

Has anyone seen this behavior before?  Is it a bug or am I doing
something wrong?  Or am I expecting filePro to do something it cannot?

 

Why does it display the correct value for associated field a1 but the
incorrect one for associated field b1?

 

George Simon - Sr. Programmer

American River International

908-354-7746 Ext. 103

http://www.americanriverintl.com/ <http://www.americanriverintl.com/> 

 

 

This email and any attachments contain confidential, private and/or
proprietary information intended specifically for the recipients named
in this email. If you are not an intended recipient, or are
inadvertently/incorrectly named as a recipient above, please note that
any use, dissemination, or distribution of this email or attachments is
strictly prohibited. If you have received this email in error, we
sincerely apologize and ask that you please notify the sender at
908-354-7746 Ext. 103 and promptly and permanently delete this email
from your computer and destroy any printed copies. Thank you in advance
for your cooperation.

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20081230/8ae44a0c/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 2950 bytes
Desc: image001.jpg
Url : http://mailman.celestial.com/pipermail/filepro-list/attachments/20081230/8ae44a0c/attachment.jpe 


More information about the Filepro-list mailing list