db_ExecuteSQL: to execute statements like update a row

In BenBruyneel/BBPersonalR: BBPersonalR

to execute statements like update a row

Description

to execute statements like update a row

Usage

db_ExecuteSQL(db, SQLString, doNotChangePool = FALSE, invisibleReturn = TRUE)

Arguments

db	database access 'handle'
SQLString	the SQL query to be performed
doNotChangePool	boolean that sets whether the pool has to be locked/ released inside this function. Usually this needs to be done, so default is FALSE. Set to TRUE if this locking/release is done outside of the function. Note that there is a sort of bug when working with the pool::dbWriteTable : when a sql constraint like UNIQUE is defined for the table used, this may result in a locked database upon error. It's advisable to set doNotChangePool to TRUE to prevent this from happening
invisibleReturn	if TRUE (default), then nothing is returned, if FALSE then the result of the SQLString will be returned (see SQL for what it can be)

Value

result from the SQL query, usually a data.frame

BenBruyneel/BBPersonalR documentation built on Aug. 23, 2024, 8:28 p.m.