Hello, I am having some difficulty making some changes to an existing app. It was coded to take advantage of rowfilters to retrieve specific information.
What I have is an Oracle database populating a dataview, and the rowfilter trying to pull out specific rows within a date range. here is that code:
The syntax is correct; it works in PL/SQL. The error that is returned is this:
An unhandled exception of type 'System.Data.EvaluateException' occurred in system.data.dll
Additional information: The expression contains undefined function call to_date().
It seems like VB.Net is catching the function and not passing it to Oracle, as I'm not getting an ORA-XXXXX error... what am I doing wrong?
What I have is an Oracle database populating a dataview, and the rowfilter trying to pull out specific rows within a date range. here is that code:
VB.NET:
[size=2]
rowFilter = "BEGINDATE BETWEEN to_date('" & _
Format([/size][size=2][color=#0000ff]Me[/color][/size][size=2].DateRangeBeginPicker.Value, "MM/dd/yyyy") & _
"', 'MM/DD/YYYY') AND to_date('" & _
Format([/size][size=2][color=#0000ff]Me[/color][/size][size=2].DateRangeEndPicker.Value, "MM/dd/yyyy") & _
"', 'MM/DD/YYYY')"
[/size]
The syntax is correct; it works in PL/SQL. The error that is returned is this:
An unhandled exception of type 'System.Data.EvaluateException' occurred in system.data.dll
Additional information: The expression contains undefined function call to_date().
It seems like VB.Net is catching the function and not passing it to Oracle, as I'm not getting an ORA-XXXXX error... what am I doing wrong?