Lotus Software logo
IBM Lotus Domino Designer 8.5
  Versions 8.5 and 8.5.1






Examples: Accessing external databases through LS:DO using @functions

  1. This formula gets the PARTNO column of the MANUALS table.
    2. @DbColumn("ODBC";"Oracle";"";"";"MANUALS";"PARTNO";"":"Ascending")
  2. This formula gets the TITLE from the row of the MANUALS table where PARTNO is 17-895A.
    3. @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.
    4. @DbCommand("ODBC";"Oracle";"";"";"SELECT PARTNO FROM MANUALS WHERE ONHAND <100")
Related topics
Accessing external databases through LS:DO using @functions



Library | Support | Terms of use |

Last updated: Monday, October 5, 2009