Execute SQL Statement on Existing Database

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

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()