Error while running SQLiteQuery

Question

I am trying to save a score if it is no there. And if it's available then i need to get the highest score from the database.

SQLiteDatabase db= openOrCreateDatabase("tryitdb", MODE_PRIVATE, null);
            String sql= "create table if not exists tabletry(score int)";
            db.execSQL(sql);
            db.close();
            tv1= (TextView) findViewById(R.id.textView1);
            et1= (EditText) findViewById(R.id.editText1);
            b1 = (Button) findViewById(R.id.button1);
            b1.setOnClickListener(new OnClickListener() {
                public void onClick(View v) {
                    getsc();
                }
            });
        };
        public void getsc() {
            SQLiteDatabase db= openOrCreateDatabase("tryitdb", MODE_PRIVATE, null);
            String sql= "select * from tabletry";
            Cursor c1= db.rawQuery(sql, null);
            if(c1.isNull(0)){
                init();
            }
            else{
                int i1= c1.getColumnIndex("score");
                String l= c1.getString(i1);
                int old= Integer.valueOf(l);
                int str= Integer.valueOf(et1.getText().toString());
                if(old>=str){
                    tv1.setText(old);
                }
                else{
                    tv1.setText(str);
                }
            }

        }
        public void init() {
             SQLiteDatabase db= openOrCreateDatabase("tryitdb", MODE_PRIVATE, null);
             String string= "insert into tabletry values(?,?)";
             Object[] o= new Object[1];
             o[0] = et1.getText().toString();
             db.execSQL(string,o);
             db.close();
        }

The stacktrace tells me there is no such table as table try. Also gives me an error on the particular line

Cursor c1= db.rawQuery(sql, null);

Please suggest a fix to the issue. Thanks.

after changing it to execSQL it still gives me an exception on if(c1.isNull(0)) — Shubhankar
– Shubhankar, Commented Mar 1, 2014 at 5:38

Nitin · Accepted Answer · 2014-03-01 06:09:52Z

2

please manage your cursor.

  if (cursor != null && cursor.getCount() > 0) {

           c.moveToFirst(); 
                    // your logic goes here
                } else {
                    Toast.makeText(getApplicationContext(), "No Record Found", 1000).show();
                }

if you have several data then you can try

 if (cursor != null && cursor.getCount() > 0) {

   if (cur.moveToFirst()) {
  do {


    cur.getString(0); //any thing what you want to fetch

                    } while (cur.moveToNext());
                }}

edited Mar 1, 2014 at 6:09

answered Mar 1, 2014 at 5:56

Nitin

2582 silver badges8 bronze badges

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

Comments

VenomVendor · Accepted Answer · 2014-03-01 05:32:34Z

0

Change >> db.equals(sql); to db.execSQL(sql);

answered Mar 1, 2014 at 5:32

VenomVendor

15.5k13 gold badges70 silver badges97 bronze badges

1 Comment

Shubhankar Over a year ago

getting cursorindexoutofbound exception

Collectives™ on Stack Overflow

Error while running SQLiteQuery

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