Question about Multi-Field Indexes

[Scott Walker]

-----Original Message-----
From:
filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
[mailto:filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.
com] On Behalf Of Fairlight
Sent: Tuesday, August 31, 2010 10:41 PM
To: filePro Mailing List
Subject: Question about Multi-Field Indexes

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->


Mark,

To my understanding, you are correct.

Before NON-CONTIGUOS multi-field indexes, you would have had to build a
combo field and build the index on that, or, you could have built the index
on the first field but made it's length longer than that field's length, so
it would actually be built on both fields.

Regards,

Scott