Manage Learn to apply best practices and optimize your operations.

The Quickest Way How To Use @Dbcolumn And @Dblookup

One of the most common procedures is to fulfil information from different
document related to the selected key. For example, all information related to
the employee name like address, phone, fax, etc. Solution is usually formula
uses @DbColumn and @DbLookup. The quickest way how to use them is create view
only with two columns. There are employee name (key) in the first column (this
column must be sorted) and list of all related information in the second
column. Then formula selecting and filling information into the field can be
like this :

REM "Create list of keys";
tmpList := @DbColumn("":"";"":"";"ViewForSelection";1);

REM "Select one key from the list";
tmpKey := @Prompt([OKCANCELLIST];"Keys";"Select appropriate key : "; "";

REM "Read the list of information related to the key";
tmpRelatedInfo := @DbLookup("":"";"":""; "ViewForSelection"; tmpKey; 2);

REM "Split information into the fields";
FIELD FirstField := @Subset(tmpRelatedInfo;1);
FIELD NextField := @Subset(@Subset(tmpRelatedInfo;PositionInList);-1);
FIELD LastField := @Subset(tmpRelatedInfo;-1);


Dig Deeper on Lotus Notes Domino Administration Tools

  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/ community. These cheat ...