StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POAndroid spinner - Cannot make a static reference to the non-static method help
text
Body
copied!<p>I have followed a tutorial to populate data from an sqlite database in to a spinner (dropdown) in Android. However, I am getting the error:</p> <pre><code>Cannot make a static reference to the non-static method fetchAllCategories() from the type DatabaseAdapter </code></pre> <p>My code is as follows:</p> <p>In EditTask:</p> <pre><code>private void fillData() { Cursor categoriesCursor; Spinner categoriesSpinner = (Spinner) findViewById(R.id.spinDept); categoriesCursor = DatabaseAdapter.fetchAllCategories(); startManagingCursor(categoriesCursor); String[] from = new String[] { DatabaseAdapter.CAT_NAME }; int[] to = new int[] { R.id.tvDBViewRow }; //this part hasnt been implemented in to the layout yet SimpleCursorAdapter categoriesAdapter = new SimpleCursorAdapter(this, R.layout.db_view_row, categoriesCursor, from, to); categoriesSpinner.setAdapter(categoriesAdapter); } </code></pre> <p>And in my DatabaseAdapter class I have the following:</p> <pre><code>public Cursor fetchAllCategories() { if (mDb == null) { this.open(); } String tableName = "CAT_TABLE"; return mDb.query(tableName, new String[] { CAT_ID, CAT_NAME }, null, null, null, null, null); } </code></pre> <p>The offending line of code is:</p> <pre><code>categoriesCursor = DatabaseAdapter.fetchAllCategories(); </code></pre> <p>I'm pretty new to Java/Android so it may be something simple/obvious but any help is much appreciated! </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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