Hi!

I got a couple of questions about views

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?



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)?


How can I solve all these problems?

Thanks in advance