Upgrade from 5.70 to 6.20
anytable - any table in database which have column with type Date
dat - any column with type Date
OraQuery->Active = false;
OraQuery->SQL->Text = "select a.rowid, a.* from anytable a where dat=to_date(:dat,'dd.mm.yyyy');
OraQuery->SQLRefresh = WHERE ROWID = :Old_ROWID";
OraQuery->ParamByName("dat")->AsString = "01.01.2007";//any date
OraQuery->Active = true;
OraQuery->RefreshRecord();
//ERROR ORA-01830 date format picture ends before converting entire input string
Why???
In 5.70 it's ok.