inexact finds

[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

 

[Daniel Carlsson]

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

 

[Bernie Yaeger]

Thanks again, Dan

Bernie

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