₦airaland Forum

I think the error is from the if statement downwards. I just removed the if & else statement & i didn't get any error.

lordZOUGA:
Your select query is missing a semi-colon. should be

String count = "SELECT COUNT (*) FROM NeamLoggedin;"; 

Thanks lordZOUGA i really appreciate your help. i've corrected that but still the error persists.

lordZOUGA:
jinf, I think you have to confirm that your table was created successfully first.

seems as if your create table query is wrong, should be something like

create table if not exists namedloggedin(status varchar(32));

Thanks. i did this now and it gives the same error

I've tried this but it gives this error: java.lang.NullPointerException

// Database
SQLiteDatabase db = openOrCreateDatabase("NeamLS.db", MODE_PRIVATE, null);

try {
// Create table

db.execSQL("CREATE TABLE IF NOT EXISTS NeamLoggedin (Status);";

// Select

String count = "SELECT COUNT (*) FROM NeamLoggedin";
Cursor result = db.rawQuery(count,null);
result.moveToFirst();
int icount = result.getInt(0);
if(icount>0) {
String status = result.getString(0);
}
// insert
else {
db.execSQL("INSERT INTO NeamLoggedin Values('newuser');";
String status = result.getString(0);
}
Toast.makeText (getBaseContext(), "Data: " +status.toString(), Toast.LENGTH_SHORT).show();

db.close();
}
catch (Exception e) { Toast.makeText (getBaseContext(), "Error: " +e.toString(), Toast.LENGTH_LONG).show(); }

Please can anyone help me on how to check if a column in sqlite table is empty before inserting data into that column.

nollyj:
It should be exists instead of exist (notice the "s" at the end).

OMG Thanks! God bless you. I've corrected it and it's working.

I'm getting this error: android.database.sqlite.SQLiteException: near "EXIST": syntax error: CREATE TABLE IF NOT EXIST EPuserStatus(Status VARCHAR);

See my code below...

SQLiteDatabase db = openOrCreateDatabase("ExamPoemsStatus", MODE_PRIVATE, null);

try {
db.execSQL("CREATE TABLE IF NOT EXIST EPuserStatus(Status VARCHAR);";
db.execSQL("INSERT INTO EPuserStatus Values('good');";

Cursor result = db.rawQuery("SELECT * FROM EPuserStatus", null);
result.moveToFirst();
String status = result.getString(1);




Toast.makeText (getBaseContext(), "Data: " +status.toString(), Toast.LENGTH_SHORT).show();

db.close();
}
catch (Exception e) {Toast.makeText (getBaseContext(), "Error: " +e.toString(), Toast.LENGTH_LONG).show();
}

One year after Boko Haram atrocity: Letter from a kidnapped Chibok girl:

READ @=> http://davidvsnaija..com/2015/04/one-year-after-boko-haram-atrocity_14.html

One year after Boko Haram atrocity: Letter from a kidnapped Chibok girl:

READ @=> http://davidvsnaija..com/2015/04/one-year-after-boko-haram-atrocity_14.html

Bossman:
In my opinion, it's best to learn on your own. Get the tools you need if you do not already have them - a book for your language of choice (plenty online), install the appropriate development environment on your pc/laptop, and go from there. If you run into any road block, just post the issue here. There are quite a number of knowledgeable folks here that are able and willing to assist you.

Thanks.

Please can anyone recommend where to learn Android Programming or Java Programming in Abuja excluding NIIT and Aptech.

Oba Rilwan was drunk when he threatened Igbos living in Lagos:

READ @=> http://davidvsnaija..com/2015/04/oba-rilwan-was-drunk-when-he-threatened.html

Oba Rilwan was drunk when he threatened Igbos living in Lagos:

READ @=> http://davidvsnaija..com/2015/04/oba-rilwan-was-drunk-when-he-threatened.html

hmm

Oba Rilwan was drunk when he threatened Igbos living in Lagos:

READ @=> http://davidvsnaija..com/2015/04/oba-rilwan-was-drunk-when-he-threatened.html

President Jonathan urges PDP to celebrate and not mourn as PDP vows to challenge Buhari's victory at tribunal:

READ @=> http://davidvsnaija..com/2015/04/president-jonathan-urges-pdp-to.html

President Jonathan urges PDP to celebrate and not mourn as PDP vows to challenge Buhari's victory at tribunal:

READ @=> http://davidvsnaija..com/2015/04/president-jonathan-urges-pdp-to.html

President Jonathan urges PDP to celebrate and not mourn as PDP vows to challenge Buhari's victory at tribunal:

READ @=> http://davidvsnaija..com/2015/04/president-jonathan-urges-pdp-to.html

Buhari thanks Nigerians for voting him in:

READ @=> http://davidvsnaija..com/2015/03/buhari-thanks-nigerians-for-voting-him.html

Buhari thanks Nigerians for voting him in:

READ @=> http://davidvsnaija..com/2015/03/buhari-thanks-nigerians-for-voting-him.html

Irrespective of who wins the presidential election...:

READ @=> http://davidvsnaija..com/2015/03/irrespective-of-who-wins-presidential.html

Irrespective of who wins the presidential election...:

READ @=> http://davidvsnaija..com/2015/03/irrespective-of-who-wins-presidential.html

Irrespective of who wins the presidential election...:

READ @=> http://davidvsnaija..com/2015/03/irrespective-of-who-wins-presidential.html

Why vote Buhari instead of Jonathan? http://davidvsnaija..com/2015/03/why-vote-buhari-instead-of-jonathan-why.html

Why vote Buhari instead of Jonathan? http://davidvsnaija..com/2015/03/why-vote-buhari-instead-of-jonathan-why.html

Why vote Buhari instead of Jonathan? http://davidvsnaija..com/2015/03/why-vote-buhari-instead-of-jonathan-why.html

Goodluck Jonathan vs Muhammadu Buhari who should we vote for tomorrow and why?

Share your thoughts @=> http://davidvsnaija..com/2015/03/why-vote-buhari-instead-of-jonathan-why.html

Why vote Buhari instead of Jonathan? || Why vote Jonathan instead of Buhari?:

READ @=> http://davidvsnaija..com/2015/03/why-vote-buhari-instead-of-jonathan-why.html

Why vote Buhari instead of Jonathan? || Why vote Jonathan instead of Buhari?:

READ @=> http://davidvsnaija..com/2015/03/why-vote-buhari-instead-of-jonathan-why.html

Boko Haram releases new video | Vows to disrupt March 28 and April 11 polls:

READ @=> http://davidvsnaija..com/2015/02/boko-haram-releases-new-video-vows-to.html

Boko Haram releases new video | Vows to disrupt March 28 and April 11 polls:

READ @=> http://davidvsnaija..com/2015/02/boko-haram-releases-new-video-vows-to.html

Boko Haram releases new video | Vows to disrupt March 28 and April 11 polls:

READ @=> http://davidvsnaija..com/2015/02/boko-haram-releases-new-video-vows-to.html