edbNRow.RODBC_Access: Retrieve the number of rows of a table in a database...

Description Usage Arguments Value Author(s) See Also

Description

Retrieve the number of rows of a table in a database (referenced by

'edb'). Notice that the methods do NOT retrieve the full table to

get its column names (so it should work even if the table is big).

Usage

1
2
3
4
5
## S3 method for class 'RODBC_Access'
edbNRow(edb, tableName, sRow = NULL, sRowOp = c("AND", 


    "OR")[1], verbose = FALSE, ...)

Arguments

edb

An object of class 'edb', such as returned by edb.

tableName

Single character string. Name of the table to read in 'edb'.

sRow

A list of named items. List of contrains/criterion to be applied

on a table to retrieve a subset of rows. Each item in

sRow must be named after the columns on which the constrain

apply. The (vector of) value(s) of each items are the possible values

that can be retrieved. Values can be character or numeric. If NULL

(the default), all values are returned.

sRowOp

A single character string. Operator to be used to combine multiple

constrains in sRow. Possible values are "OR" or "AND". Default value

is "AND".

verbose

Single logical. If TRUE, information on what is done are output

on screen.

...

Additional parameters to be passed to edbQuery.

Value

Returns the number of rows in the table, rows that respect sRow

constrains if sRow is not NULL.

Author(s)

Julien MOEYS <Julien.Moeys@mark.slu.se>

See Also

edb, edbColnames,

edbRead.


easyrodbcaccess documentation built on May 2, 2019, 5:26 p.m.