Routines for con_brdb.kb


GetConName

File Name

con_brdb.kb

Syntax

GetConName(VAL id: STRING)

Parameters

id - connection ID

Returns

SQLSelectInto return result

Side Effects

None

Description

This function gets a connection name based on the connection ID passed in.

Dialog Forms Called

None


GetConnection

File Name

con_brdb.kb

Syntax

GetConnection(REF ktype: ConnectionRec,VAL ID: STRING)

Parameters

ktype - connection record

ID - connection ID

Returns

ktype , SQLSelectInto return result

Side Effects

None

Description

This function gets a connection record for the selected connection ID.

Dialog Forms Called

None


GetConnectionID

File Name

con_brdb.kb

Syntax

GetConnectionID(REF connection_id: STRING, VAL name: STRING)

Parameters

connection_id - connection ID

name - connection name

Returns

SQLSelectInto return result, connection_id

Side Effects

None

Description

This function gets connection ID based on the connection name passed in.

Dialog Forms Called

None


GetConnectionIdViaAlternateName

File Name

con_brdb.kb

Syntax

GetConnectionIdViaAlternateName( REF connection_id: STRING, VAL alt: STRING)

Parameters

connection_id - connection ID

alt - alternate connection

Returns

SQLSelectInto return result

Side Effects

None

Description

This function gets a connection ID based on the alternate connection ID passed in.

Dialog Forms Called

None


GetConnectionList

File Name

con_brdb.kb

Syntax

GetConnectionList(REF ktypeList: LIST OF ConnectionRec)

Parameters

ktypelist - list of connection records

Returns

ktypeList, SQLSelect return result

Side Effects

None

Description

This function gets a list of all connection records in the connection table.

Dialog Forms Called

None


GetSomeConnectionList

File Name

con_brdb.kb

Syntax

GetSomeConnectionList(REF lst: LIST OF ConnectionRec, VAL where: STRING, VAL wHdl: WINDOW, VAL organizationID: STRING )

Parameters

lst - list of connection records

where - Where clause of select statement

whdl - parent window handle

organizationID - organization ID

Returns

SQLSelect return result, lst

Side Effects

None

Description

This function gets a list of connection records based on the Where clause.

Dialog Forms Called

None