function LookupStr(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 a string column (e.g. char, nchar etc)
 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: LookupStr