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
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.