Have you checked the value of db before the call to
openOrCreateDatabase ?
On Sep 1, 12:56 am, "Bharath B.G." <bharath.ml...@gmail.com> wrote:
> Hi, I am very new to SQLite, i referred some books regarding coding in
> SQLite n went straight for coding
>
> But while i run my simple code i am getting error "the application has
> stopped unexpectadly" (particularly in the line create table)
>
> please tell me where exactly is the error n where i hav to modify the code
>
> package com.android;
>
> import android.app.Activity;
> import android.content.Context;
> import android.database.Cursor;
> import android.database.sqlite.SQLiteDatabase;
> import android.os.Bundle;
> import android.widget.EditText;
>
> public class DatabaseWork extends Activity {
>
> private EditText et;
>
> public void onCreate(Bundle icicle) {
> super.onCreate(icicle);
>
> setContentView(R.layout.main);
> et=(EditText)findViewById(R.id.EditText01);
>
> tryThis();
>
> }
>
> public void tryThis()
> {
> final String DATABASE_NAME="myDatabse.db";
> final String DATABASE_TABLE="myTable";
> final int DATABASE_VERSION=1;
>
> final String COL_NAME="name";
> final String COL_ID="id";
>
> SQLiteDatabase db;
>
> db=openOrCreateDatabase(DATABASE_NAME, 0, null);
> db.execSQL("create table myTable (id integer primary key, name text not
> null);");
>
> db.execSQL("insert into myTable values (1, \"Bharath\");");
> db.execSQL("insert into myTable values (2, \"Abhijith\");");
>
> Cursor c=db.query(DATABASE_TABLE, new String[] { COL_ID,COL_NAME}, null,
> null, null, null, null);
>
> int idCol=c.getColumnIndex(COL_ID);
> int nameCol=c.getColumnIndex(COL_NAME);
>
> String s=null;
>
> while(true)
> {
> String name=c.getString(nameCol);
> s=s+" "+name;
> if(c.isLast())
> {
> break;
>
> }
> c.moveToNext();
> }
>
> et.setText(s);
>
> db.close();
>
> }
> }
>
> --
> Bharath B.G.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
