🚀 go-pugleaf

I've done partial searches a lot using DBF files with no trouble.
See notes below.

bill wester



On Tue, 21 Jul 1998 17:24:46 +0200, Gabriele Cardinali
<febeaweb@febea.it> wrote:

>Please, help me!!!!
>I have a DBF table with some fields. I have created an expression index
>in this way:
>  myTable.AddIndex('myIndex','Field1+Field2+dtos(Field3)',[ixExpression,
>ixDescending])
>
>I have to do a partial search on Field1 and Field2.
>So I do the following:
>
>  myTable.IndexKey:='myIndex';
>  myTable.SetKey;
cut{>  myTable.KeyfieldCount:=1; { to use Field1 and Field2 }}
>  myTable.FieldByName('Field1').AsString:='aaaaaa';
>  myTable.FieldByName('Field2').AsString:='bbbbb';
cut{>  myTable.GotoKey;}
    myTable.GoToNearest;        --> always works for me.
				I have never used KeyfieldCount

>
>but this source doesn't work. I have tried also with GotoNearest.
>Partial search doesn't work with expression indexes???
>Please, tell me not!!!!!!!!!!
>Please help me and, however, thanks for your interesting.
>Thanks once again.
>