RODBCext (version 0.2.1)

sqlPrepare: Prepares a query for execution

Description

Prepares a query for execution.

Usage

sqlPrepare(channel, query, errors = TRUE)

Arguments

channel

ODBC connection obtained by odbcConnect

query

query string

errors

whether to display errors

Value

• invisible(1) on success, -1 or an error (depending on errors parameter) on error

Examples

conn = odbcConnect('MyDataSource')

  sqlPrepare(conn, "SELECT * FROM myTable WHERE column = ?")
  sqlExecute(conn, 'myValue')
  sqlFetchMore(conn)