COLUMNEXISTS |
Session - function ColumnExists |
Arguments:
Name |
Required |
Type |
Default |
columnName |
Required |
string |
|
tablename |
Optional |
string |
[runtime expression] |
primaryKey |
Optional |
string |
[runtime expression] |
|
ReturnType: |
numeric
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
yes |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
CREATEPASSWORD |
Session - function CreatePassword |
Arguments: | none |
ReturnType: |
string
|
Roles: |
|
Access: |
remote |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
CREATEPERSONSUUID |
Session - function CreatePersonsUUID |
Arguments: | none |
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
CREATERANDOMPASSWORD |
Session - function CreateRandomPassword |
Arguments: | none |
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
CREATESQLSTATEMENTARRAY |
Session - function CreateSQLStatementArray |
Arguments:
Name |
Required |
Type |
Default |
fieldList |
Optional |
string |
[empty string] |
|
ReturnType: |
array
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
yes |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
CREATEUSERNAME |
Session - function CreateUsername |
Arguments:
Name |
Required |
Type |
Default |
firstname |
Optional |
string |
[runtime expression] |
lastname |
Optional |
string |
[runtime expression] |
email |
Optional |
string |
[runtime expression] |
|
ReturnType: |
string
|
Roles: |
|
Access: |
remote |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
DBDELETE |
Session - function DBDelete |
Arguments:
Name |
Required |
Type |
Default |
id |
Required |
numeric |
|
dumpResult |
Optional |
boolean |
false |
|
ReturnType: |
void
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
DBDELETEPERSONAGEGROUPS |
Session - function DBDeletePersonAgeGroups |
Arguments:
Name |
Required |
Type |
Default |
personID |
Required |
numeric |
|
|
ReturnType: |
void
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
DBINSERT |
Session - function DBInsert |
Arguments: | none |
ReturnType: |
numeric
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
DBINSERTPERSONAGEGROUP |
Session - function DBInsertPersonAgeGroup |
Arguments:
Name |
Required |
Type |
Default |
personID |
Required |
numeric |
|
ageGroupID |
Required |
numeric |
|
|
ReturnType: |
void
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
DBUPDATE |
Session - function DBUpdate |
Arguments:
Name |
Required |
Type |
Default |
personID |
Optional |
numeric |
[runtime expression] |
fieldList |
Optional |
string |
[empty string] |
|
ReturnType: |
void
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
FORMATBACBNUMBER |
Session - function FormatBACBNumber |
Arguments:
Name |
Required |
Type |
Default |
bacbNumber |
Required |
string |
|
|
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETADDRESS |
Session - function GetAddress |
Arguments:
Name |
Required |
Type |
Default |
addressType |
Required |
string |
|
personID |
Optional |
numeric |
[runtime expression] |
|
ReturnType: |
any
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETADMINCONTACT |
Session - function GetAdminContact |
Arguments:
Name |
Required |
Type |
Default |
personID |
Optional |
numeric |
[runtime expression] |
|
ReturnType: |
any
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETALLASSTRUCT |
Session - function GetAllAsStruct |
Arguments: | none |
ReturnType: |
struct
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
|
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETALLRECORDS |
Session - function GetAllRecords |
Arguments:
Name |
Required |
Type |
Default |
tablename |
Optional |
string |
[runtime expression] |
|
ReturnType: |
query
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETBILLINGCONTACT |
Session - function GetBillingContact |
Arguments:
Name |
Required |
Type |
Default |
personID |
Optional |
numeric |
[runtime expression] |
|
ReturnType: |
any
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETCFSQLTYPE |
Session - function GetCFSqlType |
Arguments:
Name |
Required |
Type |
Default |
mssqltype |
Required |
string |
|
arrDataTypes |
Optional |
array |
[runtime expression] |
|
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETCOLUMNEXTENDEDPROPERTY |
Session - function GetColumnExtendedProperty |
Arguments:
Name |
Required |
Type |
Default |
qryProps |
Required |
query |
|
columnName |
Required |
string |
|
propertyName |
Required |
string |
|
|
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
yes |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETCOLUMNLIST |
Session - function GetColumnList |
Arguments:
Name |
Required |
Type |
Default |
tablename |
Optional |
string |
[runtime expression] |
|
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETCOMPLETEDCOURSES |
Session - function GetCompletedCourses |
Arguments:
Name |
Required |
Type |
Default |
personID |
Required |
numeric |
|
|
ReturnType: |
query
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETCOMPLETEDCOURSESBYUSERNAME |
Session - function GetCompletedCoursesByUsername |
Arguments:
Name |
Required |
Type |
Default |
username |
Required |
string |
|
|
ReturnType: |
query
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETCOMPONENTPATH |
Session - function GetComponentPath |
Arguments: | none |
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETDETAILS |
Session - function getDetails |
Arguments:
Name |
Required |
Type |
Default |
personID |
Optional |
numeric |
[runtime expression] |
|
ReturnType: |
void
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETEMPTYQUERY |
Session - function GetEmptyQuery |
Arguments:
Name |
Required |
Type |
Default |
tablename |
Optional |
string |
[runtime expression] |
fieldList |
Optional |
string |
[empty string] |
|
ReturnType: |
query
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETEXTENDEDPROPERTIESALLCOLUMNS |
Session - function GetExtendedPropertiesAllColumns |
Arguments:
Name |
Required |
Type |
Default |
tablename |
Optional |
string |
[runtime expression] |
|
ReturnType: |
query
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
yes |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETFIELDMETADATA |
Session - function GetFieldMetadata |
Arguments:
Name |
Required |
Type |
Default |
fieldList |
Optional |
string |
[empty string] |
|
ReturnType: |
array
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETFIELDVALUES |
Session - function GetFieldValues |
Arguments:
Name |
Required |
Type |
Default |
pkvalue |
Required |
numeric |
|
fields |
Required |
string |
|
|
ReturnType: |
struct
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETINFO |
Session - function GetInfo |
Arguments:
Name |
Required |
Type |
Default |
id |
Required |
numeric |
|
columns |
Optional |
string |
* |
|
ReturnType: |
query
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETMAXCONTACT |
Session - function GetMaxContact |
Arguments: | none |
ReturnType: |
numeric
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETOBJECTPATH |
Session - function GetObjectPath |
Arguments:
Name |
Required |
Type |
Default |
theObj |
Optional |
any |
[runtime expression] |
|
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
yes |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETRANDOMDIGIT |
Session - function GetRandomDigit |
Arguments: | none |
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETRANDOMLETTER |
Session - function GetRandomLetter |
Arguments: | none |
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
GETRANDOMSPECIALCHAR |
Session - function GetRandomSpecialChar |
Arguments: | none |
ReturnType: |
string
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
IDEXISTSINDATABASE |
Session - function IDExistsInDatabase |
Arguments:
Name |
Required |
Type |
Default |
id |
Required |
string |
|
|
ReturnType: |
boolean
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
IDISVALID |
Session - function IDIsValid |
Arguments:
Name |
Required |
Type |
Default |
id |
Required |
any |
|
zeroIsValid |
Optional |
boolean |
true |
|
ReturnType: |
boolean
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
no |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
INIT |
Session - function Init |
Arguments:
Name |
Required |
Type |
Default |
id |
Optional |
string |
[empty string] |
|
ReturnType: |
any
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
yes |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
TABLEEXISTS |
Session - function TableExists |
Arguments:
Name |
Required |
Type |
Default |
tablename |
Optional |
string |
[runtime expression] |
|
ReturnType: |
numeric
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
|
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
VALIDATECONTACT |
Session - function ValidateContact |
Arguments:
Name |
Required |
Type |
Default |
personID |
Required |
any |
|
|
ReturnType: |
numeric
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
false |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
VALIDATECOURSEEMAIL |
Session - function ValidateCourseEmail |
Arguments:
Name |
Required |
Type |
Default |
email |
Required |
string |
|
courseID |
Optional |
numeric |
0 |
|
ReturnType: |
numeric
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
true |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|
VALIDATELOGIN |
Session - function ValidateLogin |
Arguments:
Name |
Required |
Type |
Default |
username |
Required |
string |
|
password |
Required |
string |
|
courseID |
Optional |
numeric |
0 |
|
ReturnType: |
numeric
|
Roles: |
|
Access: |
public |
Static: |
false |
Output: |
true |
DisplayName: |
|
Hint: |
|
Description: |
|
|
|