SQL Searches in Progression

[ultrav]

Since we changed to SQL the searches have been a problem for my Customer service staff- since they add orders in on the fly - they have really been frustrated by the searches. Is there a way to have the search come up blank and wait for the data before running the search? Right now - the search runs using blank as the search parameter and will not take any input until the search has run. It also does not hold whatever has been typed so you end up searching on the last letters you typed instead of the whole word (eg. 6B instead of MP36B). Does anyone have any suggestions?

Celeste

 

[dgillz]

If you click on the drop down box and use the 'contains' operator, you will only get the items that contain in your case '6B'.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[SusanD5320]

If you haven't already done so, you might want to limit the search results in the box for "Row Limit". If it's set to Unlimited, it has to return all the records before you can begin another search option. Mine is usually set on 500 and only takes a couple seconds to return all those rows.

 

[stravis]

Another approach is to revert to the old search method for the order entry item lookup. Doing so requires deleting the new search information from the database and forcing Macola to use the old search definition. To do this run the following sql script in query analyzer after having backed up the [Screens].[SYSQLSRCH_SQL] table.
<code>
use screens
DELETE sqlsrch_sql where search_field_id = 'OE-ITEM'
</code>
If you want the old search back you will need to restore it from the backup you created.

I would suggest trying SusanD5320's solution first though and determine if it works for you. The new search is very powerful, but it does take some getting used to.

Scott Travis

http://www.infospring.net