However, when executed twice in a row for two differnet ordinals (with a very small time interval), the first record is deleted, but the second record is not deleted and will show up when the db is reloaded. How do I make sure that the second record is deleted?
wxString command = wxT("DELETE FROM Mouvements WHERE Ordinal = *");
command.Replace(wxT("*"),wxString::Format(wxT("%d"),ordinal));
accountsDB->ExecuteUpdate(command);
wxSQLite3Transaction t(accountsDB);
t.Commit();
(my sql experience is obviously very limited...)