Databases
StackOverflow2013
Postsdbo
POtable not getting created
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POtable not getting created
    text
    copied!<p>I have written for tables creation but when i am trying to access the table from one of my screen its throwing exception . </p> <p>Even when i went do shell in commannd prompt i was not able to find that table . Any clue that i need to do .</p> <p>logs :</p> <pre><code>W/System.err( 275): at java.lang.Thread.run(Thread.java:1096) I/Database( 275): sqlite returned: error code = 1, msg = no such table: woman_registration D/AndroidRuntime( 275): Shutting down VM W/dalvikvm( 275): threadid=1: thread exiting with uncaught exception (group=0x4001d800) E/AndroidRuntime( 275): FATAL EXCEPTION: main E/AndroidRuntime( 275): android.database.sqlite.SQLiteException: no such table: woman_registration: , while compiling: SELECT DISTINCT * FROM woman_registration WHERE (m_name = ? AND f_name = ? and m_age_range = ?) E/AndroidRuntime( 275): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method) E/AndroidRuntime( 275): at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:91) E/AndroidRuntime( 275): at android.database.sqlite.SQLiteCompiledSql.&lt;init&gt;(SQLiteCompiledSql.java:64) E/AndroidRuntime( 275): at android.database.sqlite.SQLiteProgram.&lt;init&gt;(SQLiteProgram.java:80) E/AndroidRuntime( 275): at android.database.sqlite.SQLiteQuery.&lt;init&gt;(SQLiteQuery.java:46) E/AndroidRuntime( 275): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42) E/AndroidRuntime( 275): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1345) E/AndroidRuntime( 275): at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1229) E/AndroidRuntime( 275): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1184) E/AndroidRuntime( 275): at org.atl.db.DBAdapter.isWomanAlreadyRegisgtered(DBAdapter.java:376) E/AndroidRuntime( 275): at com.accenturelabs.idoc.RegisterWoman.registerMother(RegisterWoman.java:237) E/AndroidRuntime( 275): at com.accenturelabs.idoc.RegisterWoman.access$1(RegisterWoman.java:223) E/AndroidRuntime( 275): at com.accenturelabs.idoc.RegisterWoman$4.onClick(RegisterWoman.java:141) E/AndroidRuntime( 275): at android.view.View.performClick(View.java:2408) E/AndroidRuntime( 275): at android.view.View$PerformClick.run(View.java:8816) E/AndroidRuntime( 275): at android.os.Handler.handleCallback(Handler.java:587) E/AndroidRuntime( 275): at android.os.Handler.dispatchMessage(Handler.java:92) E/AndroidRuntime( 275): at android.os.Looper.loop(Looper.java:123) E/AndroidRuntime( 275): at android.app.ActivityThread.main(ActivityThread.java:4627) E/AndroidRuntime( 275): at java.lang.reflect.Method.invokeNative(Native Method) E/AndroidRuntime( 275): at java.lang.reflect.Method.invoke(Method.java:521) E/AndroidRuntime( 275): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868) E/AndroidRuntime( 275): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626) E/AndroidRuntime( 275): at dalvik.system.NativeStart.main(Native Method) D/dalvikvm( 58): GC_FOR_MALLOC freed 18388 objects / 947880 bytes in 106ms W/ActivityManager( 58): Force finishing activity com.accenturelabs.idoc/.RegisterWoman I/ARMAssembler( 58): generated scanline__00000077:03515104_00000000_00000000 [ 33 ipp] (47 ins) at [0x34d7b0:0x34d86c] in 7148901 ns </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload