RowFilter in Dataview for Grid

[WP]

Has anyone had probllem like this:

Database is Oracle
Field in filter is a date

syntax is

_orderBookView.DataViewSettings("Orders").RowFilter = viewForm.Filter

my row filter is simple "TRUNC(ORDDAT)=TO_DATE('01/04/2005', 'DD/MM/YYYY')

Problem is that I don't get any errors yet the filter does not work... I am still left with all the records.

Any help is much appreciated.

WP

http://www.neptune400.com

 

[WP]

Tis ok, I worked it out.

The dataset in VB.NET does not support all SQL functions and has its own way of doing conversions:

anyway ... revised code is:

_orderBookView.DataViewSettings("Orders").RowFilter = viewForm.Filter

my row filter is "SUBSTRING(CONVERT(ORDDAT,SYSTEM.STRING),1,10)='01/04/2005'

http://msdn.microsoft.com/library/d...fsystemdatadatacolumnclassexpressiontopic.asp

WP

http://www.neptune400.com