android - Getting error on inserting data on table using SQLite -


i'm building android mobile app , use sqlite database. i'm having trouble inserting record on table , returns toast message "insert failed" meaning saving data unsuccessful.

public class databasehelper extends sqliteopenhelper {      public static final string database_name = "mobilebuddy.db";     public static final string table_name = "bets_table";     public static final string col_1 = "combination";     public static final string col_2 = "draw_date";     public static final string col_3 = "trans_date";      public databasehelper(context context) {         super(context, database_name, null, 1);     }      @override     public void oncreate(sqlitedatabase db) {         db.execsql("create table " + table_name + "(" + col_1 + " text, " + col_2 + " datetime, " + col_3 + " datetime)");     }      @override     public void onupgrade(sqlitedatabase db, int oldversion, int newversion) {         db.execsql("drop table if exists " + table_name);         oncreate(db);     }      public boolean insertbetdata(string combination, string drawdate, string transdate) {         sqlitedatabase db = this.getwritabledatabase();         contentvalues contentvalues = new contentvalues();         contentvalues.put(col_1, combination);         contentvalues.put(col_2, drawdate);         contentvalues.put(col_3, transdate);         long result = db.insert(table_name, null, contentvalues);         if (result == 1) return true; else return false;     } }

i used code below in onclick event , should trigger insertion of data on table. 

calendar = calendar.getinstance(); simpledateformat sdf = new simpledateformat("yyyy-mm-dd"); boolean issave = lottodb.insertbetdata(validbet, sdf.format(calendar.gettime()), sdf.format(calendar.gettime())); if (issave == true)     toast.maketext(playsixnumbers.this, "inserted", toast.length_short).show(); else     toast.maketext(playsixnumbers.this, "insert failed", toast.length_short).show();

what's wrong codes? hope understand inquiry..

the documentation says insert() function returns

the row id of newly inserted row, or -1 if error occurred

the id not 1. have check return value not error value.

and better idea use insertorthrow() instead useful error message.


Comments

Post a Comment

Popular posts from this blog

javascript - Knockout pushing observable and computed data to an observable array -

i trying push multiple data (firstname , lastname), along when compute firstname , lastname , try push data in same array thrown error. below code. viewmodel: var viewmodel = function () { var self = this; self.gameofthrones = ko.observablearray ([ {firstname: 'jon', lastname: 'snow'}, {firstname: 'robb', lastname: 'stark'} ]); self.firstname = ko.observable(''); self.lastname = ko.observable(''); (var i=0; i<self.gameofthrones().length; i++) { self.gameofthrones()[i].fullname = ko.computed (function () { return self.gameofthrones()[i].firstname+" "+self.gameofthrones()[i].lastname; }) }; $('#classic').click( function() { self.gameofthrones.push( {firstname: $('#fn').val(), lastname: $('#pr').val()} ); }); } ko.applybindings(new viewmodel()); html view: <form class="" action="index.html" method="post"...
Read more

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

Trouble making a JSON string -

i'm trying upgrade existing json structure more complex one. the original idea bunch of x animals , each 1 having bunch of caracteristics: animals animal 1 claws:4 eyes:2 animal 2 claws:0 eyes:6 etc. the json this: { "animals":[ {"claws":"4", "eyes":"2"}, {"claws":"0", "eyes":"6"}, etc. ] } so can see, don't name each animal object, caracteristics of animal element of array. can use them in loop animals[x].claws now want add nest each animal, like: animals animal 1 head eyes:2 ears:2 body claws:4 tails:1 legs:4 animal 2 head eyes:6 ears:0 body claws:0 tails:0 legs:8 but didn't manage without naming each animal object (with same name "animal") , using arrays what's in animal: { "animals":[ {"animal":[ {"head": ...
Read more