dbExecQuery {CITAN}

Execute a query and free its resources

Description

Executes an SQL query and immediately frees all allocated resources.

Usage

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