General information
Category:
Coding, syntax & commands
Title:
Does Order By work with a memo field?
I have a select statement that is failing whenever my 'order by' is a memo field. It returns the error "SQL: ORDER BY clause is invalid."
I have a custom grid cass that orders the column when the header is clicked on. It works great, except if the columns recordsource is a memo field.
Following is the code that is failing:
select *;
From (cAlias);
ORDER BY &lcOrder;
into cursor (lcResultTable) readwrite
In this particular case lcOrder='FDESC ASC'
wher FDESC is a memo field on a job description.
If FDESC were anything but a memo field, it would work fine.
Do I have a viable alternative, or is it just not possible.
Next
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