odm_write_tbl: ODM write function
In D-ESC/ODMr: ODM Data Access

Description Usage Arguments Value Examples

View source: R/odm_write_tbl.R

This function can write meta data to an ODM database table

1	odm_write_tbl(x, odm_tbl = "Seriescatalog", channel = ODM)

`x`	dtaframe to load to ODM table
`odm_tbl`	name of the table in the ODM database
`channel`	connection handle as returned by odbcConnect (default value = ODM)

number of rows effected

## Not run: 
# Establish connection with database
ODM <- odbc::dbConnect(odbc::odbc(), dsn = "ODM", database = "OD",
 UID = "update", PWD = rstudioapi::askForPassword("Database password"),
 Port = 1433)

# Get a list of sites in the database
Site <- odm_read_tbl(odm_tbl = "Sites")

# Get a list of data series in the database
odm_write_tbl(Site, odm_tbl = "Sites")

## End(Not run)