Syntax

SQLExecQuery(ID, query$)

Description

Executes an SQL statement query on a data source.

Comments

This function is called after a connection to a data source is established using the SQLOpen function. The SQLExecQuery function may be called multiple times with the same connection ID, each time replacing all results.

The following table describes the parameters to the SQLExecQuery function:

Parameter

Description

ID

Long identifying a valid connected data source. This parameter is returned by the SQLOpen function.

query$

String specifying an SQL query statement. The SQL syntax of the string must strictly follow that of the driver.

The return value of this function depends on the result returned by the SQL statement:

SQL Statement

Value

SELECT...FROM

The value returned is the number of columns returned by the SQL statement.

DELETE,INSERT,UPDATE

The value returned is the number of rows affected by the SQL statement.

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

Example

This example executes a query on the connected data source.

Sub Main()
  Dim s As String
  Dim qry As Long
  id& = SQLOpen("dsn=SAMPLE",s$,3)
  qry = SQLExecQuery(id&,"Select * From c:\sample.dbf")
  MsgBox "There are " & qry & " columns in the result set."
  id& = SQLClose(id&)
End Sub

See Also

SQLOpen (function); SQLClose (function); SQLRetrieve (function); SQLRetrieveToFil (function)

S