Last data update: 2014.03.03

 R: Prepares a query for execution
sqlPrepareR Documentation

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)

Results


Created & Maintained by Osamu Ogasawara (osamu.ogasawara@gmail.com) and IMSBIO