fields.SRDLdb: 'fields.SRDLdb' lists field names form specified table in a...

In embiuw/rSRDL: Communicate with SMRU SRDL Access (Windows only) and PostreSQL (platform independent) databases

Description

fields.SRDLdb lists field names form specified table in a SMRU Access database

Usage

fields.SRDLdb(
  theDB = "ct34",
  theTable = "dive",
  thePath = "C:/MamVisAD/SMRUAccessDatabases"
)

Arguments

theDB	Name of database as defined in ODBC data sources
theTable	Name of database table
thePath	Path to folder where database is located, if running in 64-bit R.

Details

The database must first be set up as a DSN data source. Note! On Windows, by default only 32-bit data sources can be used and R (or RStudio) has to be run in 32-bit mode for these functions to work. However, functionality has now been extended (experimental for now) to run under 64-bit R. For this to worl, the path to the database must be specified.

Value

Returns a character vector with field names from specified table

Author(s)

Martin Biuw

See Also

tables.SRDLdb for database table names, ref.SRDLdb for ref ID codes, dep.SRDLdb for retrieving deployments metadata, get.SRDLdb for querying and retrieving data from database table

Other SMRU SRDL database functions: fields.SRDLpg(), ref.SRDLdb(), ref.SRDLpg(), tables.SRDLdb(), tables.SRDLpg()

embiuw/rSRDL documentation built on Jan. 27, 2021, 8:11 p.m.