Description: Returns an entry value from the first object record whose key entry matches a supplied value.
Calling convention: CIP_GetValueByKeyValue("SourceObjectName": String, "KeyEntryName": String, KeyEntryValue: Variant, "RequestedEntryName": String): Variant
Parameters:
SourceObjectName: registered source object.
KeyEntryName: entry used as the lookup key.
KeyEntryValue: value matched through a typed query parameter.
RequestedEntryName: entry whose value is returned.
Returns: Requested value as Variant or NULL when the database query finds no record. Invalid inputs, objects or entries raise an exception.
Availability: Default; may return an unsaved value from the matching active DBForm.
Example:
Price := CIP_GetValueByKeyValue("Products", "Code", ProductCode, "Price");