FIltering DataSet Problem
Visual Basic
3
Posts
2
Posters
0
Views
1
Watching
-
Cant use wildcards with "LIKE" accessing oracle database objDv = FilterDataSet(objDs, "SUPERVISOR_NAME LIKE 'se_n'") where objDs is the data set should return "sean" but is not not fimilar with wildcards any ideas? Cheers
-
Cant use wildcards with "LIKE" accessing oracle database objDv = FilterDataSet(objDs, "SUPERVISOR_NAME LIKE 'se_n'") where objDs is the data set should return "sean" but is not not fimilar with wildcards any ideas? Cheers
-
This should work:
objDv = FilterDataSet(objDs, "SUPERVISOR_NAME LIKE '%se_n%'")WM.
What about weapons of mass-construction?No didnt work dont think dataset supports the wildcard "_" any other soloutions?