>HI all
>
>here my question
>
>I want to create an index in a dbf fiel (through data session) with one field(integer) in ascending mode and another one (character) in descending mode like this SQL command :
>
>select * from table1 order by field1 , field2 desc
>
>where field1 is asc and fields desc
>
>
>thx for the help ;)
>
>Eric Gauthier

INDEX ON BINTOC(field1)+CHR(255-ASC(field2)) .. ASC
INDEX ON BINTOC(-field1)+field2 .. DESC