>In trying to use a memory variable in the ORDER BY clause of a SELECT statement, I am getting the following error message...
>
>"SQL: Column 'MORDERBY' is not found.
>
>The code I am trying to run is as follows...
>

>DO CASE
>	* CASE Order By Cust
>	CASE ThisForm.optOrderBy.optOrderByCust.Value = 1
>		STORE "Cust, OrdDate, Invoice, Prodct" TO mOrderBy
>
>	* CASE Order By Product
>	CASE ThisForm.optOrderBy.optOrderByProduct.Value = 1
>		STORE "Prodct, OrdDate, Cust, Invoice" TO mOrderBy
>
>ENDCASE
>
>SELECT * ;
> FROM InvHist ;
> INTO ARRAY arrInvHist2 ;
> ORDER BY mOrderBy
>

>

You'd have to macro-expand mOrderBy in the last line - ORDER BY &mOrderBy

>Would appreciate any help if somebody knows of a way to do accomplish this (or something akin to it). TIA, Chuck.