Compound Index on Dbase IV table

[Anders Lee]

I have a dbase table which I want to create an index of FieldA and
FieldB

I don't seem to be able to do so in the database desktop, the index I
can do is FieldA+FieldB, i.e. an expression index

But during find, I don't seem to get it working

T1.Find ( [ Str1, Str2]) is not accepted

with index descriptor error or the like

Thinking I can do this:

FindKey := FixLength(Str1,Field1Width) + Str2 ; // do I have to
pad the first field as well ???????
T1.Find ( FindKey) didn't do the trick neither.
nor
T1.Find( [FindKey]);

I need some help.
Any help is much appreciated.

[Jan Sprengers]

On Wed, 19 May 1999 16:42:00 GMT, and...@aelhk.com (Anders Lee) wrote:

>I have a dbase table which I want to create an index of FieldA and
>FieldB
>
>I don't seem to be able to do so in the database desktop, the index I
>can do is FieldA+FieldB, i.e. an expression index
>
>But during find, I don't seem to get it working
> T1.Find ( [ Str1, Str2]) is not accepted

A good (but partial) description of the limitations of dBase
expression indexes in Delphi can be found at:
www.borland.com/devsupport/delphi/ti_list/TI868D.html

If you're using Delphi 3 or 4, you can also download my JSTable
component from the Delphi Super Page (DSP) that will allow
Locate/Lookup to use expression indexes:
http://sunsite.icm.edu.pl/delphi

Hope this helps,

Jan