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 ?