dbSendQuery-JDBCConnection-character-method: Execute a prepared SQL statement on a database connection

In hoesler/dbj: Provides access to databases through the JDBC interface

Description

Execute a prepared SQL statement on a database connection

Usage

## S4 method for signature 'JDBCConnection,character'
dbSendQuery(conn, statement,
  parameters = list())

Arguments

conn	A JDBCConnection object, as produced by dbConnect.
statement	A character vector of length one specifying the input to a prepared SQL statement.
parameters	A list of statement parameters, which will be inserted in order.

Value

A JDBCResult object. Depending on the query type a JDBCQueryResult or a JDBCUpdateResult.

See Also

Other JDBCConnection methods: dbConnect,JDBCConnection-method, dbDisconnect,JDBCConnection-method, dbj-edit-tables, dbj-sql-generate, dbj-sql-quote, dbj-table

Examples

## Not run: 
dbSendQuery(con, "UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?", list(3500, 624L))

## End(Not run)

hoesler/dbj documentation built on May 17, 2019, 4:36 p.m.