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.

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