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