Click here to Skip to main content
15,885,435 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hi everyone
when ever insert a data in to data base no any data insert in data base and no any kind of error display ....
how to solve this error ???
log cat out put is...


10-10 15:06:15.907: E/SQLiteDatabase(3279): Error inserting ename=amj emobileno=65 eid=6 eemail=knjfd eadd=awi
10-10 15:06:15.907: E/SQLiteDatabase(3279): android.database.sqlite.SQLiteException: near "create": syntax error: , while compiling: INSERT INTO create table empl_detail(eid INTEGER, ename TEXT, eadd TEXT, eemail TEXT, emobileno INTEGER);(ename,emobileno,eid,eemail,eadd) VALUES (?,?,?,?,?)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:64)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:260)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:112)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1718)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1591)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at com.example.dbdemo.Database.insert(Database.java:87)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at com.example.dbdemo.Insert_data$1.onClick(Insert_data.java:41)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.view.View.performClick(View.java:3480)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.view.View$PerformClick.run(View.java:13983)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.os.Handler.handleCallback(Handler.java:605)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.os.Handler.dispatchMessage(Handler.java:92)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.os.Looper.loop(Looper.java:137)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at android.app.ActivityThread.main(ActivityThread.java:4340)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at java.lang.reflect.Method.invokeNative(Native Method)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at java.lang.reflect.Method.invoke(Method.java:511)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
10-10 15:06:15.907: E/SQLiteDatabase(3279): at dalvik.system.NativeStart.main(Native Method)
Posted
Comments
[no name] 10-Oct-14 6:12am    
You should probably start by fixing the insert query syntax.
Mehul Tank 12-Oct-14 6:17am    
insert query write is properly but when ever compile it column name is changed..
how i solve this problem ????
CHill60 12-Oct-14 8:15am    
That is not what that output is saying - it quite clearly says there is a syntax error in your insert query. Share your table definition - or at least the definition for [eid]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900