DataView RowFilter: using distinct

[=?Utf-8?B?cmFuZHkxMjAw?=]

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]

"randy1200" <ra*******@discussions.microsoft.comwrote in message
news:DB**********************************@microsof t.com...

>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]

randy1200 wrote:

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.