Thanks Sergey
It took a long time to query a set of cursor from a huge table without index
SQLExec(lnHandle, "select * from detail where type=m.type and ref_no=m.ref_no",'temp'")
in order to speed up, how to create the index file and how to apply it ?



When you move to a client-server database, you should forget about row level access and start thinking in a set oriented (queries) access.

>I have a detail.dbf with 2 indexes
>ref_no char(10), type char(10), date date(8), account char(10), itemcode char(10)
>index on type+ref_no tag ref_no && type is bill type like INVOICE,CASHBILL,PURCHASE,CN,DN.....
>index on itemcode+account+dtos(date) tag itemcode descend
>
>use detail
>set order to ref_no
>seek m.type+m.ref_no
>do something..........
>
>set order to itemcode
>seek m.itemcode+m.account
>scatter all previous data and gather into temp cursor........
>
>how to create this table and indexes with mysql syntax ?
>how to play around with these index just like vpf table and index seek with mysql coding ?