company logo

Run OSI statement(s) (OSI)

The command allows running an OSI expression for the selected collection. One operand on the same line may follow the OSI command. For running complex expressions, a list of statements can be included in a DO - END or BEGIN - END block.

Parameters:

  • expression - The expression must be an osi expression. Expressions containing special characters must be quoted ( no semicolon at the end!). The expression must be defined completely on the same line.
  • statement - A valid OSI statement or a block of statements enclosed in BEGIN / DO - END. .
  • -Dn - re-direction to other data source.
  • -Cn - re-direction to other collection in the hierarchy or in the data source referenced by -Dn.

Syntax:

  osi expression  // single osi call

  osi do          // block of statements

  ...             // osi statements

  end             // end of block

Examples:

  osi TotalIncome  // call OSI function defined for the currently

                   // selected data type

  // call OSI expression with special characters

  osi "if count > 0 Message('Income: ' + (string)TotalIncome)"

  // call OSI with statement(s) returning a view result

  osi do

    select (name, first_name)

    from  (Person)

    where (name > 'H');

  end

  fa p             // show results

Notes:

Since OSI command works on current collection (except in case of BEGIN block), the selection for the current collection may have changed. Moreover, OSI commands may change database content.