Home
HCL Domino Designer Basic User Guide and Reference
This guide provides information on using HCL Domino Designer and programming language reference information.
Connectors
Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
Accessing external databases through LS:DO
Developers are advised not to use LS:DO. Developers should use the Connector LSX for (LCLSX) when accessing external data sources.
ODBCResultSet (LotusScript)
Represents the ODBC data access features for performing operations on a result set.
ExecProcedure (ODBCResultSet - LotusScript)
Executes a stored SQL procedure.
Examples: ExecProcedure method
This agent executes the stored procedure named SSELDEPT, which performs a simple query. The agent then displays the first row of the result set.

Examples: ExecProcedure method

This agent executes the stored procedure named SSELDEPT, which performs a simple query. The agent then displays the first row of the result set.

Sub Initialize
  Dim con As New ODBCConnection
  Dim res As New ODBCResultSet
  Dim rowvals As String
  REM Connect to data source
  con.ConnectTo(Inputbox("ODBC data source name", "DSN"))
  While Not con.IsConnected
    dsn = Inputbox("ODBC data source name", _
    "Connection not made ...")
    If dsn = "" Then Exit Sub
    con.ConnectTo(dsn)
  Wend
  Messagebox "Connected to " & con.DataSourceName,, _
  "Connection made ..."
  REM Call stored procedure
  Set res.Connection = con
  Call res.ExecProcedure("SSELDEPT")
  REM Display first row
  For i = 1 To res.NumColumns Step 1
    If res.IsValueNull(i) Then
      rowvals = rowvals & "NULL" & Chr(9)
    Else
      rowvals = rowvals & res.GetValue(i) & Chr(9)
    End If
  Next
  Messagebox rowvals,, "Value of first row"
  REM Disconnect
  con.Disconnect  
End Sub