android - Why am i getting the error, Table *tableTame* has no column named *columnName* -

-

tried updating database version per other posts on stackoverflow no avail

essentially it's android application adds entry database , displays in in listview. when invoke inserta method following error in logcat believe cause of errors)

 04-25 13:47:08.697: e/sqlitelog(1783): (1) table adb has no column named p 04-25 13:47:08.747: e/sqlitedatabase(1783): error inserting progress=aa mp=aa an=aa mc=aa wd=aa 04-25 13:47:08.747: e/sqlitedatabase(1783): android.database.sqlite.sqliteexception: table has no column named p (code 1): , while compiling: insert a(p,mp,an,mc,wd) values (?,?,?,?,?)

the question is, why saying there there no column named p when able make others not p?

public void oncreate(sqlitedatabase database) {      string sqlitequery = "create table assignments ( " +             "assignmentid integer primary key," +             "modulecode text, " +             "assignmentname text, " +             "whendue text, " +             "marksproportion text, " +             "progress text " + ")";  database.execsql(sqlitequery);  }  @override public void onupgrade(sqlitedatabase database, int oldversion, int newversion) {     string query = "drop table if exists assignments";      database.execsql(query);     oncreate(database); }  //key valued pair hash map passes values database public void insertassignment (hashmap<string, string> queryvalues) {     sqlitedatabase database = this.getwritabledatabase();      contentvalues values = new contentvalues();      values.put("modulecode", queryvalues.get("modulecode"));     values.put("assignmentname", queryvalues.get("assignmentname"));     values.put("whendue", queryvalues.get("whendue"));     values.put("marksproportion", queryvalues.get("marksproportion"));     values.put("progress", queryvalues.get("progress"));      database.insert("assignments", null, values);     database.close(); }

from initial question:

string sqlitequery = "create table adb( " +     :     "wd text, " +     "mp text " +     "p text " + ")";

you need comma after mp text, after other columns before it.

what have there is:

create table adb( ... wd text, mp text p text )                                   ^^^^^^                                problem here.

however, if have added comma , problem still exists, possibility database not being created expect.

you should place debug statements in onupgrade , oncreate calls see if being done. if not, find out why they're not being called.

the other possibility that, in over-eagerness protect column names, have made mistake in transcription or removed vital piece of information.

i'm not entirely why think need protect such precious ip column names progress , modulecode (especially since can see them in edit history still), should aware such attempts make harder you, not easier :-)


Comments

Post a Comment

Popular posts from this blog

How to access named pipes using JavaScript in Firefox add-on? -

-
i'm trying access named pipe in firefox add-on. code, based on solution 2 this codeproject question, is: var file = components.classes["@mozilla.org/file/local;1"].createinstance(components.interfaces.nsilocalfile); file.initwithpath("\\\\.\\pipe\\test"); var text = "some text written"; var writer = components.classes["@mozilla.org/network/file-output-stream;1"].createinstance(components.interfaces.nsifileoutputstream); // open file read/write access, , create if not exist. writer.init (file, 0x04 | 0x08, -1, 0); writer.write (text, text.length); writer.flush (); writer.close (); when run firefox scratchpad, get: /* exception: component returned failure code: 0x80520012 (ns_error_file_not_found) [nsifileoutputstream.init] @6 */ line 6 line call writer.init. i've played passing different flags writer.init, no luck. i'm able write normal file path code, not named pipe path. i've been searching more information of da...
Read more

multithreading - OPAL (Open Phone Abstraction Library) Transport not terminated when reattaching thread? -

-
i in process of writing application using opal makes h323 calls. have looked online number of working examples , have managed put resembles should like, @ present able call external ip via application when accept call craps out , dies. leaving me with: 0:12.949 setupcall:8752 sert.cxx(259) assertion fail: transport not terminated when reattaching thread , file d:\voip\software\opal\src\opal\transports.cxx, line 1021 passertfunc(0xde3f88, 0xffffffffd228226f, 0, 0) + 0x82 passertfunc(0x10d6e5f8, 0x3fd, 0, 0x10d6eb98) + 0x15b opaltransport::attachthread(0xde5870, 0xffffffffd22fc76b, 0, 0) + 0x96 h323connection::setupconnection(0xffffffffd22fc713, 0, 0, 0xde6ea8) + 0x196 asynchcallsetup(0x10d3572c, 0, 0, 0xdd0108) + 0x7c pthread1arg<psafeptr<opalconnection,psafeptrbase> >::main(0xffffffffd2282faf from have deduced, perhaps incorrectly if there thread lock issue caused (possibly arising fact application sending expected h323 call, throwing in c...
Read more

node.js - req param returns an empty array -

-
i using node.js , mongodb geolocation app , req param returns empty array exports.findpressure = function(req, res) { var queryobject = req.param('q'); console.log(queryobject); db.collection('pressure', function(err, collection) { collection.find( { loc: { $near :[ req.param('q') ] , $maxdistance : 5 }},{"value" : 1, _id : 0}) .sort({_id : -1}).limit(1).toarray(function(err, items) { res.send(items); }); }); }; the longitude , latitude values displayed in console listening on port 3000... connected 'weather' database 8.9068256,52.019347499999995 /pressure?q=8.9068256,52.019347499999995 200 27ms - 2b the url follows http://localhost:3000/pressure?q=8.9068256,52.019347499999995 if use values 8.9068256,52.019347499999995 getting value database if use req.param('q') returning empty array you seem passing values part of query string. req.query.q should contain comma-s...
Read more