quickSQL               package:RSQLite               R Documentation

_Q_u_i_c_k _S_Q_L _E_x_e_c_u_t_i_o_n

_D_e_s_c_r_i_p_t_i_o_n:

     Simplifies queries by submitting an SQL command and fetching  its
     output in one function

_U_s_a_g_e:

     quickSQL(con, statement, ...)

_A_r_g_u_m_e_n_t_s:

     con: an open `dbConnection' object. 

statement: an SQL statement as a character vector. 

    ... : any additional arguments specific to the database engine may
          be specified. 

_D_e_t_a_i_l_s:

     This function simply calls `dbExecStatement' followed by `fetch'.

_V_a_l_u_e:

     a `data.frame' in the case of a `SELECT'-like statement, or NULL
     otherwise.

_B_u_g_s::

     Perhaps this function should be named `dbQuery' or `dbImmediate'?

_R_e_f_e_r_e_n_c_e_s:

     See the Omega Project for Statistical Computing at <URL:
     http://www.omegahat.org> for more details on the R/S database
     interface.

_S_e_e _A_l_s_o:

     On database managers:

     `dbManager' `SQLite' `load' `unload'

     On connections, SQL statements and resultSets:

     `dbExecStatement' `dbExec' `fetch' `quickSQL'

     On transaction management:

     `commit' `rollback'

     On meta-data:

     `describe' `getVersion' `getDatabases' `getTables' `getFields'
     `getCurrentDatabase' `getTableIndices' `getException'
     `getStatement' `hasCompleted' `getRowCount' `getAffectedRows'
     `getNullOk' `getInfo'

_E_x_a_m_p_l_e_s:

     # The following extract all the tables in the current database

     mgr <- dbManager("SQLite")
     con <- dbConnect(mgr)
     quickSQL(con, "show tables")

