Lotus Domino Designer 8.5 Help - Examples: Accessing external databases through LS:DO using @functions

FORMULA LANGUAGE

Examples: Accessing external databases through LS:DO using @functions
1. This formula gets the PARTNO column of the MANUALS table.

@DbColumn("ODBC";"Oracle";"";"";"MANUALS";"PARTNO";"":"Ascending")

2. This formula gets the TITLE from the row of the MANUALS table where PARTNO is 17-895A.

@DbLookup("ODBC";"Oracle";"";"";"MANUALS";"TITLE";"PARTNO";"17-895A")

3. This formula gets the PARTNO column value for every row of the MANUALS table, where the numeric value in the ONHAND column is less than 100.

@DbCommand("ODBC";"Oracle";"";"";"SELECT PARTNO FROM MANUALS WHERE ONHAND <100")

Feedback on Help or Product Usability?