Hi,

DBISAM is throwing an error (Index Out of Bounds) with this query:

select 0 as order, cast(sum(price) as money) as total
from myTable
group by order
union all
select 0, 0 as total
from myTable2

I'm using Delphi 7 with DBISAM 4.37 build 2.

Any ideas?

Pedro,

<< DBISAM is throwing an error (Index Out of Bounds) with this query: >>

Please email me the tables that you're using as a .zip attachment and I'll
take a look.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,
Thank you for your reply.

I was able to reproduce this issue in different tables from different applications.
This was also tested on different machines always with the same result.

Pedro.

"Tim Young [Elevate Software]" wrote:

Pedro,

<< DBISAM is throwing an error (Index Out of Bounds) with this query: >>

Please email me the tables that you're using as a .zip attachment and I'll
take a look.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Pedro,

<< I was able to reproduce this issue in different tables from different
applications. This was also tested on different machines always with the
same result. >>

Sorry, I didn't notice that your SQL didn't really require the tables.  I've
reproduced it here, and will have a fix for it in the next build.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com