POPULATE THE LISTBOX WITH THE NEW VALUES MsgBox("Error: " + Str(AddressDB.ErrorCode) + " - " + AddressDB.ErrorMessage) DATABASE WRITE ERROR, SO DISPLAY THE ERROR MSGBOX Ps.BindType(1, SQLitePreparedStatement.SQLITE_TEXT) Ps.BindType(0, SQLitePreparedStatement.SQLITE_TEXT) If -1 Then // DATABASE CONNECTION IS SUCCESSFUL, SO EXECUTE THE SQL TO DELETE THE SELECTED ENTRIESÄim ps As SQLitePreparedStatement = AddressDB.Prepare("DELETE FROM addressbook WHERE name = ? AND email = ?") Not sure how to loop through and delete ALL the selected entries though? This is the code so far - which successfully removes 1 selected row. If a listbox has multiple selections enabled - how do I delete all the selected listbox rows from the actual database? I was trying to help someone else, and then I realised that I am also having trouble succeeding in this quest
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |