function Lookup(ATableName : String; AKeyField : String; AKeyValue : String; AValueField : String; ADefault : String) : String;

Class IKDBConnection

Given a tablename, return the value of ValueField where KeyField is the same as keyvalue. the keyfield can be a number or a string. if there is no match, Default will be returned as the value

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