create table test ( ;
Field1 I( 4 ), ;
Field2 c( 25 ))

INSERT INTO test (Field1, Field2) Values ( 1 , 'Value1')
INSERT INTO test (Field1, Field2) Values ( 2 , 'Value2')
INSERT INTO test (Field1, Field2) Values ( 3 , 'Value3')

**------Create indexes
SELECT test

INDEX ON Field1 Tag iField1
INDEX ON Field2 Tag iField2
INDEX ON ALLT(STR(Field1)) + Field2 Tag iField1_2

*------Setting controlling indexes for table 'test'
SET ORDER TO TAG iField1 
*-- working with data ordered by Field1

SET ORDER TO TAG iField2
*------------------------------
SET ORDER TO TAG iField1_2
*------------------------------

*-- Close active index (after that table 'test' has no active index)
SET ORDER TO

SET ORDER TO TAG ...