db.beginTransaction(SqlJetTransactionMode.WRITE);
try {
ISqlJetCursor deleteCursor = table.scope(DOB_INDEX,
new Object[] {Long.MIN_VALUE},
new Object[] {calendar.getTimeInMillis()});
while (!deleteCursor.eof()) {
System.out.println("Deleting: " +
deleteCursor.getRowId() + " : " +
deleteCursor.getString(FIRST_NAME_FIELD) + " " +
deleteCursor.getString(SECOND_NAME_FIELD) + " was born on " +
formatDate(deleteCursor.getInteger(DOB_FIELD)));