DataTable.select

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, Im +/- newbi

I have a DataTable containing several DataColumns
Some columns have single names, like "IP", others have composite names, like "IP Subnet"

I want to select rows where IP and IP Subnet are not empty strings, so here come my two questions

1: I cannot do something like: myTable.select(IP, IP Subnet query_criteria
I obtain syntax error in the field: IP Subnet -> so how can i identify the field correctly in the query

2: In query_criteria, how can I indicate the following: "is not an empty string

Regards

Bernard
 
It needs to be clear that I am not incorrectly passing parameters to the select() function

This function can accept a query string and a sort string - I am aware of this
In my post, though, you can actually only see a natural language representation of the query string, which is the relevant problem I am having.
 
Hi Bernard,

Did you try embracing IP Subnet field into square brackets?
Len([IP Subnet])>0 I would say or Len(IsNull([IP Subnet], ''))>0
What is your criteria, btw?

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Bernard said:
Hello, Im +/- newbie

I have a DataTable containing several DataColumns.
Some columns have single names, like "IP", others have composite names, like "IP Subnet".

I want to select rows where IP and IP Subnet are not empty strings, so here come my two questions:

1: I cannot do something like: myTable.select(IP, IP Subnet query_criteria)
I obtain syntax error in the field: IP Subnet -> so how can i identify
Click to expand...
the field correctly in the query?
 
Back
Top