Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
Index out of bounds with CAST and UNION |
Wed, Dec 4 2013 6:23 AM | Permanent Link |
Pedro Silva | 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? |
Mon, Dec 9 2013 4:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Dec 11 2013 10:36 AM | Permanent Link |
Pedro Silva | 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 |
Mon, Dec 16 2013 8:33 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |