Devart Forums

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.

We have fixed this problem. The fix will be included in the next build of ODAC.