I am attempting to figure out where my code is going wrong. Any help at all
would be appreciated. I am SO frustrated about this. Here's the story. I
have code copied from this seemingly popular tutorial:
http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/
I've made only those alterations absolutely necessary to fit my database and
package.
Then in the activity which calls that I have this:
package com.TBOM;
>
> import java.io.IOException;
>
> import android.app.Activity;
> import android.database.Cursor;
> import android.database.SQLException;
> import android.database.sqlite.SQLiteDatabase;
> import android.os.Bundle;
> import android.widget.TextView;
>
> public class Game extends Activity {
> //private DataBaseHelper myDBHelper;
> private final String MY_DB_NAME = "bom";//test
> private final String MY_DB_TABLE = "tst";//test
> public static final String KEY_Q = "title";
> public static final String KEY_ANS1 = "Ans1";
> public static final String KEY_ANS2 = "Ans2";
> public static final String KEY_ANS3 = "Ans3";
> public static final String KEY_ANS4 = "Ans4";
> public static final String KEY_ANSKEY = "AnsKey";
> public static final String KEY_ANSINFO = "AnsInfo";
> public static final String KEY_ROWID = "_id";
>
> @Override
> public void onCreate(Bundle Game) throws SQLException{
> super.onCreate(Game);
> setContentView(R.layout.game);
> DataBaseHelper myDbHelper = new DataBaseHelper(this);
> TextView qTV = (TextView) findViewById(R.id.Qtxt);
> SQLiteDatabase myQDB = null;
>
> try {
> myDbHelper.createDataBase();
> qTV.setText("WIN1");
> } catch (IOException ioe) {
> qTV.setText("FAIL1");
> throw new Error("Unable to create database");
>
> }
>
> try {
> myDbHelper.openDataBase();
> qTV.setText("WIN2");
> }catch(SQLException sqle){
> qTV.setText("FAIL2");
> throw sqle;
> }
>
> myDbHelper.openDataBase();//test
>
> int rowId=3;
> myQDB = SQLiteDatabase.openDatabase(MY_DB_NAME, null,
> SQLiteDatabase.OPEN_READONLY);
> Cursor qCursor = myQDB.query(true, MY_DB_TABLE, new String[]
> {}, KEY_ROWID+ "="+ rowId, null,null,null, null, null);
> // mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,
> //KEY_TITLE, KEY_BODY}, KEY_ROWID + "=" + rowId, null,
> //null, null, null, null);
> int qColumn = qCursor.getColumnIndex(KEY_Q);
> //int idColumn = qCursor.getColumnIndex(KEY_ROWID);
> if(qCursor != null){
> String qString = qCursor.getString(qColumn);
> //int row = qCursor.getInt(idColumn);
> qTV.setText(qString);
> }
>
>
>
>
> }
>
> }
>
>
When I try to run this in the emulator, it tells me that the application has
'stopped unexpectedly". Can anyone please explain to me what is going on?
For the record everything was fine with the code just before teh line "
myDbHelper.openDataBase();//test". Everything from there on (essentially
when I attempt to read data from teh db).
Again, I am so confused and lost that I just don't know what to do. You can
infer the structure of the db from the KEY_* variables that I've included.
Thanks in advance.
Ben
--
I have no bit of wisdom to include as a signature.
--
You received this message because you are subscribed to the Google
Groups "Android Beginners" group.
NEW! Try asking and tagging your question on Stack Overflow at
http://stackoverflow.com/questions/tagged/android
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
To unsubscribe from this group, send email to
android-beginners+unsubscribegooglegroups.com or reply to this email with the
words "REMOVE ME" as the subject.
