inexact finds

  • Thread starter Thread starter Bernie Yaeger
  • Start date Start date
B

Bernie Yaeger

I'm trying to use a dataview to find a given row in a datatable, but the
find is inexact. For example, vue.sort = "lname" and I want to find the
first that begins with "F". If I use vue.find(obj) where obj(0) = "F" it
fails but where obj(0) = "Fineman" it succeeds.

Of course, if I have to use a table's defaultview or some other means,
that's fine, but I cannot search on PK as that is rarely the column in
question.

Tx for any help.

Bernie Yaeger
 
Either use:
vue.Table.Select("lname LIKE 'F%'")
Or
vue.RowFilter = "lname LIKE 'F%'"

The latter is on the DataView and the first on the
DataTable, the downside with the second one is that you
most likely use the view somewhere besides this place and
you might not want to modify the subset it shows.
/Dan
 
Thanks again, Dan

Bernie
Daniel Carlsson said:
Either use:
vue.Table.Select("lname LIKE 'F%'")
Or
vue.RowFilter = "lname LIKE 'F%'"

The latter is on the DataView and the first on the
DataTable, the downside with the second one is that you
most likely use the view somewhere besides this place and
you might not want to modify the subset it shows.
/Dan
Click to expand...
 
Back
Top