Days
Syntax
Days(dt_val)
Description
Use the Days function to returns the Julian date for the dt_val specified. This function accepts a Date, DateTime, or Time value parameter.
Returns
Returns a Number value equal to the Julian date for dt_val .
Days360
Syntax
Days360(date_val1, date_val2)
Description
Use the Days360 function to return the number of days between the Date values date_val1 and date_val2 using a 360-day year (twelve 30-day months). Use this function to help compute payments if your accounting system is based on twelve 30-day months ...
Days365
Syntax
Days365(date_val1, date_val2)
Description
Use the Days365 function to return the number of days between the Date values date_val1 and date_val2 using a 365-day year. Use this function to help compute payments if your accounting system is based on a 365-day year.
If date_val2 occurs ...
DBCSTrim
Syntax
DBCSTrim(source_str)
Description
Note: This function has been deprecated.
Use the DBCSTrim function to remove a trailing DBCS lead byte at the end of the string.
DBPatternMatch
Syntax
DBPatternMatch(Value, Pattern, CaseSensitive)
Description
Use the DBPatternMatch function to match the string in Value to the given pattern.
You can use wildcard characters % and _ when searching. % means find all characters, while _ means find a single character. For example, if you wanted to find if the string ...
DeChunkText
Syntax
DeChunkText(table_name, seq_field, data_field, &array_of_keys, &array_of_key_datatypes, &array_of_key_values)
Description
Use the DeChunkText function to read the chunks created by the ChunkText function from a database table and assemble them back into a long text string.
Parameters
Field or Control |
Definition |
---|---|
table_name |
Specify the name of the database table as a ... |
Declare Function
Syntax
PeopleCode Function Syntax
Declare Function function_name PeopleCode record_name.field_name event_type
External Library Function Syntax
Declare Function function_name Library lib_name [Alias module_name] [paramlist] [Returns ext_return_type [As pc_type]]
In which paramlist is:
([ext_param1 [, ext_param2] . . .)
And in which ext_param1 , ext_param2 , and so on is:
ext_datatype [{Ref|Value}] [As pc_return_type]
Description
PeopleCode can ...
Decrypt
Syntax
Decrypt(KeyString, EncryptedString)
Description
Use the Decrypt function to decrypt a string previously encrypted with the Encrypt function. This function is generally used with merchant passwords. For this function to decrypt a string successfully, you must use the same KeyString value used to encrypt the string.
Parameters
Field or ... |
---|
Degrees
Syntax
Degrees(angle)
Description
Use the Degrees function to convert the given angle from radian measurement to degree measurement.
Parameters
Field or Control |
Definition |
---|---|
angle |
The size of an angle in radians. |
Returns
The size of the given angle in degrees.
DeleteAttachment
Syntax
DeleteAttachment(URLSource, DirAndSysFileName[, PreserveCase])
Description
Use the DeleteAttachment function to delete a file from the specified storage location.
DeleteAttachment does not generate any type of âAre you sure?â message. If you want the end user to verify the deletion before it is performed, you must write your ...