>Hi friends,
>I have a question
>
>how can I read data from multiple dbf's
>eg. I have 500-1000 pieces dbf fields are orderdate,quantity
>I wantto read quantitys between 2 date from these dbfs and finish with
>into table temp.dbf systanx
>But I couldn't find any idea for this
>
>thanks for the help
Look at select SQL in the help
I think you need something like:
Select distinct article,sum(quantity);
from myDBF;
where orderdate between myfirstdate AND mylastdate;
group by article;
into table temp.dbf