Routines for ext_udb.kb


FindNetCensusSMSInventoryRecord

File Name

ext_udb.kb

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


GetExistingMapRecord

File Name

ext_udb.kb

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


GetInventoryRecordsCount

File Name

ext_udb.kb

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


InsertExternalMap

File Name

ext_udb.kb

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


TIV_Build_Select

File Name

ext_udb.kb

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