File Name
Syntax
AssembleSelect(VAL Args: LIST OF STRING)
Parameters
Args - arguments to assemble into a select statement
Returns
STRING
Side Effects
None
Description
The various strings in the list are assembled into one select statement. All strings are considered to be self-contained where fragments except for: Args[1] - The select clause (select 'x' from 'y')
Dialog Forms Called
None
File Name
Syntax
DateClause(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
Where clause fragment
Returns
STRING
Side Effects
None
Description
Generates a Where statement fragment that allows searching based on a date clause.
Dialog Forms Called
None
File Name
Syntax
DetermineSelectList(VAL aid_type: INTEGER);
Parameters
aid_type: type of aid that is being looked up
Returns
STRING
Side Effects
None
Description
This function determines if there is a list of aids in the databse, or just a count.
Dialog Forms Called
None
File Name
Syntax
ExactScimClause(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
WHERE clause fragment
Returns
STRING
Side Effects
None
Description
Generates a WHERE statement fragment that allows searching based on an exact SCIM match
Dialog Forms Called
None
File Name
Syntax
FuzzyLocationClause(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
WHERE clause fragment
Returns
STRING
Side Effects
None
Description
Generates a WHERE statement fragment that allows searching based on a fuzzy location match.
Dialog Forms Called
None
File Name
Syntax
FuzzyScimClause(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
WHERE clause fragment
Returns
STRING
Side Effects
None
Description
Generates a WHERE statement fragment that allows searching based on a fuzzy SCIM match.
Dialog Forms Called
None
File Name
Syntax
GenerateADLSCIMClause(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
WHERE clause fragment
Returns
STRING
Side Effects
None
Description
Generates the SCIM where String that the ADL DLL requires on an ADLMatch call.
Dialog Forms Called
None
File Name
Syntax
GenerateCommonSelect(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
WHERE clause fragment
Returns
STRING
Side Effects
None
Description
Generates the select statement required to get a list of common problems from the database.
Dialog Forms Called
None
File Name
Syntax
GenerateErrorSelect(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
WHERE clause fragment
Returns
STRING
Side Effects
None
Description
Generates the select statement required to get a list of error messages out of the database
Dialog Forms Called
None
File Name
Syntax
GenerateHNSelect(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
WHERE clause fragment
Returns
STRING
Side Effects
None
Description
Generates the select statement required to get a list of Hot News from the database.
Dialog Forms Called
None
File Name
Syntax
GenerateHyperSelect(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
WHERE clause fragment
Returns
STRING
Side Effects
None
Description
Generates the select statement required to get a list of HyperNodes from the database.
Dialog Forms Called
None
File Name
Syntax
GroupClause(VAL Prob: DIAG_MATCH_TYPE);
Parameters
Prob - defines the context for which to generate the
WHERE clause fragment
Returns
STRING
Side Effects
None
Description
Generates a WHERE statement fragment that allows searching based on a group clause.
Dialog Forms Called
None
File Name
Syntax
RequestAid2T(VAL AidContext, REF Aids: CLIENT_RECORD);
Parameters
AidContext - diagnostic context in which the lookup is based.
Aids - resulting list of aids
Returns
INTEGER
Side Effects
None
Description
Aids are looked up based on DiagContext. If an error occurs, a negative value is returned.
Dialog Forms Called
None