Rowfilter & to_date function for Oracle

WKoenig

New member
Joined
Mar 15, 2005
Messages
1
Programming Experience
1-3
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:

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?
 
Back
Top