query-RequeteDBwhere-method: query method loads a request to the database and returns...

In stacomirtools: Connection Class for Package stacomiR

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 signature '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

Author(s)

Cedric Briand [e-mail]

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)

## End(Not run)

stacomirtools documentation built on Sept. 9, 2022, 3:07 p.m.