dbExecQuery: Execute a query and free its resources

Description Usage Arguments Details See Also

View source: R/execquery.R

Description

Executes an SQL query and immediately frees all allocated resources.

Usage

1
dbExecQuery(conn, statement, rollbackOnError = FALSE)

Arguments

conn

a DBI connection object.

statement

a character string with the SQL statement to be executed.

rollbackOnError

logical; if TRUE, then the function executes rollback on current transaction if an exception occurs.

Details

This function may be used to execute queries like CREATE TABLE, UPDATE, INSERT, etc.

It has its own exception handler, which prints out detailed information on caught errors.

See Also

dbSendQuery, dbClearResult, dbGetQuery


CITAN documentation built on May 2, 2019, 9:33 a.m.