ORDER BY &lcSQLSortCol>Can a name expression (or Macro) be used in the ORDER BY clause of a SELECT statement? I have tried the following, but get an error.
>m.lcSQLSortCol = "lastname" > >SELECT PatientID, lastname, firstname FROM Patients INTO CURSOR csrResult ; > ORDER BY (m.lcSQLSortCol) >>