Screen Builder Solver

Cautions on Screen Editing

If you remove a user defined field from your display or change its name, and save the new screen all information relating to that field will be lost!

Also, if you change the field type: for example, convert a character field to a numeric field, information will also be lost, since characters other than 0-9, - (minus) and . (dot) cannot be converted to numbers.

Make a back-up of your data before you edit screens that contain preexisting user input--just in case you accidentally alter field information you may need to recover.

If you have customised your forms to include user defined field information that you then remove, then of course, CAPITAL will report warnings when printing these forms. You may need to adjust your forms as well.

Implementing Multi-Field Matching

CAPITAL allows you to design sets of fields that can be searched simultaneously. This is useful when you need to define multiple fields containing the same or similar information.

For example, imagine you need to track a series of related serial numbers, product codes or other references like so:

Serial Number #1:

Serial Number #2:

Serial Number #3:

It would handy if any of the above serial number fields could be selected by the operator when the Find button was pressed, and have CAPITAL search all three fields simultaneously. This would eliminate the need to do the same search three times; once for each field.

CAPITAL permits multi-field searches provided that the field names you use are consistently named like so:

SERIAL1, SERIAL2, SERIAL3, etc.

You may have up to 11 fields that will be scanned simultaneously. The field names SERIAL and SERIAL0 are also acceptable and would be included in the search.

If you wanted to create, say, 3 model number fields to be simultaneously searched, then you would also name them like so:

MODEL, MODEL2, MODEL3. Or MODEL0, MODEL1, MODEL2... up to MODEL9

MODEL10, however, would not be acceptable as you may only specify 1 numeric digit after the field name.

The other required conditions are:

• All fields must be sorted in ascending or descending order.

• All fields must be of the same type. That is, they must all be character, or numeric or date fields, etc. Fields of different types will not be searched.