>Does anyone know the syntax for
>macroing an order by clause into
>an SQL statement.
>
>I tried both
>
>cOrder = "Field1 + Field2"
>SELECT flds;
> FROM Table
> ORDER BY (cOrder)
> INTO CURSOR tmp
>
>and
>
>cOrder = "Field1 + Field2"
>SELECT flds;
> FROM Table;
> ORDER BY &cOrder;
> INTO CURSOR tmp
>
>Both cause an error.
cOrder = "1,2"
SELECT * ;
FROM Table;
ORDER BY &cOrder. ;
INTO CURSOR tmp
Edward Pikman
Independent Consultant