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")