DBLOOKUPNOCACHE

Description

Similar to DBLOOKUP except that the values are never cached. The data is read on the execution of each step, even if the input parameters have not changed.

This function avoids issues associated with the DBLOOKUP function's caching strategy. Only use this function if the value to be looked up may change during execution.

Warning: Only use this non-cached version of DBLOOKUP as a last resort because of its potential negative impact on performance.

Syntax

DBLOOKUPNOCACHE ( SourceField, "connection", "table", "lookup_field", "substitution_field" )

Parameter	Description
TextSourceField	The value for which to search in the lookup_field column.
connection	The connection where this lookup table resides. If the connection is Scribe Internal Database, the SCRIBE user must have at least SELECT privileges on the lookup table.
table	The name of the lookup table.
lookup_field	The name of the column in the lookup table that stores the value to search for.
substitution_field	The name of the column in the lookup table that stores the value to return.

Remarks

Note: This function requires special handling when working with bulk operations. See Using Bulk Operations for more information.

When updating the same target row from several source rows, there may be a need to append information to target columns instead of just overwrite/update them. Normally, this can be achieved by using DBLOOKUP/SQLQUERY, however:

SQLQUERY does not work with the adapter for Dynamics CRM.
DBLOOKUP does not see previously appended data
You may have to change the shutdown interval for the message processor to shut down after every run, to force DBLOOKUP to drop the connection.

The DBLOOKUPNOCACHE function returns only the first match. If there could be multiple records matching your search criteria, you could use the DBLOOKUPLIST function to return a comma-delimited list of results.

Examples

To search records in a table in the target database for PHONE field whose value matches "603-622-5109", and then return the record's COMPANYNAME field value, use this formula:

DBLOOKUPNOCACHE("603-622-5109", "Target","PHONE","COMPANYNAME"

If source field S4 contains the phone number you need to match, you could enter the formula as:

DBLOOKUP2NOCACHE(S4,"Target","PHONE","COMPANYNAME"

which would produce the same result.