File Name
Syntax
AddTreeLeaf(REF Intran: BOOLEAN, VAL Table: STRING, REF Tree: TreeRec, VAL sourceTreeRec: ExpandRec, VAL destTreeRec: ExpandRec)
Parameters
Intran - in a transaction or not
Table - database table name
Tree - tree record
sourceTreeRec - original tree record
destTreeRec - new tree record
Returns
SQL
Side Effects
None
Description
This function is used to associate a child ID with a parent ID therefore creating a "leaf" in the specified table.
Dialog Forms Called
None
File Name
Syntax
DeleteBaseRecord(VAL InTran: BOOLEAN, VAL Table: STRING, VAL where: STRING)
Parameters
Intran - in a transaction or not
Table - data base table name
where - WHERE clause
Returns
SQL
Side Effects
None
Description
This function is used to delete a record from the specified tree table.
Dialog Forms Called
None
File Name
Syntax
DeleteTreeLeaf( REF Intran: BOOLEAN, VAL Table: STRING, REF Tree: TreeRec)
Parameters
Intran - in a transaction or not
Table - data base table name
Tree - tree record
Returns
SQL
Side Effects
None
Description
This function is used to delete a parent / child association from the specified table.
Dialog Forms Called
None
File Name
Syntax
HasChildren(VAL Table: STRING, VAL Child: STRING)
Parameters
Table - data base table name
Child - parent ID
Returns
TRUE if parent ID has children, FALSE if parent ID
does not have children
Side Effects
None
Description
This function is used to determine if the parent ID has any child records associated with it.
Dialog Forms Called
None
File Name
Syntax
SetChildrenOrganizations(VAL wHdl: WINDOW, VAL table: STRING, VAL column: STRING, VAL ID: STRING, VAL organizationID: STRING)
Parameters
wHdl - window handle
table - data base table name
column - data base table column name
organizationID - organization ID
Returns
SQL
Side Effects
None
Description
This function updates the specified table.
Dialog Forms Called
None