android - integer to string from database -
i have stored values in database followes:
"create table " + abezoeadapter.databasetabel + "(" + abezoeadapter.recordnummer + " integer, " + abezoeadapter.bezoekrapportnummer + " integer primary key autoincrement, " + abezoeadapter.bezoekrapportdatum + " datetime not null, " + abezoeadapter.herstellingsoort + " varchar(1) not null, " +
but gives me problems following reading routine
cursor c = onzedatabase.query(databasetabel, allekolommen, bezoekrapportnummer + "=?", new string[] {bezoeknummer}, null, null, null); int = 0; string data[] = new string[30]; data = null; (c.movetofirst(); !c.isafterlast(); c.movetonext()){ data[i] = c.getstring(i); log.i("abezoeadapter gegevenslezenvanbezoeknummer", "bezoeknummer = " + data[2]); }
out of logcat think problem because values stored integer, string, ...
logcat:
03-24 18:36:06.321: e/androidruntime(785): fatal exception: main 03-24 18:36:06.321: e/androidruntime(785): java.lang.runtimeexception: unable start activity componentinfo{com.example.deceunincktechniekers/com.example.deceunincktechniekers.bezoekrapporten}: java.lang.nullpointerexception 03-24 18:36:06.321: e/androidruntime(785): @ android.app.activitythread.performlaunchactivity(activitythread.java:2180) 03-24 18:36:06.321: e/androidruntime(785): @ android.app.activitythread.handlelaunchactivity(activitythread.java:2230) 03-24 18:36:06.321: e/androidruntime(785): @ android.app.activitythread.access$600(activitythread.java:141) 03-24 18:36:06.321: e/androidruntime(785): @ android.app.activitythread$h.handlemessage(activitythread.java:1234) 03-24 18:36:06.321: e/androidruntime(785): @ android.os.handler.dispatchmessage(handler.java:99) 03-24 18:36:06.321: e/androidruntime(785): @ android.os.looper.loop(looper.java:137) 03-24 18:36:06.321: e/androidruntime(785): @ android.app.activitythread.main(activitythread.java:5041) 03-24 18:36:06.321: e/androidruntime(785): @ java.lang.reflect.method.invokenative(native method) 03-24 18:36:06.321: e/androidruntime(785): @ java.lang.reflect.method.invoke(method.java:511) 03-24 18:36:06.321: e/androidruntime(785): @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:793) 03-24 18:36:06.321: e/androidruntime(785): @ com.android.internal.os.zygoteinit.main(zygoteinit.java:560) 03-24 18:36:06.321: e/androidruntime(785): @ dalvik.system.nativestart.main(native method) 03-24 18:36:06.321: e/androidruntime(785): caused by: java.lang.nullpointerexception 03-24 18:36:06.321: e/androidruntime(785): @ com.example.deceunincktechniekers.abezoeadapter.gegevenslezenvanbezoeknummer(abezoeadapter.java:480) 03-24 18:36:06.321: e/androidruntime(785): @ com.example.deceunincktechniekers.bezoekrapporten.opslaan(bezoekrapporten.java:784)
what can solution different type of values internet searches didnt helped me out far
thanks in advance
string data[] = new string[30]; data = null;
you assign data
null
, try assign values it. hence npe. remove data = null
.
to deal variable number of entries, consider using e.g. arraylist<string>
instead of string[]
.
Comments
Post a Comment