Lotus Domino Designer 8 Help - Writing formulas and scripts to access relational databases

APPLICATION DESIGN

Writing formulas and scripts to access relational databases
The following @functions access an external database through ODBC and return a value or list of values:

@DbColumn returns all the values in one column of a table, or all the distinct values.
@DbLookup returns selected values in one column of a table by matching keys.
@DbCommand passes a command to an external DBMS and returns the result.

@DbColumn and @DbLookup can only retrieve data. They can't add, delete, or modify data, or perform other operations. @DbCommand can retrieve data or send other SQL statements that can change data. LotusScript provides a wider range of capabilities including the ability to update the external database.

The LotusScript Data Object (LS:DO)

This LSX-compliant module allows you to use LotusScript to write applications that incorporate data from external non-Notes data sources. Your script may perform the following steps:

Establish a connection with the data source.
Each connection requires the data source name. If the data source name is not already registered, you must also provide additional information.
Use SQL statements to send queries or other actions to the data source.
Retrieve and use result sets.
Read, modify, or add information into relational databases.
Disconnect from the data source.

For more information on writing scripts to access external databases, see the help topic Accessing external databases through LS:DO.

Registering data sources for ODBC

Connecting to enterprise data

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary