🚀 go-pugleaf

thanks for your warning but there is no NULL in table.

Now there is another error pops up!
TADOQuery *CountQuery;
CountQuery= new TADOQuery (this);
CountQuery->Connection = ADOConnection1;

CountQuery->SQL->Add ("select COUNT(bid) from ["+table+"]");
CountQuery->Open ();
count = CountQuery->FieldByName ("COLUMN1")->AsInteger;


 CountQuery->SQL->Clear();
 CountQuery->SQL->Add ("select [bid],[fTime] from ["+table+"] order by
[fTime] ASC");
  CountQuery->Open ();

for (int i = 0;i<count ;i++)
  {

           v_bid.push_back(CountQuery->FieldByName ("bid")->AsFloat);

           v_time.push_back(CountQuery->FieldByName ("fTime")->AsDateTime);

           CountQuery->Next ();
   }

        start = v_time.at(0);

        end = v_time.at(count-1);


        CountQuery->Close(); -----> NOW IT GIVES ERROR HERE! ITS EITHER BOF 
OR EOF OR THERE IS NO VALID RECORD

        CountQuery->SQL->Clear();
        CountQuery->SQL->Add ("SET DATEFORMAT dmy");
        CountQuery->SQL->Add ("SELECT  distinct DATEDIFF(n, '"+start+"', 
'"+end+"') AS diff from ["+table+"]");
        CountQuery->Open ();