NOP Design Home Page


Links a column from a database select statement to a SIML variable.

You may specify data types and string lengths as you wish to have them in your SIML program. These types do not need to match what you have in the database. SIML will automatically convert most data types for you.

You must not bind a string of a shorter length than may be returned from the database, or you will receive a database error from GetRowset.

Sample Source

# Connect to the database, compile a sql statement 
# bind three result columns, execute the statement
# and output the rows returned

If ( Connect dbDatabase to "DSN=dsn_name" as ODBC ) Then 
   PrepareRowset dbRowset As "SELECT 'one', 2, 3.0" From dbDatabase
   BindColumn MyOutput1 To 1 From dbRowset As String 10
   BindColumn MyOutput2 To 2 From dbRowset As Integer
   BindColumn MyOutput3 To 3 From dbRowset As Number
   iReturn := GetRowset dbRowset
   If iReturn < 0 Then
      Say GetLastError dbRowset
   While iReturn > 0
      Say MyOutput1 + "<br>"
      Say MyOutput2 + "<br>"
      Say MyOutput3 + "<br>"
      iReturn := SelectRow Next From dbRowset

   Disconnect MyDatabase

Related Function(s):
   BindParameter; GetColumn; GetColumncount; GetColumnname; GetColumnnullability; GetColumnprecision; GetColumnsize; GetColumntype; GetRowset; IsNull;

Minimum version: 3.0