private void lendOutRecord(MyDBHandler dbHandler) { int currentID = 1; EditText name = (EditText) findViewById(R.id.editTextLendoutName); Button dateOut = (Button) findViewById(R.id.editTextLentoutDateOut); Button dateDue = (Button) findViewById(R.id.editTextLentoutDue); if (name == null || dateDue == null || dateOut == null) return; String nameStr = name.getText().toString(); ArrayList<String> listOfIDs = dbHandler.dbReturnListStrings("SELECT * FROM lentout", "_id"); if (listOfIDs != null && listOfIDs.size() != 0) currentID += findLargestString(listOfIDs); String currentIDStr = String.valueOf(currentID); String dateOutStr = dateOut.getText().toString(); if (dateOutStr.equals("Today")) { dateOutStr = getDateFromDatePicker((DatePicker) findViewById(R.id.datePickerLentOut)); } String dateDueStr = dateDue.getText().toString(); if (dateDueStr.equals("Unset")) { dateDueStr = "12/12/2025"; } dbHandler.runRawQueryNoResult( "insert into lentout (_id,album_id,lentout,dateout,dueback) values (" + currentIDStr + "," + recordID + ",'" + nameStr + "','" + dateOutStr + "','" + dateDueStr + "');"); finish(); }