android - Foreign Key Constraint Failed 787 causing abort on attempt to insert entry into table -

-

trying insert accounts table. data collected fine , thing runs smooth until after confirms account added. @ point operation aborted due foreign key constraint failure shown here :

logcat

04-01 22:58:58.750  23053-23053/? e/sqlitelog﹕ (787) abort @ 37 in [insert accounts(terms,amount,accountname,datecreated,status,balance,purpose,payperiod) values (?,?,?,?,?,?,?,?)]: foreign key constraint failed 04-01 22:58:58.999  23053-23053/? e/sqlitedatabase﹕ error inserting terms=0 amount=10000 accountname=acc 1 datecreated=04-01-2015 22:58:58 status=1 balance=10000 purpose=test payperiod=1

i've pulled dbfile , opened check if tables accounts referenced we're populating , are. i've ran database schema in sqlfiddle see fails , ran without problems.

now i'm lost , don't know should looking for, if can point me in direction of mistake appreciated.

database helper

oncreate

@override public void oncreate(sqlitedatabase db) {       db.execsql("create table " + termstable + " (" + coltermsid + " integer primary key , " + coltermsclass + " text)");      db.execsql("create table " + periodtable + " (" + colperiodid + " integer primary key , " + colperiodclass + " text)");      db.execsql("create table " + stattable + " (" + colstatusid + " integer primary key , " + colstatclass + " text)");      db.execsql("create table " + accountstable + " (" + colid + " integer primary key autoincrement, " +             colname + " text, " +             colamount + " integer, " +             colpurpose + " text, " +             colterms + " integer not null, " +             colperiod +" integer not null, " +             colbalance +" integer, "+             colstatus + " integer default '1'," +             coldate + " text, " +             coleditdate + " text, " +             "foreign key (" + colterms + ") references " + termstable + " (" + coltermsid + ") " + "," +             "foreign key (" + colperiod + ") references " + periodtable + " (" + colperiodid + ") " + "," +             "foreign key (" + colstatus + ") references " + stattable + " (" + colstatusid + "));");      db.execsql("create table " + paytable + " (" + colpayid + " integer primary key , " +             colgroupid + " integer not null, " +             colpaybal + " text, " +             colinterest + " text, " +             colpaydue + " text, " +             coldatedue + " text, " +             colpaid + " integer, " +             "foreign key (" + colgroupid + ") references " + accountstable + " (" + colid + ") on delete cascade);");      db.execsql("create view " + viewaccs +             " select " + accountstable + "." + colid + " _id," +             " " + accountstable + "." + colname + "," +             " " + accountstable + "." + colamount + "," +             " " + accountstable + "." + colpurpose + "," +             " " + termstable + "." + coltermsclass + "," +             " " + periodtable + "." + colperiodclass + "," +             " " + accountstable+ "." + colbalance + "," +             " " + stattable + "." + colstatclass + "," +             " " + accountstable + "." + coldate + "," +             " " + accountstable + "." + coleditdate + "" +             " " + accountstable +             " join " + termstable + " on " + accountstable + "." + colterms + " = " + termstable + "." + coltermsid +             " join " + periodtable + " on " + accountstable + "." + colperiod + " = " + periodtable + "." + colperiodid +             " join " + stattable + " on " + accountstable + "." + colstatus + " = " + stattable + "." + colstatusid );      db.execsql("create view " + viewpmnts +             " select " + paytable + "." + colpayid + " _id," +             " " + accountstable + "." + colid + "," +             " " + paytable + "." + colgroupid + "," +             " " + paytable + "." + colpaybal + "," +             " " + paytable + "." + colinterest + "," +             " " + paytable + "." + colpaydue + "," +             " " + paytable + "." + coldatedue + "," +             " " + paytable + "." + colpaid + "" +             " " + paytable +             " join " + accountstable + " on " + paytable + "." + colgroupid + " = " + accountstable + "." + colid );      insertterms(db);     insertperiods(db);     insertstatus(db);  }

addaccount ( method within databasehelper ) 

void addaccount(account acc) {       sqlitedatabase db = this.getwritabledatabase();       contentvalues cv = new contentvalues();      cv.put(colname, acc.getname());     cv.put(colamount, acc.getamt());     cv.put(colpurpose, acc.getpurpose());     cv.put(colterms, acc.getterms());     cv.put(colperiod, acc.getperiod());     cv.put(colbalance, acc.getamt());     cv.put(coldate, acc.getdate());     cv.put(colstatus, acc.getstatus());      db.insert(accountstable, colname, cv);     db.close();   }

based on values trying insert, there must termstable row id 0, stattable row id 1, , periodtable row id 1. if 1 of rows not exist foreign key constraint error. guess don't have terms row id 0.


Comments

Post a Comment

Popular posts from this blog

How can we post XML strings along with text strings in iOS -

-
nsstring *starcardstr=@"https://starcardsindia.com/test/api/userauthentication"; //nsstring *poststr=[nsstring stringwithformat:@"https://starcardsindia.com/api/otpverification"]; // nsurl *url=[nsurl urlwithstring:poststr]; nsurl *url=[nsurl urlwithstring:starcardstr]; nsmutableurlrequest *request=[[nsmutableurlrequest alloc]init]; [request seturl:[nsurl urlwithstring:starcardstr]]; [request sethttpmethod:@"post"]; nsstring *contenttype = [nsstring stringwithformat:@"text/xml"]; [request addvalue:contenttype forhttpheaderfield: @"content-type"]; nsmutabledata *pbody=[nsmutabledata data]; [pbody appenddata:[[nsstring stringwithformat:@"<xml>"] datausingencoding:nsutf8stringencoding]]; // create post [pbody appenddata: [[nsstring stringwithformat: @"<?xml version=\"1.0\" encoding=\"utf-8\" ?>"] datausingencoding: nsutf8stringencoding]]; //[pbody appenddata:[...
Read more

How to run C# code using mono without Xamarin in Android? -

-
i want create program uses mono runtime run c# code (binary not application). i copied libmono.so unity app , i'm write code using documentation: http://www.mono-project.com/docs/advanced/embedding/ and it's working have problems references can access classes mscorlib.dll , have problems system.reflection.assembly class throwing exception, when print console see: system.missingmethodexception: method not found: 'system.reflection.assembly.op_inequality' can fix it? can use mono runtime in c binary on android? ps. i'm using android tests. edit: found solution loading libraries, need set environment variable mono_path libraries path. but have still problems assembly class. the system.missingmethodexception error have seems .net profile mismatch error, 1 explained here . can use mono runtime in c binary on android? yes, using ndk guess. there alternatives can use instead of rolling own, such xmadevlab .
Read more

c# - cefsharp app remember password option -

-
i embedding webapp using cefsharp working fine. however, when logging app, cef doesn't offer remember username , password when opening app in normal chrome. is there way in cefsharp cef ask remember usernames/password when uses go app, able sign in quicker ? i have tried using command line args e.g. cefsettings cs = new cefsettings(); cs.cefcommandlineargs.add("enable-automatic-password-saving", "enable-automatic-password-saving"); cs.cefcommandlineargs.add("enable-password-save-in-page-navigation", "enable-password-save-in-page-navigation"); cef.initialize(cs); but far, cef has not prompted me save username/password. cefsharp doesn't support remember password prompt. don't believe cef either, though it's worth asking on http://magpcss.org/ceforum/ definitive answer (there's no reference in api current version). i'll point of unless explicitly told cef use in memory cookie store, session cookies ...
Read more