>I read a tip in July's Foxpro Advisor that you can use paramters for other than the where clause in an SQL view, fox example the Order by (provided you use the numeric construct, e.g. ORDER BY 2, instead of the field name). I couldn't get it to work however (got an error when I included ORDER BY ?testorde after setting testorde to 2 in the command window). Has anyone had any success or attempted this?
>
>I was intrigued by the idea as I'm trying to create an SQL for a report, but my users want to have flexibility in how it is ordered: Alphabetically, by District, or by Category. I don't want to create many different instances of the same SQL for this purpose. Perhaps I'm overlooking something obvious or another way to allow for this flexibility.
>
>I'd appreciate any ideas.
>
>TIA
>
>Sylvia
Sylvia,
I never done it with "?testorde" style but generally use numeric instead of field name (ie: select field1+field2+substr(field3,4,3) as somedata,* order by 1 works but not order by field1+field2+substr(field3,4,3) or somedata). If you would provide testorde just before the SQL then only replacing "?" with "&" would do the job :
testorder="2"
select * from mytable order by &testorder
Cetin