Locating Formulas and Identifiers

The QABUTIL Find menu offers the following facilities:


FIND/CHANGE

1 Identifier in formulas
2 Anything in formulas
3 Tables in procedures
4 Rename identifier
5 Change local variable
6 Options
8 Exit (X)
9 Help

The first two options provide the additional facility to edit the formula. This makes it easy for you to make global changes to the formulas used across the programs and procedures on your database.

Find an Identifier

The first Find option prompts for the identifier name and then shows the first procedure body that uses the identifier:

Use the cursor keys to scan through the complete set of procedure bodies which use the identifier. You have the following options for each formula found:

Formula Usage This option pops up a window showing where the formula appears in your procedure
Containing Programs This option pops up a list of all the programs that use the current procedure body
Edit This option allows you to edit the formula

Find Text in a Formula

The second Find option prompts you for a search string. If the string is terminated with a ^ character, QABUTIL will find and display each formula using the string. As in the previous option, use the cursor keys to scan through the formulas found.

Find Tables in Procedure Bodies

The Tables in Procedures option on the Find menu displays the usage of the specified table in each procedure body.

Rename Identifier and Change Local Variables

Options 5 and 6 on the Find menu allow you to make global changes to the variables used in your program

Options to Limit Search

Options provides the following controls which affect the scope of the search:

QAB Find/Change options
Search type Global
Search area -
Case sensitive find/change ? 
Confirm each change ? Yes
Letter to terminate find string ^

The options for finding items within formulas are:

Search Type

The search types allow you to restrict any finds or changes to one program or procedure. You may wish to use this if you are working on a database with other developers. You can also restrict finds or changes to macros only

Search Area

This option allows you to restrict the search area to the program or procedure body on which you are working

Case Sensitive 

This option is set to No by default, set to Yes if you wish to match on case

Confirm each Change 

This option is set to Yes by default. This is useful where you are making global changes, and wish to check each occurrence of an identifier. Change this to No if you do not need this facility

Letter to Terminate 

This option allows you to change the character used to indicate search string termination