SetRange() on multifield indexes.
Posted on 1998-06-30
I've created index for few fields. I'm willing to apple range for my table, and seems I can not do that.
For example I've two fields: Symbol and Number. I've created index for these fields. TotalIndex.
Now, I'm trying something like this:
with Table1 do
IndexName := 'TotalIndex';
SetRange(['a', 1], ['m', 10]);
I'm expecting to see all records with Symbol's value between 'a' and 'm' and
and Number's value between 1 and 10 but nothing happens. At all.
When I create separate indexes for each co;umn and write for example:
with table1 do
IndexName := 'NumIndex';
FieldByName('Number').AsInteger := 1;
FieldByName('Number').AsInteger := 10;
I see just what I expected to see. But I want to use one index for all fields. Possible? How?