Syntax

SQLBind(ID,array,column)

Description

Specifies which fields are returned when results are requested using the SQLRetrieve or SQLRetrieveToFile function.

Comments

The following table describes the parameters to the SQLBind function:

Parameter

Description

ID

Long parameter specifying a valid connection.

array

Any array of variants. Each call to SQLBind adds a new column number (an Integer) in the appropriate slot in the array. Thus, as you bind additional columns, the array parameter grows, accumulating a sorted list (in ascending order) of bound columns.

If array is fixed, then it must be a one-dimensional variant array with sufficient space to hold all the bound column numbers. A runtime error is generated if array is too small.

If array is dynamic, then it will be resized to exactly hold all the bound column numbers.

column

Optional Long parameter that specifies the column to which to bind data. If this parameter is omitted, all bindings for the connection are dropped.

The first actual column in the table is column 1.

(If supported by the driver) row numbers can be returned by binding column 0.

This function returns the number of bound columns on the connection. If no columns are bound, then 0 is returned. If there are no pending queries, then calling SQLBind will cause an error (queries are initiated using the SQLExecQuery function).

If supported by the driver, row numbers can be returned by binding column 0.

The Basic Control Engine generates a runtime error that can be trapped if SQLBind fails. Additional error information can then be retrieved using the SQLError function.

Example

This example binds columns to data.

Sub Main()
  Dim columns() As Variant
  id& = SQLOpen("dsn=SAMPLE",,3)
  t& = SQLExecQuery(id&,"Select * From c:\sample.dbf")
  i% = SQLBind(id&,columns,3)
  i% = SQLBind(id&,columns,1)
  i% = SQLBind(id&,columns,2)
  i% = SQLBind(id&,columns,6)
  For x = 0 To (i% - 1)
    MsgBox columns(x)
  Next x
  id& = SQLClose(id&)
End Sub

See Also

SQLRetrieve (function); SQLRetrieveToFile (function).

S