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

"randy1200" <(E-Mail Removed)> wrote in message
newsBF96CFC-541C-4B74-BF90-(E-Mail Removed)...
>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.

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.