|
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 05/12/2006 5:35:50 PM
Posts: 13, Visits: 18 |
| | Hi all, I am having a problem with the browse object not seeming to work properly. It will return ALL records just fine, however I never seem to get any records returned when I try to search by any of the search fields. For instance if I launch the browse dialog and hit Enter it returns all rows however if I try to filter by name starts with A it returns no results. Any ideas on what i mat be missing? Thanks |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 07/21/2008 8:17:34 AM
Posts: 26, Visits: 236 |
| | |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 01/05/2007 9:18:30 AM
Posts: 10, Visits: 40 |
| | |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 01/05/2007 9:18:30 AM
Posts: 10, Visits: 40 |
| | Hi Nikki (Third Time lucky)  Check that advanced options are made available and ensure that the search field is set to "Beginswith" - see the browse dialog help. This will effectively ensure that a LIKE comparison is performed instead of an equals. If you don't, it will look for a value that is exactly equal to "A" instead of LIKE "A%". HTH -=Gary |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 01/05/2007 9:18:30 AM
Posts: 10, Visits: 40 |
| | Hi Nikki Ensure that the field selection is set to "Beginswith". This will ensure that the query uses a LIKE "A%" or similar as opposed to an = "A". Checkout the BrowseDialog help in the guide which makes reference to this. HTH -=Gary |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:50:35 PM
Posts: 4,796, Visits: 4,766 |
| | Gary is correct, the first place to look is the BeginsWith that is set within the SearchFields property of the BrowseDialog control. SQL commands are dynamically created based on the Advanced options that are active for each search field. If no value is entered within a search field, no WHERE clause is added for the field. So if you enter something in the field, it will use the Advanced option (even if you do not allow the end-user to change the advanced option) to build that segment of the WHERE clause. |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 05/12/2006 5:35:50 PM
Posts: 13, Visits: 18 |
| | I believe that is how i have it set up. Here are a few screen shots that hopefully illustrate the settings I have. 
|
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:50:35 PM
Posts: 4,796, Visits: 4,766 |
| | Actually you need to go a little deeper to get to the BeginsWith option. Selection your SearchFields property and then clik the "..." next to it. This will bring up an editor. Select your search field, and then click the edit button, this will bring up the window in question It will look something like this: 
Make sure that the BeginsWith is set and that it is not set to equals or something of that nature. Hope this helps. |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 05/12/2006 5:35:50 PM
Posts: 13, Visits: 18 |
| | That is exactly how it is set. Just to make sure here is a shot of that window. If I run the following Query in Sql Server it return the expected results. SELECT *
FROM customer
WHERE (cuname LIKE 'A%') 
|
| |
| | |
|