I have a grid with a cursor (alias) rowsource. There are also a few comboboxes on the same form that control the contents of the grid. One of the comboboxes controls the sort order. In my code right now, I have seperate SQL statements for each sort order. I'd like to have one SQL statement using a variable to control the 'order by' section.

For example, the following code works:

select * from tblgl order by tblgl.tempgl into cursor test

The code below does not work:

ctemp = "tblgl.tempgl"

select * from tblgl order by (ctemp) into cursor test

Is there a way to use a memory variable in a SQL Select statement?