void __fastcall TDM::SelectTrend(String strSelectCH, String strTbl, double dblStart, double dblStop) { String strSQL; String strStart = FormatDateTime("yyyy-mm-dd HH:NN:SS", dblStart); String strStop = FormatDateTime("yyyy-mm-dd HH:NN:SS", dblStop); strSQL = "SELECT DT," + strSelectCH + " FROM " + strTbl; strSQL += " WHERE ( DT BETWEEN "; strSQL += "'" + strStart + "'"+ " AND " + "'" + strStop + "')"; try { IBDataSetTrend->Close(); IBDataSetTrend->SelectSQL->Clear(); IBDataSetTrend->SelectSQL->Add(strSQL); IBDataSetTrend->Open(); TIBOutputDelimitedFile *pDelimitedFile = new TIBOutputDelimitedFile; try { pDelimitedFile->Filename = "C:\\TEST.TXT"; pDelimitedFile->ColDelimiter = ","; IBDataSetTrend->BatchOutput(pDelimitedFile); } __finally { delete pDelimitedFile; } } catch (Exception &exception) { ErrorLog( exception, strSQL ); } }