Searcharticlebydescription

Form SearchArticleByDescription

• Unit name: Forms.SearchArticleByDescription
• Form name: SearchArticleByDescriptionDialog
• Old form name: unit47 (form47)

Synopsis

Form to search an article, based on description name.

Functionalities

1. Edit box to enter article description. On Enter key, execute SearchArticles action.
2. Button to execute SearchArticles action.
3. Grid to display result. on double click, execute ShowDetails action.
4. Button to execute OK ction.
5. Button to execute Cancel action.

Actions

SearchArticles

1. Enabled when the article description edit has at least 2 characters in it.
2. When executed, open SearchArticleByDescription view using the contents of the edit box as search term, and display results in the grid.

OK

1. Enabled when an article is selected in the grid.
2. Closes form with Modalresult=mrOK.

Cancel

1. Always enabled.
2. Closes form with Modalresult=mrCancel.

Tables/Views

• SearchArticleByDescription

  SELECT  
    ID, NAME, NAME2
  FROM
    ARTICLE
  WHERE
   name2 LIKE '%'+:SearchTerm+'%'
  ORDER BY name
  

Needed Service Calls

Call 1

Call 2

Reports