RowFilter in DataView: Missing operand before '|' operator
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
- Re: datagrid combobox question
... I already have a datagrid with a combo box. ... I want to know if I can set the bound DataView to filter for the value ... Say the datagrid is displaying records filtered for Order No 12345678 and it ... > The Order Detail Line has a field, ...
(microsoft.public.dotnet.languages.vb) - Re: datagrid combobox question
... > I already have a datagrid with a combo box. ... >> The Order Detail Line has a field, ... >> What I want to do is to filter the list of Locations in the combo box to ...
(microsoft.public.dotnet.languages.vb) - Re: Error on sort/filter
... It sounds like you are displaying a value other than what is bound to the ... underlying field.....so a filter would produce an error. ... > I've got a dlookup column in an underlying query on a datasheet subform. ...
(microsoft.public.access.formscoding) - Re: Repost: Errorhandling with Apply Filter Event
... > displaying comes from some column other than the bound column. ... >> if I attempt to do a filter on a combobox control, ... >> The expression you entered as a query parameter produced this error: ...
(microsoft.public.access.formscoding) - Re: Repost: Errorhandling with Apply Filter Event
... > if I attempt to do a filter on a combobox control, ... > The expression you entered as a query parameter produced this error: ... displaying comes from some column other than the bound column. ... transforming such lookup references in filters into criteria that could ...
(microsoft.public.access.formscoding) |
|
