General information
Title:
Using 'like' in a remote view
I am working on a 'Find' screen for a form. I am trying to return all names that match the characters typed in a textbox. The data is on a SQL Server backend. I am trying to use the 'like' operator in a remote parametized view but it doesn't seem to work. I have set ANSI to off. The filter in the view designer is:
pr_name like ?qName
It only seems to work if I type in the exact expression.
Perhaps there is a better way to do this?
TIA
John
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only