Wildcard on index loopkups

[Mike Schwartz]

    One of my customers has a huge order entry detail file with almost
2,000.000 records in it and about 10 automatic indexes.  I am trying to do
some lookups into the file by part number, regardless of which customer last
purchased this part, but the only index that has a part number in it is an
older filePro 4.0 style index that is built on customer number and then part
number.  (Index G, length 16, spans field 12-Cust#, length 6, and field
13-Part#, length 10.)

 

    Because of the size of the file, and for several other reasons, I would
prefer not to do the obvious and build another index that is just by part
number.

 

    I was going to try and read the customer master file and do multiple
lookups by customer number, but there are 35,000 customers, so this process
would take way too long.  (I'm trying to return HTML line to a Web based
interface for an Intranet.)

 

    I'm not aware of anyway to wildcard the first 6 digits of an index, but
I thought some of you might have some ideas.

 

    One idea that I had was to read index "G" itself into filePro, then
decode it and find the records that have this part number in them, and then
do a record number lookup into the OE detail file to retrieve the parts
info.

 

     Any other suggestions would be appreciated

 

Thanks,

 

Mike Schwartz

 

 

          

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