Hi im trying to make an index based upon 2 concatenated fields firstname + " " + surname, but the database file regards them as 2 strings. Can you make the index based upon the concatenated fields but write the database file as 2 seperate fields without your offsets stuffing up. Ive done this and it seems to be possibly stuffing my offsets up.
name index file ------------------ Alison M Chappell 0 Barbara J Furza 480
displaying database according to name index file ------------------------------------------------ offset2[0] = 0 Alison M Chappell 696458 1963
offset2[3] = 80 Barbara J Furza 1504503 1962
-------------------------------------
See how the offsets for the 2nd record are wrong, its the same for several other records.
Previous Topic
