DataView.RowFilter method

[Poorni]

Hi All,

I am using "dataView.RowFilter" method to filter the values in my application.

For a scenario like this with the values in Oracle database

OPERATION Table has records with the following OPERATIONCODE's
a1, a2, a3, 20, 21, 23, JEN

OPERATIONCODE is a 'Varchar2' type.

I am using DataView.RowFilter method 'CaseSensitivity' property of underlying datatable is set to true.

1) Setting Filter Criteria OPERATIONCODE < 'a101' returns 4 records a1, 20,21, 23 in the application.

2) TOAD Returns 5 records a1, 20, 21, 23, JEN
sqlplus returns the same a1, 20, 21, 23, JEN

So the filtering values are different from the values which we get by querying the database. Is there a way to get the same values from my filter. Any thoughts on this..

Thanks in advance.

Annapoorni

 

[fadi]

if u set the casesensitivity to false then ur results will be the same, if u need the case sensitivity to be true, then reset it after the filter

 

[Poorni]

hi, first it was CaseSensitive = false by default, that time i got 4records only instead of 5 and i set CaseSensitive = true, even then am getting the same results as 4.

 

[Arch4ngel]

Remember that it is a character comparison.

a > J == TRUE

so it's normal that JEN don't apear!
Check your ANSII table