Problem with partial search. Please help me!!!!

Article View: comp.lang.pascal.delphi.misc

Article #94

Back to comp.lang.pascal.delphi.misc Previous Next

#94

From: Gabriele Cardinali
Date: Tue, 21 Jul 1998 00:00

21 lines
1520 bytes

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;
  myTable.KeyfieldCount:=1; { to use Field1 and Field2 }
  myTable.FieldByName('Field1').AsString:='aaaaaa';
  myTable.FieldByName('Field2').AsString:='bbbbb';
  myTable.GotoKey;

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.

Technical Details

Message-ID: <35B4B2BD.C56ADA46@febea.it>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff75c,8c8e8a36b517982f,start
X-Google-Attributes: gidff75c,public
X-Google-Thread: 10baee,8c8e8a36b517982f,start
X-Google-Attributes: gid10baee,public
X-Google-Thread: f6386,8c8e8a36b517982f,start
X-Google-Attributes: gidf6386,public
From: Gabriele Cardinali <febeaweb@febea.it>
Subject: Problem with partial search. Please help me!!!!
Date: 1998/07/21
Message-ID: <35B4B2BD.C56ADA46@febea.it>
X-Deja-AN: 373530539
Content-Transfer-Encoding: 7bit
Organization: Customer of Flashnet S.p.A. - http://www.flashnet.it
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: comp.lang.pascal.delphi.misc,borland.public.delphi.database.multi-tier,borland.public.delphi.database.desktop