Board index » delphi » SetRange * ?

SetRange * ?

Hello .. i have one index like this :

MyField1;MyField2

How can i tell to setrange that i want all the records from the
first field which the 2ndfield has values 500 ?

eg... SetRange([*, 500], [*,500]);
(of course the above routine doesn't work)..

is it possible to change Potition in Runtime of the Index ?
to be like : MyField2;MyField1;

Thanx

 

Re:SetRange * ?


Quote
On Tue, 29 Feb 2000 10:54:43 +0200, "Gate" <g...@hotmail.com> wrote:
>eg... SetRange([*, 500], [*,500]);
>(of course the above routine doesn't work)..

>is it possible to change Potition in Runtime of the Index ?
>to be like : MyField2;MyField1;

You'll need to build such an index and change the active order to this
index before using SetRange.

Jan

Re:SetRange * ?


You need to create a second index on MyField2;MyField1 and use that index.

--
Bill

Bill Todd (TeamB)
(TeamB cannot respond to questions received via email)

Re:SetRange * ?


"Bill Todd (TeamB)" <b...@dbginc.com> wrote in message
news:89hjra$kad13@bornews.borland.com...

Quote
> You need to create a second index on MyField2;MyField1 and use that index.

thank you all

Other Threads