Routines for tree_wdb.kb


AddTreeLeaf

File Name

tree_wdb.kb

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


DeleteBaseRecord

File Name

tree_wdb.kb

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


DeleteTreeLeaf

File Name

tree_wdb.kb

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


HasChildren

File Name

tree_wdb.kb

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


SetChildrenOrganizations

File Name

tree_wdb.kb

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