Board index » delphi » Aggrigation command!!!

Aggrigation command!!!

When I make a query that use aggregation commands
database, they all appear TFloatFields in Delphi. Is there something wrong I
did? How can I make TIntegerFields To get results?
Example : select count(*) from Table1
I want to get result with TIntegerFields format.
                         Thanks for advance
 

Re:Aggrigation command!!!


Use the AsInteger property to assign the value.

SomeIntegerVariable := Query1.FieldByName('TotalCount').AsInteger;

--
Bill

Other Threads