I get a "SQL: Order By clause is invalid" error when USEing the following view:
select distinct(CATEGORY) as CATEGORY, DESCRIPT from MYTABLE
where !empty( CATEGORY ) order by CATEGORY
I presume that this is a change of rule in VFP 9, similar to how they change the Group By syntax.
So I think I need to change the DESCRIPT to MIN(DESCRIPT) or MAX(DESCRIPT) and all should work. Right?
But the problem I am having is when I try to change this view in the SDT, I get Error 1808: Order By Clause is Invalid.
Therefore, my question is, how do I change the view in SDT? I have been working with SDT for such a long time I forgot how to change the view any other way.
Thank you in advance for any suggestions.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham