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