hi mate,
I am working on the customize screen and I need to set some filter for the finder, my code is like this
fnd.ViewID = "AR0024"
fnd.DisplayFieldIDs = Array(1, 2, 14, 5, 8, 3, 4, 32, 15, 16, 17, 18, 19, 20, 21, 22, 24, 25, 23, 125)
fnd.Filter = "TEXTSNAM =" & ShortFilter.Text
If fnd.Finder = True Then
textbox = fnd.ReturnFieldValues(0)
End If
in the .filter section, can I use the Like operation? if yes, which symbol should I use? %? or something others?
I am working on the customize screen and I need to set some filter for the finder, my code is like this
fnd.ViewID = "AR0024"
fnd.DisplayFieldIDs = Array(1, 2, 14, 5, 8, 3, 4, 32, 15, 16, 17, 18, 19, 20, 21, 22, 24, 25, 23, 125)
fnd.Filter = "TEXTSNAM =" & ShortFilter.Text
If fnd.Finder = True Then
textbox = fnd.ReturnFieldValues(0)
End If
in the .filter section, can I use the Like operation? if yes, which symbol should I use? %? or something others?