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



  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...