CodeCharge Studio

Search Builder

Search forms are used to enter values into controls to search and retrieve records from a database. Search forms are used in conjunction with grid or record forms. The search form is used to submit the search criteria and the grid or record form displays the retrieved records that match the search criteria.

The Search Builder can create complex search forms that determine the number of records to be displayed per page, the order the records are displayed and the SQL operator to be used to perform the search. To begin the process of creating a search form, click on the Search Builder option in Builders tab of the Toolbox.

Step 1: Selecting a Database Connection

Select or create the database connection for the search. You can select one of the existing database connections, create a new connection or select one of the sample databases.
Option Description
Use an existing database connection Select previously configured database connection.
Create... Create a new database connection.
or select a sample database (Internet/Intranet) Use one of the example databases provided with CodeCharge Studio as an alternative to selecting an existing database connection.

If this option is selected the database connection will be created automatically.

Internationalized Create internationalized version by using resource translation keys in place of text.
Save builder options Preserve the options selected in steps 1 through 4 of the builder. The options will be automatically pre-selected the next time you use the Search Builder.

Click Next to proceed to step 2.

Step 2: Search Builder Fields

This is the main step and involves selecting fields to be shown in the form and other display options.

Search Builder Field Settings

Parameter Description
Table Database tables whose fields will be used in the search form.
Sorting list box Gives the search form two list-boxes for sorting. The first  will contain a list of all the available fields so that the user can select the field to sort by. The second list-box will indicate the desired sort order (ASC, DESC).
Records per page list box The search form will have a list-box that can be used to specify the number of records to be returned per page.
Orientation Specifies vertical or horizontal orientation of the search form.
Advanced... Advanced search option such as submit method, type and other properties. If AND is selected, the search form will have an input form control for all the fields.

If OR is selected, the search form will have only one input form control. Any value entered into the single control will be used to search against all the fields in the form. After you set the advanced options click Preview to view the form with your selected option.

Available Fields This list-box shows all the fields available in the table or view.
Search Fields These are the fields to be shown in the search form. They are selected from among the Available Fields.
Select an Available Field then click this button to add it to the form.
Click this button to add ALL Available Fields to the form.
Select a form field then click this button to remove it from the form.
Click this button to remove all fields from the search form.
Select a form field then click this button to move it upwards in the order of appearance.
Select a form field then click this button to move it downwards in the order of appearance.
Control Type Control type to be used for each of the fields in the form.

Click Next to proceed to step 3.

Step 3: Selecting a Grid Form (optional)

Select a page and a grid form to which the search will apply. You can skip this step if the form is not yet available or you intend to use the search form for a different purpose.

Click Next to proceed to step 4.

Step 4: Selecting a Style (optional)

Select a style to be used to display the form.

Click Finish to close the builder and generate the search form.


On-line, printable versions and updates