CITAN (version 2011.08-1)

dbExecQuery: 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 is useful in executing queries like CREATE TABLE, UPDATE, INSERT, etc.

It has its own exception handler, which prints out detailed description of caught error details.

See Also

dbSendQuery, dbClearResult, dbGetQuery