hsClearTable: Clear a Database Table

In KWB-R/kwb.db: Functions supporting data base access

Clear a Database Table

Description

Deletes all the rows of the table tbl. This function performs opening of the connection, clearing of the table and closing of the connection. If an error occurs the program stops and an error description is shown.

Usage

hsClearTable(mdb, tbl, cond = TRUE, ...)

Arguments

mdb	full path to MS Access database (*.mdb).
tbl	table name.
cond	optional: condition.
...	additional arguments passed to hsSqlQuery, e.g. "errors=TRUE"

See Also

hsDropTable

KWB-R/kwb.db documentation built on Oct. 1, 2023, 4:10 a.m.