stacomirtools (version 0.5.3)

RequeteODBCwheredate-class: Class "RequeteODBCwheredate"

Description

Query with WHERE condition and overlaping dates clause.

Objects from the Class

Objects can be created by calls of the form new("RequeteODBCwheredate", datedebut="POSIXlt",datefin="POSIXlt",colonnedebut="character",colonnefin="character").

datedebut:

Object of class "POSIXlt" ~ The starting date

datefin:

Object of class "POSIXlt" ~ The ending date

colonnedebut:

Object of class "character" ~ The name begin column

colonnefin:

Object of class "character" ~ The name end column

Slots

datedebut:

Object of class "POSIXlt" ~ The starting date

datefin:

Object of class "POSIXlt" ~ The ending date

colonnedebut:

Object of class "character" ~ The name of the begin column

colonnefin:

Object of class "character" ~ The name of the end column

where:

Object of class "character" ~ The WHERE clause

and:

Object of class "vector" ~ The AND clause

order_by:

Object of class "character" ~ The ORDER BY clause

sql:

Object of class "character" ~ The SELECT clause

query:

Object of class "data.frame" ~ The result of the query

baseODBC:

Object of class "vector" ~ The database

silent:

Object of class "logical" ~ The mode

etat:

Object of class "character" ~ The state

connection:

Object of class "ANY" ~ The connection

Extends

Class "'>RequeteODBCwhere", directly. Class "'>RequeteODBC", by class "RequeteODBCwhere", distance 2. Class "'>ConnectionODBC", by class "RequeteODBCwhere", distance 3.

Methods

connect

signature(object = "RequeteODBCwheredate"): Connexion to the database

See Also

'>ConnectionODBC '>RequeteODBC '>RequeteODBCwhere

Examples

# NOT RUN {
showClass("RequeteODBCwheredate")
# }

Run the code above in your browser using DataCamp Workspace