Tim

I try to execute the following SQL statement and receive AV
I know the HAVING clause is incomplete but AV is not a proper error message,
do you agree ?

select emp,num,count(*) as x from hino
group by emp,num
having x

I am using D6 SP2, DBISAM 4.22 build 4

Eduardo

Eduardo,

<< I try to execute the following SQL statement and receive AV I know the
HAVING clause is incomplete but AV is not a proper error message, do you
agree ? >>

Yep, I've reproduced it here and a fix will be in the next build.

--
Tim Young
Elevate Software
www.elevatesoft.com