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

c# - SharpSsh Command Execution -

-
Image
i trying create ssh client using c#. using tamir.sharpssh library. having issues sending command , getting appropriate response server. the way have been testing sending on ls command, followed cd.. command, followed ls command again -- see whether or not cd.. command being executed properly. however, there no difference between first ls command , second ls command. not entirely sure doing wrong. perhaps using wrong ssh type. have provided code , output getting. have added output expect. using tamir.sharpssh; namespace sshnetexample { class program { static void main(string[] args) { sshexec ssh = null; try { console.write("-connecting..."); ssh = new sshexec(host, username, password); ssh.connect(); console.writeline("ok ({0}/{1})", ssh.cipher, ssh.mac); console.writeline("server version={0}, client versio
Read more

python - Specify path of savefig with pylab or matplotlib -

-
i struggling on how find correct way specify save path (or repository) when calling function savefig in matplotlib or pylab. i tried several syntaxes, everytime python console returns : filenotfounderror: [errno 2] no such file or directory: '../mydocs/resource/frames/myimage.png' currently, have written following : pylab.savefig('../mydocs/resource/frames/myimage.png') does know how it? thanks in advance! the tilde operator , variable $home entered strings , therefore not function while saving. have provide either relative path (as did) or provide full path. eg. pylab.savefig("/home/username/desktop/myfig.png") .
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