Can you update your view in a separate program such as View Editor?
>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.
If it's not broken, fix it until it is.
My Blog