Creating Table/Structure in BRF+ from DB Lookup for Table Operations

[matthew_stout]

Hello Experts:

Is there a way to pull a set of data into BRF+ via a DBLookup and then hold that data for several different other table operation expressions without having to re-perform the DBLookup redundantly? Or is the best approach to just pull that table of information in via the application 'context'? I have tried to the DBLookup approach to try and set the information for use by many different other expressions, but performance analysis shows that it keeps re-doing the DB Lookup redundantly.

Thanks in advance for your assistance.

[Patrick_Gans]

I create a set of context Data Objects (Elements plus Structure) for this purpose, and then use an expression to initialize the Elements at the top of a ruleset. After this, referring to the Data Objects directly should not call the DB Lookup. If you need more details let me know.

Patrick