Citat:
double kolonaZ=kolonaZ+kolonaO;
Deklaracija treba van petlje.
// netestirano
Code:
// ...
try
{
double kolonaZ=0.0;
ADOTable1->DisableControls();
for ( ADOTable1->First(); !ADOTable1->Eof; ADOTable1->Next() )
kolonaZ += ADOTable1->FieldValues["Ukupno"];
}
__finally
{
ADOTable1->EnableControls();
}
// ...
Code:
// ...
try
{
double kolonaZ=0.0;
ADOTable1->DisableControls();
for ( int i=0; i<ADOTable1->RecordCount; i++ )
{
kolonaZ += ADOTable1->FieldValues["Ukupno"];
ADOTable1->Next();
}
}
__finally
{
ADOTable1->EnableControls();
}
// ...
Takodje probaj da umesto:
->FieldValues["Ukupno"]
...stavis:
->FieldByName("Ukupno")->AsFloat;
... mozda ima manje konverzije.
A mozes da probas i klasican SQL za sabiranje:
http://www.techonthenet.com/sql/sum.php
Obicno radi brze.