ExpandBindVar
Syntax
ExpandBindVar(str)
Description
Inline bind variables can be included in any PeopleCode string. An inline bind variable is a field reference (in the form recordname.fieldname ), preceded by a colon. The inline bind variable references the value in the field.
Use the ExpandBindVar function to expand any inline bind ...
ExpandEnvVar
Syntax
ExpandEnvVar(string)
Description
Use the ExpandEnvVar function to convert any environment variables that it finds within string into String values and returns the entire resulting string.
Parameters
|
Field or Control |
Definition |
|---|---|
| string |
A string containing an environment variable. |
Returns
Returns a string equal to string with any enclosed environment ...
ExpandSqlBinds
Syntax
ExpandSqlBinds(string)
Description
Prior to PeopleTools 8.0, the PeopleCode replaced runtime parameter markers in SQL strings with the associated literal values. For databases that offer SQL statement caching, a match was never found in the cache so the SQL had to be re-parsed and re-assigned a query path ...
Fact
Syntax
Fact(x)
Description
Use the Fact function to return the factorial of a positive integer x. The factorial of a number x is equal to 1*2*3*...* x . If x is not an integer, it is truncated to an integer.
Returns
Returns a Number equal to the factorial ...
FetchSQL
Syntax
FetchSQL([SQL.]sqlname[, dbtype[, effdt]] )
Description
Use the FetchSQL function to return the SQL definition with the given sqlname as SQL. sqlname or a string value, matching the dbtype and effdt . If sqlname is a literal name, it must be in quotes.
Parameters
|
Field or Control |
Definition |
|---|---|
| sqlname |
Specify ... |
FetchValue
Syntax
FetchValue(scrollpath, target_row, [recordname.]fieldname)
where scrollpath is:
[RECORD.level1_recname, level1_row, [RECORD.level2_recname, level2_row, ]] RECORD.target_recname
To prevent ambiguous references, you can also use SCROLL . scrollname , where scrollname is the same as the scroll levelâs primary record name.
Description
Use the FetchValue function to return the value of ...
FieldChanged
Syntax
The syntax of the FieldChanged function varies depending on whether you want to use a scroll path reference or a contextual reference to specify the field.
If you want to use a scroll path reference, the syntax is:
FieldChanged(scrollpath, target_row, [recordname.]fieldname)
where scrollpath is:
[RECORD.level1_recname, level1_row ...FileExists
Syntax
FileExists(filename [, pathtype])
Description
Use the FileExists function to determine whether a particular file or directory is present on your PeopleSoft system, so, in the case of a file, you can decide which mode to use when you open the file for writing or whether the file is available ...
Find
Syntax
Find(string, within_string [, number])
Description
Use the Find function to locate one string of text within another string of text and returns the character position of the string as an integer. Find is case-sensitive and does not allow wildcards.
If you need to do either case-sensitive search or pattern ...