Associated fields and @AF

Nancy Palmquist nlp at vss3.com
Wed Jun 22 13:21:35 PDT 2005


Chad McWilliams wrote:
> Here is an output processing I'm running:
> 
>   if: d) co "O"
> Then: msgbox "AF="<@af
> 
> Now, as I read it in the filePro manual, @af should should tell me what
> field in the associated group contains the value of "O".  i.e. If O is the
> value of the second field in the associated group d), then @AF should be 2.
> 

Unless this is a very old version, you reference the associated field 
with a Letter and a number D0 to D9 where the old d) would be called d0) 
now.  You do not have to change the map to have this work.

if: d0 co "O" will match to the first and only the first d0 that has a O 
as any part of it.  If more than one d0 meets the criteria, this will 
never find it.

Nancy

> When I run this processing against my table, it find records that contain
> the value "O" somewhere in the group, but @AF is always equal to 1.
> 
> Here's what the online manual says:
> 
> -----
> If you have 32 associated fields and you do a search of that group and find
> a match, the @AF field will contain the occurrence number. If it was the
> fifth one in the associated group, then @AF will be "5".
> -----
> 
> Am I misunderstanding what's going here?
> 
> Thanks,
> 
> -Chad McWilliams
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 


-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com



More information about the Filepro-list mailing list