DataView RowFilter: using distinct

[Guest]

I have the following line of code (.NET 2.0):

myDataView.RowFilter = "SELECT DISTINCT CYCLE_DATE";

where CYCLE_DATE is one of my column names. This throws the following
exception:

Syntax error: Missing operand after 'DISTINCT' operator.

Any suggestions on what this is really trying to tell me?

Thanks,
Randy

 

[Alberto Poblacion]

I have the following line of code (.NET 2.0):

myDataView.RowFilter = "SELECT DISTINCT CYCLE_DATE";

This is wrong. The RowFilter does not take a "Select" statement. It only
takes the part that would go after the "Where" in a "Select" statement, such
as
myDataView.RowFilter = "field1>27 AND field2<45". Since the "distinct" does
not go after the "where", the dataview is not adequate for doing the kind of
filtering that you want.

 

[Isaac Abraham]

I have the following line of code (.NET 2.0):

myDataView.RowFilter = "SELECT DISTINCT CYCLE_DATE";

where CYCLE_DATE is one of my column names. This throws the following
exception:

Syntax error: Missing operand after 'DISTINCT' operator.

Any suggestions on what this is really trying to tell me?

Thanks,
Randy

IIRC, you can't use DISTINCT in a row filter. There's an article on MSDN
on how to get around this in code, I believe.