getNumRows              package:RSQLite              R Documentation

_G_e_t _n_u_m_b_e_r _o_f _r_o_w_s/_c_o_l_u_m_n_s _o_f _a_n _S_Q_L _t_a_b_l_e

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

     Get the number of rows or columns of a remote SQL table

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

     getNumCols(con, name, ...)
     getNumRows(con, name, ...)

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

     con: a `dbConnection' object. 

    name: a character string specifying the name of the table on the
          remote RDBMS 

    ... : any additional arguments are passed to the implementing
          method. 

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

     an integer specifying the number of rows or columns.

_S_i_d_e _E_f_f_e_c_t_s:

     Depending on the driver, a new connection or a new cursor (result
     set) will be opened for communicating with the RDBMS.  Therefore,
     drivers that allow only one connection or one result set need to
     verify that the connection specified as the first argument does
     not have any pending work.

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

     `getTable' `assignTable' `removeTable' `existsTable'

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

     con <- dbConnect("Oracle", group = "opto")
     getNumRows(con, "WAVELENGTH")
     [1] 118336

