>Is it possible.
>I want to order by a field nad inside that another filed, just like
>select-sql SELECT ...WHERE...ORDER BY 1,2
>
>Thanks!
>Pablo
SET ORDER sets the order to an index, not a field. And the index can be on any expression, including more than one field.
For instance:
use cliente
index on apellido + nombre tag nombres
use
use cliente
set order to nombres
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)