Misa,

No, you can't bring the indexes along with the result back from SQL server. If you need indexes down in the VFP cursor you'll have to create them once the data is in VFP cursors. Indexing should go pretty fast especially considering that you should normally be returning relatively small result sets of data.

>I'm sorry, maybe my english is not enough good, I tied to get data from indexed SQL table to fox cursor with existed(SQL) indexes. If I get only data I have to index fox cursor in run-time and that is too slow.
>I use
>
>... and !SQLPrepare(.nHandle, "SELECT * FROM "+.cAlias+iif(Empty(.cWhere),""," Where "+.cWhere)+" order by "+.cOrder, .name)<0;
>and !SQLExec(.nHandle)<0;...
>
>command to get data, but after that I have to index that cursor.
>
>Maybe I want too mach? :)