data not insert into database in sqlite?

Question

Trying to insert data in database from edittext in android but data is not inserting.

MY CODE --

ContentValues values= new ContentValues();
values.put(KEY_EMAIL, GlobalVar.email);
values.put(KEY_NAME, GlobalVar.name);
myDataBase.insert(MY_EMP, null,values);

MY LOG CAT

04-10 09:50:20.121: E/running(280): create database called
04-10 09:50:20.121: E/running(280): chek database called
04-10 09:50:20.121: E/running(280): chek database try block called
04-10 09:50:20.171: E/running(280): create database called try block
04-10 09:50:20.191: E/running(280): copy database called
04-10 09:50:20.211: E/running(280): open data successfull
04-10 09:50:50.720: W/KeyCharacterMap(280): No keyboard for id 0
04-10 09:50:50.720: W/KeyCharacterMap(280): Using default keymap: /system/usr/keychars/qwerty.kcm.bin

`

It seems that you're missing the relevant log output because there's no stack trace. Is this code throwing an exception? — Tyler Treat
– Tyler Treat, Commented Apr 10, 2012 at 4:33
please provide some more information from your log file like @Tyler Treat mentioned. — UVM
– UVM, Commented Apr 10, 2012 at 4:34
How can you say data not inserted in SQLite..have you checked the database from data folder in any SQLite browser? — MKJParekh
– MKJParekh, Commented Apr 10, 2012 at 5:12

CjS · Accepted Answer · 2012-04-10 06:32:16Z

2

If you don't supply all the required column data (i.e. data for all columns that don't have a default value, accept null, or are auto-incrementing), then the insert command will fail.

However, if insert fails, it doesn't throw an exception. It just returns -1.

Check the result of your insert call, or better yet, change the call to

myDataBase.insertOrThrow(MY_EMP, null,values);

and then check the logs for the exception message assuming there is one.

answered Apr 10, 2012 at 6:32

CjS

2,0472 gold badges21 silver badges29 bronze badges

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

Comments

Basimalla Sebastin · Accepted Answer · 2012-04-10 04:48:12Z

1

It seems u r missing the required parameters in myDataBase.insert(MY_EMP, null,values); it should be myDataBase.insert("Table Name ", "First column name ",cv);

Try this

answered Apr 10, 2012 at 4:48

Basimalla Sebastin

1,1993 gold badges9 silver badges15 bronze badges

1 Comment

Tyler Treat Over a year ago

This is not necessarily correct. The second parameter is the null column hack (and it's certainly not required), so unless he's inserting a completely empty row, which I don't think he is, this is wrong.

Collectives™ on Stack Overflow

data not insert into database in sqlite?

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