Android SQL Errors

Question

I've been following a tutorial for working with SQL databases, I think I'm having issues with it because it has been written a while ago.

For example it had this.createDatabase which had to be replaced with this.openOrCreateDatabase, I found this with Google. There are other problems that I cannot find the solutions to: Query, Results, Next, setListAdapter all show errors.

Is this in fact the problem, that the tutorial has been created for an earlier SDK? Can someone please tell me where to go to see deprecated methods and their replacements or point out what I should be replacing the above with?

Apologies I'm just starting out with this, hopefully you understand what I mean. Help is very much appreciated.

EDIT: Tutorial is here: http://www.anddev.org/novice-tutorials-f8/working-with-the-sqlite-database-cursors-t319.html

The problems are in the code below, c.first, results.add, c.next, this.setListAdapter and most of the last line have errors

if (c.first()) {
                            int i = 0;
                            /* Loop through all Results */
                            do {
                                    i++;
                                    /* Retrieve the values of the Entry
                                     * the Cursor is pointing to. */
                                    String firstName = c.getString(firstNameColumn);
                                    int age = c.getInt(ageColumn);
                                    String ageColumName = c.getColumnName(ageColumn);

                                    /* Add current Entry to results. */
                                    results.add("" + i + ": " + firstName
                                   + " (" + ageColumName + ": " + age + ")");
                            } while (c.next());
                    }
            }

    } catch (FileNotFoundException e) {
    } finally {
            if (myDB != null)
                    myDB.close();
    }
    this.setListAdapter(new ArrayAdapter<String>(this,
            android.R.layout.simple_list_item_1_small, results));

} }

BTW which tutorial you are referring to? Please share the URL.. — TheCottonSilk
– TheCottonSilk, Commented Jan 31, 2011 at 13:33

TheCottonSilk · Accepted Answer · 2011-01-31 13:30:52Z

1

You can have a look at the sample notepad source NotepadProvider, NoteEditor and NoteList for implementation.

edited Jan 31, 2011 at 13:30

answered Jan 31, 2011 at 13:25

TheCottonSilk

8,8623 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dave.c · Accepted Answer · 2011-01-31 21:45:19Z

0

The android documentation should show which methods have been deprecated and what to replace their use with. For example, Context.clearWallpaper().

SQLLite Database documentation

If you look at the documentation, in the upper right hand side of each method name it states the API level that the method was introduced in. eg. openOrCreateDatabase (String path, SQLiteDatabase.CursorFactory factory) is since API level 1.

If you want help with specific methods then you will need to either give us the link to the tutorial or (more preferably) post some code.

EDIT
At the very top of the tutorial you linked to it says:

:warning: Compatible for SDK version m3-xxx or older

It's now out of date. You should check the data storage page, then review the examples in the post by @TheCottonSilk

edited Jan 31, 2011 at 21:45

answered Jan 31, 2011 at 13:52

dave.c

10.9k5 gold badges42 silver badges64 bronze badges

1 Comment

mao Over a year ago

ok thanks, the tutorial is here: anddev.org/novice-tutorials-f8/…

Collectives™ on Stack Overflow

Android SQL Errors

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related