stacomirtools (version 0.6.0.1)

query,RequeteDBwhere-method: query method loads a request to the database and returns either an error or a data.frame

Description

query method loads a request to the database and returns either an error or a data.frame

Usage

# S4 method for RequeteDBwhere
query(object, ...)

Arguments

object

an object of class RequeteDBwhere

...

further arguments passed to the query method, base will be passed to ConnectionDB to set the connection parameters,

Value

An object of class RequeteODBCwhere

Examples

# NOT RUN {
object<-new("RequeteODBCwhere")
base=c("bd_contmig_nat","localhost","5432","user", "password")
object@sql<- "select * from t_lot_lot"
object@where<-"WHERE lot_tax_code='2038'"
object@and<-c("AND lot_std_code='CIV'","AND lot_ope_identifiant<1000")
object@order_by<-"ORDER BY lot_identifiant"
object <- connect(object, base)
# }