Probably. I think I need to add the database to my project and then I will be able to do it. Right? Thank you so much, I will try it now.
>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.
"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