Hello,

Return the SQLSERVER cursor to a temp cursor. Then scan and append into the indexed cursor or append (dbf("work")) into the indexed cursor.

like this...

create cursor Mycursor ( cdata c(10)...)
index on cdata tag cdata

SQLexec(lnsql,lcSelect,'work')
select MyCursor
append from (dbf('work')) && Populate indexed cursor



>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? :)
>
>TIA,
>Misha