SinglePaymentPV
Syntax
SinglePaymentPV(int_rate, n_per)
Description
Use the SinglePaymentPV function to calculate the future value of a single monetary unit after a specified number of periods at a specified interest rate.
Parameters
|
Field or Control |
Definition |
|---|---|
| int_rate |
A number representing the interest rate at which value is accrued per period. |
| n_per ... |
SortScroll
Syntax
SortScroll(level, scrollpath, sort_fields)
Where scrollpath is:
[Record.level1_recname, [Record.level2_recname,] Record.target_recname
and where sort_fields is a list of field specifiers in the form:
[recordname.]field_1, order_1 [, [recordname.]field_2, order_2]. . .
Description
The SortScroll function programmatically sorts the rows in a scroll area on the active page. The rows ...
Split
Syntax
Split(string, separator)
Description
Use the Split function to convert a string into an array of strings by looking for the string separator in the given string.
Note: Split does not split an array.
If separator is omitted, a blank is used.
If separator is a null string (""), the ...
SQLExec
Syntax
SQLExec({sqlcmd | SQL.sqlname}, [bindexprs [, outputvars]])
where bindexprs is a list of expressions, one for each :n reference within sqlcmd or the text found in the SQL defintion sqlname, in the form:
inexpr_1 [, inexpr_2]. . .
and where outputvars is a list of variables, record fields, or record object references, one ...
Sqrt
Syntax
SQRT(n)
Description
Use the Sqrt function to calculate the square root of a number.
Parameters
|
Field or Control |
Definition |
|---|---|
| n |
A number of which you want to find the square root. |
Returns
Returns a number equal to the positive square root of n . If n is a negative ...
StartWork
Syntax
StartWork()
Description
Use the StartWork function to mark the start of a unit of work.
Once this function is executed, no updates to the database are allowed until a unit of work is completed. A unit of work is completed by an event completing (such as a FieldChange event ...
Step
Description
Use the Step keyword in for loops. See for more information.
StopFetching
Syntax
StopFetching()
Description
The StopFetching function is called during Row Select processing, during which rows of data that have been selected down from the database can be filtered as they are added to the component. This function is valid only in RowSelect PeopleCode. If StopFetching is called without DiscardRow, it ...
StoreSQL
Syntax
StoreSQL(sqlstring, [SQL.]sqlname[, dbtype[, effdt [, ownerid [, description]]]])
Description
Use the StoreSQL function to write the given sqlstring value to a SQL definition, storing it under the name sqlname , with the database type dbtype and the effective date effdt . If sqlname is a literal name, it must be in ...
String
Syntax
String(value)
Description
Use the String function to convert any non-string data type (except an object data type) to a string.
Normally the Component Processor automatically handles data type conversions. However, for some operations, such as comparisons, you want to specify the data type explicitly. Assume, for example, that ...