public LocationItem removeLocationItemAt(int row) {
        if(DEGUB)System.out.println("In removeLocationItemAt("+row+")");
        
        LocationItem li = getLocationItem(row);
        try (Statement stmt = con.createStatement();)
        {
            stmt.executeUpdate("DELETE FROM Locations WHERE Code = "+li.getCode());
            locationItemList.remove(row);
            rowEditable.remove(row);
            //Fire table row deletion notification to table.
            fireTableRowsDeleted(row, row);
            
        } catch (SQLException ex) {
            System.err.println(ex.getClass().getName() + ": " + ex.getMessage());
        }
        return  li;
        
    }