Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Why is Select Sum(IntCol) now returning BigInt instead of Integer? |
Mon, Dec 31 2012 5:12 PM | Permanent Link |
Barry | I'm sure doing a SubSelect with Sum(IntCol) used to return an Integer. But in the latest EDB version 2.11 B3, is returning BigInt. Normally this isn't a big deal, but because a few months back I used the Fields Editor to load the field definitions with an earlier EDB version, now the Delphi XE2 compiler doesn't like to see a TIntegerField when the query returns a TLargeInt field for Sum(). I can of course get around this by changing the field type in the form, but it will take a while for me to check all the forms that had a query with an aggregate function like Sum(IntColumn).
Has anyone else noticed Sum(IntegerCol) now returning BigInt? What other aggregate functions are affected? Or am I wrong and Sum(InegertCol) has always returned BigInt for prior versions of EDB? TIA Barry Delphi XE2 32 bit. |
Wed, Jan 2 2013 6:35 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Barry,
<< Has anyone else noticed Sum(IntegerCol) now returning BigInt? What other aggregate functions are affected? Or am I wrong and Sum(InegertCol) has always returned BigInt for prior versions of EDB? >> I looked back to EDB 1.x and it was returning an Int64 back then also, so it's been around for a while. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |