Basic Forsuredb Upsert Query (android)

basic_forsuredb_upsert_query_android.java

SaveResult<Uri> result = ForSure.myTable()
    .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()                                      // <-- start setting column values to update
        .stringColumn("Your int_column value is greater than three and less than or equal to 10")
    .save();
System.out.println("Number of records updated: " + result.rowsAffected());