odbc_get_multi_id: Get the corresponding id's

In INBO-Natura2000/n2khelper: Auxiliary Functions for the Analysis and Reporting of the Natura 2000 Monitoring

Get the corresponding id's

Description

Get the corresponding id's

Usage

odbc_get_multi_id(
  data,
  id_field,
  merge_field,
  table,
  channel,
  create = FALSE,
  select = TRUE,
  rows_at_time = 1000
)

Arguments

data	the data.frame
id_field	the id fields
merge_field	the merge fields
table	The name of the table
channel	the open dplyr connection to the database.
create	When TRUE, the function creates unmatching records AND updates attributes. Defaults to FALSE.
select	Return the matching ID's when TRUE. Returns invisible NULL when FALSE. select = FALSE is only relevant in combination with create = TRUE.
rows_at_time	Number of rows to insert in one SQL statement

Value

a data.frame with data and the id's

INBO-Natura2000/n2khelper documentation built on April 5, 2022, 5:40 p.m.