Hi Roman,

You can try this

 Create sql view mysqlview as select * from Mydbc!Table1 where table1.status="A" order by account
Use mysqlview in 0 exclusive
index on account tag account of mysqlview
set order to account
seek account=10
Browse

You will have to requery and rebuild the index everytime you open the view.

Hope this helps.

RD

>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