>thank you sir,
>
>but in network, i am using :
>sele 0
>use \\192.168.0.1\d\account\sales
>sele sales
>select * from sales where between(date,rep.ldate1,rep.ldate2) into dbf tsal
>
>it store data from server to tsal.dbf into local machine.
>
>and than i am using this tsal.dbf as exclusive and generate the report.
>
>
>please suggest me what i do for perfect and faster result.
>
>
>warm regards,
>mk.
This is the same:
SET EXCLUSIVE OFF
SET PATH TO \\192.168.0.1\d\account\ ADDITIVE
select * from sales where between(date,rep.ldate1,rep.ldate2) into CURSOR tsal READWRITE
Then you could use CURSOR tsql for reporting.
I see no reason to have Exclusive use of any tables. That SELECT returns you a rowset that is EXCLISIVELY used for you on your machine, only difference is that when you close it it disapears automaticly :o)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.