sbf_execute_db: Execute SQL Statement on Existing Database

View source: R/execute-db.R

sbf_execute_dbR Documentation

Execute SQL Statement on Existing Database

Description

Really just a wrapper on DBI::dbExecute().

Usage

sbf_execute_db(
  sql,
  db_name = sbf_get_db_name(),
  sub = sbf_get_sub(),
  main = sbf_get_main()
)

Arguments

sql

A string of the SQL statement to execute.

db_name

A string of the database name.

sub

A string specifying the path to the sub folder (by default the current sub folder).

main

A string specifying the path to the main folder (by default the current main folder)

Value

A scalar numeric of the number of rows affected by the statement.

See Also

Other database functions: sbf_add_blob_column_to_db(), sbf_close_db(), sbf_copy_db(), sbf_create_db(), sbf_open_db(), sbf_query_db(), sbf_upload_flobs_to_db()


poissonconsulting/subfoldr2 documentation built on Nov. 17, 2024, 1:33 a.m.