File Name
Syntax
FindNetCensusSMSInventoryRecord( VAL id: STRING, REF is_inventory_idList: LIST OF INTEGER )
Parameters
id - SMS or NetCensus ID
is_inventory_idList - list of inventory IDs
Returns
SQL return result
Side Effects
None
Description
This procedure assumes that the connection is to the TAM database and not to the NetCensus database.
Dialog Forms Called
None
File Name
Syntax
GetExistingMapRecord( VAL external_app_name: STRING, VAL sql_cfg_name: STRING, VAL ext_id_1: STRING, VAL ext_id_2: STRING, VAL ext_id_3: STRING, VAL ext_id_4: STRING, VAL ext_id_5: STRING, VAL ext_id_6: STRING, VAL ext_id_7: STRING, VAL ext_id_8: STRING, VAL ext_id_9: STRING, VAL ext_id_10: STRING, VAL is_inventory_id: INTEGER, VAL people_id: INTEGER, VAL location_id: STRING )
Parameters
external_app_name - external application name
sql_cfg_name - SQL configuration name
ext_id_1
ext_id_2
ext_id_3
ext_id_4
ext_id_5
ext_id_6
ext_id_7
ext_id_8
ext_id_9
ext_id_10
is_inventory_id - is inventory id
people_id - people ID
location_id - location ID
Returns
External map record
Side Effects
None
Description
This function takes the input parameters, builds a select statement, and searches against the EXTERNAL_MAP. The record found, if any is returned.
Dialog Forms Called
None
File Name
Syntax
GetInventoryRecordsCount
Parameters
None
Returns
SQL return result
Side Effects
None
Description
This procedure returns the number of inventory records that exist in the is_inventory table.
Dialog Forms Called
None
File Name
Syntax
InsertExternalMap( VAL InTran: BOOLEAN, REF external_map: ExternalMapRec )
Parameters
InTran - in a transaction or not
external_map - external map record
Returns
SQL return result
Side Effects
None
Description
This function inserts the EXTERNAL_MAP record passed in and handles any database errors.
Dialog Forms Called
None
File Name
Syntax
TIV_Build_Select( VAL columns: STRING, VAL tablename: STRING, VAL where: STRING, VAL orderby: STRING )
Parameters
columns - the columns to select from. Defaults to '*'
tablename - the table to select from.
where - the where. If none, not included in result.
orderby - the orderby. If none, not included in result.
TIV_Build_Select - the resulting SQL select statement
Returns
TRUE = successful. FALSE = unsuccessful.
Side Effects
None
Description
This function builds a standard SQL select statement based on data passed to it.
Dialog Forms Called
None