Description: Looks up a source-entry value in an object record selected by a key field and key value.
Calling convention: CIP_GetObjectValue("SourceObjectName": String, "SourceEntryName": String, "KeyEntryName": String, KeyEntryValue, "TargetEntryName": String): Integer
Parameters:
SourceObjectName: registered source object.
SourceEntryName: entry whose value is returned.
KeyEntryName: entry used in the lookup condition.
KeyEntryValue: value matched against the key entry.
TargetEntryName: despite its registered name, the implementation uses this fifth argument as the fallback value when no row is found.
Returns: Looked-up source value as Variant, or the fifth argument as fallback, despite the registered Integer return type. The implementation assumes all five arguments are present.
Availability: Default; performs a dynamically constructed database query.
Example:
ResultValue := CIP_GetObjectValue("Products", "Description", "ProductCode", Code, "Unknown");