how do you clear an SQLite database from all data?
I tried line by line with the following code:
" Sub Azzera()
'//•••••••••••••• AZZERA TUTTI I CAMPI •••••••••••••••
If Sommario.RiasList.SelectedRowIndex < 0 Then Return
Dim sql As String = “DELETE FROM Race WHERE ID = ?;”
Var id As Integer = Sommario.RiasList.SelectedRowIndex
Catch err As DatabaseException
MessageDialog.Show("Error deleting the file from the database: " + err.Message)
but I get an erro in line 5 (DB.ExecuteSQL(sql, id)). DB isn SQLite db declared in Globals and it is recognized in other methods.
I would like to deleted all rows in the SQLite database (Table named Race) so that I can have a pristine one in case I need