RODBCext (version 0.2.5)

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

## Not run: 
#   conn = odbcConnect('MyDataSource')
# 
#   sqlPrepare(conn, "SELECT * FROM myTable WHERE column = ?")
#   sqlExecute(conn, 'myValue')
#   sqlFetchMore(conn)
# ## End(Not run)