Databases
StackOverflow2013
Postsdbo
PODatabase Quandry
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODatabase Quandry
    primarykey
    data
    text
    <p>Been trying to get an answer on what I am doing wrong all over the place. I would like the user to select a button in the calling class, open a called listactivity which displays the contents of a database, let the user click an entry, copy that entry into a new database, send back the rowid from the new database to the calling class and have the calling class assign the title from the new database entry to the original button that was pushed.</p> <p>Here is the calling class</p> <pre><code>static final private int CHOOSE_MONDAY = 0; static final private int CHOOSE_TUESDAY = 0; private int ButtonPushed = 0; private NotesDbAdapter mDbHelper; private MenuDbAdapter menuDbHelper; private Long mRowId; String menuTitle; String menuProtein; String menuBody; @Override protected void onCreate(Bundle savedInstanceState) { // TODO Auto-generated method stub super.onCreate(savedInstanceState); setContentView(R.layout.plan_menu); Toast.makeText(this, "Choose a day to pick a meal for!", Toast.LENGTH_LONG).show(); mDbHelper = new NotesDbAdapter(this); mDbHelper.open(); menuDbHelper = new MenuDbAdapter(this); menuDbHelper.open(); } public void mButtonHandler(View target) { switch(target.getId()) { case R.id.monday: // Create new intent object and tell it to call the ColorPicker class Intent question = new Intent(this, PlanMenuList.class); // Start ColorPicker as a new activity and wait for the result startActivityForResult(question, CHOOSE_MONDAY); break; case R.id.tuesday: // Create new intent object and tell it to call the ColorPicker class Intent question1 = new Intent(this, PlanMenuList.class); // Start ColorPicker as a new activity and wait for the result startActivityForResult(question1, CHOOSE_TUESDAY); break; } </code></pre> <p>And then this is the called class where I am trying to copy in the user's selection to the new database and then send back the id to the calling class.</p> <pre><code>public class PlanMenuList extends ListActivity { private NotesDbAdapter mDbHelper; private MenuDbAdapter menuDbHelper; private List&lt;Data&gt;data; String menuTitle; String menuProtein; String menuBody; private Long mRowId; /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.notes_list); mDbHelper = new NotesDbAdapter(this); menuDbHelper = new MenuDbAdapter(this); mDbHelper.open(); menuDbHelper.open(); fillData(); } private void fillData() { Cursor notesCursor = mDbHelper.fetchAllNotes(); startManagingCursor(notesCursor); // Create an array to specify the fields we want to display in the list (only TITLE) String[] from = new String[]{NotesDbAdapter.KEY_TITLE}; // and an array of the fields we want to bind those fields to (in this case just text1) int[] to = new int[]{R.id.text1}; // Now create a simple cursor adapter and set it to display SimpleCursorAdapter notes = new SimpleCursorAdapter(this, R.layout.notes_row, notesCursor, from, to); setListAdapter(notes); } private void populateFields() { if (mRowId != null) { Cursor note = mDbHelper.fetchNote(mRowId); startManagingCursor(note); menuTitle=(note.getString( note.getColumnIndexOrThrow(NotesDbAdapter.KEY_TITLE))); menuProtein=(note.getString( note.getColumnIndexOrThrow(NotesDbAdapter.KEY_PROTEIN))); menuBody=(note.getString( note.getColumnIndexOrThrow(NotesDbAdapter.KEY_BODY))); } } protected void onListItemClick(ListView l, View v, int position, long id) { super.onListItemClick(l, v, position, id); mDbHelper.fetchNote(id); mRowId = id; //populateFields(); menuDbHelper.createMenu("Monday", menuTitle, menuProtein, menuBody); Intent answer = new Intent(); answer.putExtra("MenuDbAdapter.KEY_ROWID", mRowId); setResult(RESULT_OK, answer); finish(); } } </code></pre> <p>I have been messing around with this thing for days and can't seem to get it to do what I want - any help would be appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJim Schubert
    1. USWill
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODatabase Quandry
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload