I made  a file with the select included on the select stament below. (On Dbisys I run that
sql and save the result on a file called AvdPick )
When I try to fill the file with data I get a big number where the average number go. if I
run the select sql on dbisys I get the correct number.
DBISAM 3.2

insert into AvgPick select pat Cli, pat2 Cli2, avg(datep-ddate) as Avgdays,
sum(if(datep<=ddate then 1 else 0)) as Ontime, sum(if(datep-ddate<4 then 0 else 1)) as
Less4days, sum(total) Tot  from hist
where
date>=current_date-120 and
datep is not null and
datep>=ddate
group by pat,pat2

Carlos,

<< I made  a file with the select included on the select stament below. (On
Dbisys I run that sql and save the result on a file called AvdPick ) When I
try to fill the file with data I get a big number where the average number
go. if I run the select sql on dbisys I get the correct number. DBISAM 3.2
>>

You need to make sure that you're using the same version of DBISAM for your
application that you're using for DBSYS (Help/About).  Then you will get the
correct result.

--
Tim Young
Elevate Software
www.elevatesoft.com