Question about Multi-Field Indexes

Fairlight fairlite at fairlite.com
Tue Aug 31 19:40:30 PDT 2010


fP 5.0.14

I have data that is actually stored in two fields.  The data I get from
user input is one field...a solid concatenation of those two fields, always
in the same order.

I built an index across those fields, in that order.

However, I still need to actually grab both fields and concatenate and
-then- compare the result to my user input, all in the getnext loop, right?

Just double-checking...been a while since I've been doing active fP coding.
Normally, I'd just make one field that has the concatenation and build the
index on -that-.  I'm under the assumption that I can use a multi-field
index across both fields, and just grab the separate fields and concatenate
them into a dummy field to compare to user input, and it should come out
the same either way.

Am I correct, or incorrect?

mark->
-- 
Fairlight->   ||| He's a real nowhere man, sitting   | Fairlight Consulting
  __/\__      ||| on his nowhere LAN, sending all    | http://www.fairlite.com
 <__<>__>     ||| his nowhere SPAM to nobody...      | fairlite at fairlite.com
    \/        |||                                    | (502) 509-3840


More information about the Filepro-list mailing list