jterry
Posts: 4
|
| Posted: 09/07/2006, 10:51 AM |
|
I know that I have dones this before, but I can't find it now. I have a simple search and a grid(only using one table). The search field is a text box where a user can enter a customer number i.e. 207. Now when the search button is clicked the results in the grid show any customer number that has 207 in it i.e. 1207, 35207 etc... How can I limit the search to just what the user enters?
Jason
|
 |
 |
WKempees
|
| Posted: 09/08/2006, 1:09 AM |
|
Quick Answer
click on the result Grid
Properties, DataSource [...]
There you find the Where
Check all parameters and set the appropriate one from
"Contiaines" to "Equals"
In SQL it would look like: field LIKE '{s_search}%'
should be : field = '{s_search}'
|
|
|
|
|
