Fuzzy Browse Speed
Nancy Palmquist
nlp at vss3.com
Fri Feb 16 12:20:52 PST 2007
I was wondering if anyone had a trick to offer to make the Browse Lookup
that is using a Fuzzy Search finish any faster.
I am searching a file that fundementally has a STATE & City field. I
want to find a city that matches my input, in the state I indicated.
So I enter a CSTATE code, then I enter a CITY.
I run a lookup like this:
kk=CITY
52 ------- - - - - - - - - - - - - - - - -
◄ If:
Then: lookup card = cardfile Z=49 K=kk -n b="(brw=12,9,-1
fuzzy=20 xkey=X show=pkeep pop=2 prc=matchst fill=asc)[City/Ent
53 ------- - - - - - - - - - - - - - - -
◄ If:
Then: ity Payto OLD CITY]*49
*3 *1"
54 ------- - - - - - - - - - - - - - - -
[These lines do what happens if I pick something or don't pick
something]
58 ------- - - - - - -
matst ◄ If: cstate ne card(48)
Then: drop
59 ------- - - - - - -
◄ If:
Then: end
60 ------- - - - - - -
I tried DROP ALL and DROP ALL AFTER - but a fuzzy search works by record
and I think it does not understand these options.
Anyone got an idea.
Nancy
--
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