General information
Category:
Coding, syntax & commands
>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?
Have you tried a macro???
SELECT * FROM tblgl ORDERY BY &cTemp INTO CURSOR test
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only