try{
    Query->Close();
    Query->SQL->Text = " select "
                       " TO_CHAR(UPDATE_DATE, ' YYYY-MM-DD HH24:MI:SS'), "
                       " VEH_ID, ROUTE_ID, PLATE_NO    "
                       " from CURRENTROUTE_HISTORY ";

    Query->Open();

    String sFrom = deFrom->Date.FormatString("YYYYMMDD")+"000000";
    String sTo = deTo->Date.FormatString("YYYYMMDD")+"235959";

    if(deFrom->Date != Now())
    {
        Query->SQL->Append(" where UPDATE_DATE between TO_DATE('"+sFrom+"', 'YYYY-MM-DD HH24:MI:SS') ");
        Query->SQL->Append(" AND TO_DATE('"+sTo+"', 'YYYY-MM-DD HH24:MI:SS') ");
    }

    ShowMessage(Query->SQL->Text);

    gvTest->BeginUpdate();

    while(!Query->Eof){

    int row = gvTest->DataController->AppendRecord();

    gvTest->DataController->Values[row][gvTestColumn1->Index] = Query->FieldByName("UPDATE_DATE")->AsAnsiString;
    gvTest->DataController->Values[row][gvTestColumn2->Index] = Query->FieldByName("VEH_ID")->AsAnsiString;
    gvTest->DataController->Values[row][gvTestColumn3->Index] = Query->FieldByName("ROUTE_ID")->AsAnsiString;
    gvTest->DataController->Values[row][gvTestColumn4->Index] = Query->FieldByName("PLATE_NO")->AsAnsiString;

    Query->Next();

    }

    gvTest->EndUpdate();

}
catch(Exception &e){
    ShowMessage(e.Message);
}
}



데이터 에딧으로 검색을 할때  DB의 쿼리문은 정상적으로 뽑히고 DB에서는 입력을 하면 출력이 되는 쿼리문인데
C++ builder 에서는 안먹히는 경우도 있나요..