Executing Queries Online 

Procedure

Three functions are available to execute a query online:

●      Execute

●      Execute with Variant 

If you choose the Execute with Variant function, a dialog box appears in which you can enter the name of the variant (more information: Variants).

●      Test

This function allows you to determine the maximum number of read accesses to the database and thus is especially useful for test purposes.

After calling up the function, a dialog box appears in which you can specify the maximum number of data records to be read. Each individual record is considered a database access. If you are using a logical database to select data from multiple tables, all records from the tables used are counted. The system terminates data selection when the maximum number of selections has been reached. You can also enter a variant in this box if you want to execute with a variant (See Variants

You can create one standard variant per query. This standard variant is always used when you choose Execute.

If you select Exec. with variant, the system sets the standard variant as the default value (more information: Assigning Title, Format, and Notes ).