Re: RowFilter in DataView: Missing operand before '|' operator

Tech-Archive recommends: Speed Up your PC by fixing your registry

RowFilter="Status='' OR Status<>'Scanned'"

(Assume empty Status is '', not NULL).

"Fir5tSight" <fir5tsight@xxxxxxxxx> wrote in message
news:1169048841.186113.12950@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I am using a DataView to displaying a records from datatable. I have a
filter that I define it as follows:

"Status = '' || Status <> 'Scanned'"

The problems is that I get an error about "Missing operand before '|'
operator".

If I change the filter to "Status <> 'Scanned'", there is no error. But
records with an empty Status field do not show in the grid.

Any advice on how to make the filter work?

Thanks!

-Emily



.

Relevant Pages

  • RowFilter in DataView: Missing operand before | operator
    ... I am using a DataView to displaying a records from datatable. ... Any advice on how to make the filter work? ...
    (microsoft.public.dotnet.general)
  • Re: Typed DataSet Navigation (Multiple Tables)
    ... It's not a filter on the key. ... EmployeeId is only part of Orders not ... getting child rows, because that means I have to hit EVERY parent ... SINGLE DataView from the child in which contains ALL relating DataRows ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Stupid Query Question...Column Display
    ... Looking at this reply a bit closer, I see that you mention a filter to not ... In your Query, I expect that you specified conditions in which you ... that might very well produce an empty recordset. ... If employee has done Job 'X' then just show that column and not the other 14 ...
    (microsoft.public.access.queries)
  • Re: Typed DataSet Navigation (Multiple Tables)
    ... SINGLE DataView from the child in which contains ALL relating DataRows ... If you use a filter with the same keys as the relation, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to append parameter to Url that has parameters?
    ... Changing the filter to be Company Equal [Input Parameter] is not enough. ... > The parameter I am trying to add to the hyperlink in the ... > dataview isn't an input parameter to that data view. ...
    (microsoft.public.sharepoint.windowsservices)