database - Android: No such column -

-

here´s log-file: 

05-04 09:29:10.968: e/sqlitelog(26491): (1) no such column: datum 05-04 09:29:10.968: d/androidruntime(26491): shutting down vm 05-04 09:29:10.968: w/dalvikvm(26491): threadid=1: thread exiting uncaught exception (group=0x40edc930) 05-04 09:29:10.976: e/androidruntime(26491): fatal exception: main 05-04 09:29:10.976: e/androidruntime(26491): java.lang.runtimeexception: unable start activity componentinfo{com.example.unserekinder/com.example.unserekinder.mainactivity}: android.database.sqlite.sqliteexception: no such column: datum (code 1): , while compiling: select name, datum, geschlecht kind 05-04 09:29:10.976: e/androidruntime(26491):    @ android.app.activitythread.performlaunchactivity(activitythread.java:2180) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.app.activitythread.handlelaunchactivity(activitythread.java:2230) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.app.activitythread.access$600(activitythread.java:141) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.app.activitythread$h.handlemessage(activitythread.java:1234) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.os.handler.dispatchmessage(handler.java:99) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.os.looper.loop(looper.java:137) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.app.activitythread.main(activitythread.java:5041) 05-04 09:29:10.976: e/androidruntime(26491):    @ java.lang.reflect.method.invokenative(native method) 05-04 09:29:10.976: e/androidruntime(26491):    @ java.lang.reflect.method.invoke(method.java:511) 05-04 09:29:10.976: e/androidruntime(26491):    @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:793) 05-04 09:29:10.976: e/androidruntime(26491):    @ com.android.internal.os.zygoteinit.main(zygoteinit.java:560) 05-04 09:29:10.976: e/androidruntime(26491):    @ dalvik.system.nativestart.main(native method) 05-04 09:29:10.976: e/androidruntime(26491): caused by: android.database.sqlite.sqliteexception: no such column: datum (code 1): , while compiling: select name, datum, geschlecht kind 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqliteconnection.nativepreparestatement(native method) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqliteconnection.acquirepreparedstatement(sqliteconnection.java:882) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqliteconnection.prepare(sqliteconnection.java:493) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqlitesession.prepare(sqlitesession.java:588) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqliteprogram.<init>(sqliteprogram.java:58) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqlitequery.<init>(sqlitequery.java:37) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqlitedirectcursordriver.query(sqlitedirectcursordriver.java:44) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqlitedatabase.rawquerywithfactory(sqlitedatabase.java:1314) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqlitedatabase.querywithfactory(sqlitedatabase.java:1161) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqlitedatabase.query(sqlitedatabase.java:1032) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.database.sqlite.sqlitedatabase.query(sqlitedatabase.java:1200) 05-04 09:29:10.976: e/androidruntime(26491):    @ com.example.unserekinder.dbhelper.select(dbhelper.java:80) 05-04 09:29:10.976: e/androidruntime(26491):    @ com.example.unserekinder.mainactivity.listview_fuellen(mainactivity.java:52) 05-04 09:29:10.976: e/androidruntime(26491):    @ com.example.unserekinder.mainactivity.oncreate(mainactivity.java:27) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.app.activity.performcreate(activity.java:5104) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.app.instrumentation.callactivityoncreate(instrumentation.java:1080) 05-04 09:29:10.976: e/androidruntime(26491):    @ android.app.activitythread.performlaunchactivity(activitythread.java:2144) 05-04 09:29:10.976: e/androidruntime(26491):    ... 11 more

i read few other questions problem nothing helped me. seems me 1 column isn´t created. 

private static final string tag = dbhelper.class.getsimplename();     private static final string database_name = "unserekinder.db";     private static final int database_version = 2;      public static final string id = "_id";     public static final string table_name_kind="kind";     public static final string name = "name";     public static final string datum = "datum";     public static final string geschlecht = "geschlecht";      private static final string table_kind_create = "create table " + table_name_kind + " (" + id + " integer primary key autoincrement, "      + name + " text, " + datum + " text, " + geschlecht + " text);";        public static final string table_kind_drop = "drop table if exists kind";     public static final string table_kind_delete = "delete table if exists kind";             public dbhelper(context context){         super(context, database_name, null, database_version);     }      @override     public void oncreate(sqlitedatabase db) {         db.execsql(table_kind_create);      }

you see, statement must executed because in oncreate.

here select statement:

public void insert( string name, string datum, string geschlecht){         long rowid = -1;         try{              sqlitedatabase db = getwritabledatabase();             db.begintransaction();             contentvalues cv = new contentvalues();              cv.put(name, name);             cv.put(datum, datum);             cv.put(geschlecht, geschlecht);              rowid = db.insert(table_name_kind, null, cv);             db.endtransaction();         }         catch (sqliteexception e){             log.e(tag, "insert()", e);         }         finally{             log.d(tag, "insert(): rowid=" + rowid);         }     }      public void create(){         sqlitedatabase db = getwritabledatabase();         db.execsql(table_kind_create);     }      public cursor select(){         sqlitedatabase db = getreadabledatabase();         db.begintransaction();         cursor cursor = db.query(table_name_kind, new string[] {"name", "datum", "geschlecht"},                  "" + "", null, null, null, null);         db.endtransaction();         return cursor;     }

edit:

@override public void onupgrade(sqlitedatabase db, int oldversion, int newversion) {     log.w(tag, "upgrade der datenbank von version " + oldversion + "zu " +newversion+ "; alle daten werden gelöscht");     db.execsql(table_kind_drop);     oncreate(db); }

cursor cursor = db.query(table_name_kind, new string[] {"name", "datum", "geschlecht"}, "" + "", null, null, null, null); query wrong. mean following code? "" + "" can change ""+"" null.try it.


Comments

Post a Comment

Popular posts from this blog

Perl - how to grep a block of text from a file -

-
it can in xml or text format. how in general grep block of text in perl? <track type="ws"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>0</locationindex> <propertyindex>0</propertyindex> </range> </track> <track type="ps" id="1"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>1</locationindex> <propertyindex>1</propertyindex> </range> </track> i want grep type="ps" , till </range> . one solution open file, read line line , match block. open(fh, "file.txt"); foreach $line (<fh>) { if ($line =~ m/type="cc"(.*?)<\/range>/) { print $1; } } but there more optimal solution without reading file line l
Read more

delphi - How to remove all the grips on a coolbar if I have several coolbands? -

-
Image
if set mycoolbar.fixedorder true,only grip on first band hidden. well,if use delphi 7 create vcl forms application,then put coolbar on , create 3 coolbans hold other controls,only grip , top coolbands can hidden setting mycoolbar.fixedorder:=true. i've uploaded picture make things clear. you got fixedorder property wrong. fixed property not allow bands rearranged if set true . setting property of coolbar true keep user changing bands order @ runtime, user can still move , resize bands. can give advice can do, actual solution problem, well, have wait answer. my advice use 3 coolbars in row , setting "fixedorder" property true , bandborderstyle bsnone . way grip hidden on of them. about property, it's not bug of ide, actual preference of property.
Read more

javascript - Animating array of divs; only the final element is modified -

-
this baffling me @ moment. i'm experienced programmer looking throw bit of surprise fiancee on countdown page our wedding. desired effect simulated confetti falling behind main page. setup follows: i have array of divs in javascript. each div absolutely positioned on page. have interval set updates every 50 or milliseconds. on each tick, run loop on array of divs, , calculations , update positions. problem problem having, however, though can see divs created, stored array, , modified (in case, each has slight randomized rotation) during initialization phase, once tick update position starts, div stored in whatever last slot of array gets position updated. tried hard-coding each div index testing purposes, strictly last element update position. upon printing current "left" , "top" style values each div before , after calculations shows value has been changed, no visible change noticeable. here's basic code: javascript var container;
Read more