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

Description Usage Arguments Value See Also Examples

Description

Execute a prepared SQL statement on a database connection

Usage

1
2
3
## 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

1
2
3
4
## 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.