Skip to main content

Clear table

Clears the database table

Function ClearTable(Val Table, Val Connection = "") Export

ParameterCLI optionTypeRequiredDescription
Table--tableStringTable name
Connection--dbString, ArbitraryExisting connection or database path

Returns: Structure Of KeyAndValue, String - Result of query execution


1C:Enterprise/OneScript code example
    Base  = "C:\Users\Administrator\AppData\Local\Temp\v8_E607_1d.sqlite";
Table = "test";

Result = OPI_SQLite.ClearTable(Table, Base);
    oint sqlite ClearTable \
--table "test" \
--db "C:\Users\Administrator\AppData\Local\Temp\3pbdgv5r4nm.sqlite"
Result
{
"result": true
}