function LookupNum(TableName : String; keyColumn : String; keyValue : String; SourceField : String; DefaultContent : String) : String;

Class IDBConnPool

Macro: perform a table lookup. This routine will Get a connection, find the value, and then yield the connection

 TableName        the name of the table to lookup
 keyColumn        the column of the table that contains the value to find (should be indexed)
 keyValue         the value to find - must be an integer column
 SourceField      the colum of the table to return
 DefaultContent   what to return if no match is found

Typical usage: HL7Message Field substitutions

© Kestral Computing P/L 2000 - 2003. HL7Connect v2.00-063 generated on 30-Nov 2015.
Keywords: LookupNum