Basic Forsuredb Delete Query

basic_forsuredb_delete_query.java

int rowsAffected = ForSure.myTable()            // <-- the generated ForSure class serves as your entrypoint
    .find()                                     // <-- start narrowing the number of records and columns to update
        .byIntColumnBetween(3).andInclusive(10) // <-- set bounds (3, 10]
        .and().byNotDeleted()                   // <-- add additional condition that the record must not be "soft deleted"
    .then()                                     // <-- end narrowing number of records and columns to return
    .set()                                      // <-- enter insert/update/delete section
    .hardDelete();                              // <-- perform a hard deletion--actually deleting the record
System.out.println("Number of records deleted: " + rowsAffected);