I have a problem setting the range for a secondary index in a Paradox 7 table using Delphi2010.
Relevant fields:
FeatureType (int); YMax (int); XMax (int); YMin (int); Xmin (int). The secondary index contains all of these fields in that order.
I tested using the SetRange statement as shown below (optional to add all field values, the rest is assumed to be NULL and all values ββare included):
table1.IndexName := 'YMaxIndex';
table1.SetRange([101, 280110400],[101, 285103294]);
And tried to get the result 0, adding to the restrictions:
table1.IndexName := 'YMaxIndex';
table1.SetRange([101, 280110400, 1],[101, 285103294, 1]);
But it still gets 3863236, which is clearly wrong when checking the values ββin the XMax field in the table.
Can someone explain to me that I do not understand about the Paradox and SetRange index? I often used similar code, but not necessarily with 3 fields indicating a range.
Update
. Uwe . ( XMax):
Table1.SetRange([101,280110400], [101,285103294]);
Table1.Filter := 'XMax > 100000 and XMax < 110000';
Table1.Filtered := true;