dbExecQuery: Execute a query and free its resources
In CITAN: CITation ANalysis Toolpack
dbExecQuery R Documentation
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
CITAN documentation built on Aug. 8, 2025, 6:10 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| dbExecQuery | R Documentation |
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 |
statement |
a character string with the SQL statement to be executed. |
rollbackOnError |
logical; if |
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
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.