query,RequeteDBwhere-method | R Documentation |
query method loads a request to the database and returns either an error or a data.frame
## S4 method for signature 'RequeteDBwhere' query(object, ...)
object |
an object of class RequeteDBwhere |
... |
further arguments passed to the query method, base will be passed to ConnectionDB to set the connection parameters, |
An object of class RequeteODBCwhere
Cedric Briand cedric.briand@eptb-vilaine.fr
## 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)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.