SQLite foreign key NullPointerException

Question

I'm using Android studio , sqlite database my code was working correctly , but when I added "posid" column to "contacts" table the program doesn't work

logcat while insert contact

......... thanks for everybody can help me

Why did you add a screenshot of your logcat? Please copy and paste the exact text. — CubeJockey, Jan 15 '16 at 21:18
You never initialized et4, but it's being referenced in your insertBtn method. — Michael Krause, Jan 15 '16 at 21:29

Michael Krause · Answer 1 · 2016-01-15T21:57:15.867

1

You're referring to an EditText reference that has never been initialized. Namely, et4.

Also, I would suggest not having member variables that hold onto references to your views as this is a common source of memory leaks. Instead, just call findViewById when you need a local reference to your view.

edited Jan 15 '16 at 21:57

answered Jan 15 '16 at 21:30

Michael Krause

4,225
1
18
23

thanks a lot ,that solves my problem – n-m Jan 15 '16 at 21:59

score 1 · Accepted Answer · answered Jan 15 '16 at 21:33

1

You didn't initialize the EditText et4 and that's the reason for the exception, also when you update the table schema "add column(s)" you should increase your database version, so that android can update the table

int DATABASE_VERSION = 2; // instead of 1

answered Jan 15 '16 at 21:33

SaNtoRiaN

2,057
1
13
24

thanks a lot ,that solves my problem – n-m Jan 15 '16 at 21:58

SQLite foreign key NullPointerException

2 Answers2