HCL Domino - Examples: Accessing external databases through LS:DO using @functions - Need a Domino Consultant? Call NotesMail +1 212-599-2048

HCLSoftware Business Partner Domino Consulting Services CRUCIAL Notes Tools +1 212-599-2048	Domino Consulting Services CRUCIAL Notes Tools Domino administration Notes development	Chat now
.

Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

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?

Feedback on Help or Usability?