Hi

thanks for your answer, but I still got problem with views.

For instance, the indeces are created well, no problem with that, but SET ORDER never takes effect on my grid, I have used .refresh(), requery() and
the view never 'reorders' itself.
Another weird thing that happended is that every time I open the
form the view remains ordered with an old expression of and index that i deleted from code hours ago and the new defined index never takes effect in the view.
What could be wrong?


Thanks again


>Roman,
>
>>1-How do you establish the indices for a view, when you define it,
>>So you won’t have to create the indices in the dataenvironment or form and all?
>>I’ve tried something like this:
>>Create sql view myview as select * from table where table.field >=1;
>>Order by table.field ;
>>Index on ‘field2’ tag ‘field2’ ascending;
>>Index on ‘field3’ tag ‘filed3’ ascending
>>Is this possible?
>
>No, this isn't possible. You have to create the indices at runtime after USE .
>
>>2-Another problem I ran into was using indexseek() and seek(). Whenever I tried To use them with a view I get message like ‘data type don’t match’ or something.
>>Is it possible to use these functions with all types of views or searches are only For tables?
>>Is it possible to change the order of a view with SET ORDER (it haven’t worked For me yet)?
>
>You can use all these functions after you've crated the according index on the view.
>
>Regards,
>Armin