android - updating or inserting in a table with keeping the row numbers to one -

-

i trying see if there in table update , if not insert 1 row. have 1 row in table. 

   public void createorupdate(long id,string x, string y, string angle){             string[] columns= new string[]{key_rowid, key_x, key_y, key_angle};             cursor c= ourdatabase.query(database_table, columns, null, null, null, null, null);             contentvalues editcon = new contentvalues();              if (c!=null){                 editcon.put(key_x, x);                 editcon.put(key_y, y);                 editcon.put(key_angle, angle);                 ourdatabase.update(database_table, editcon, key_rowid + "=?", new string[]{string.valueof(id)});             }             else{                 editcon.put(key_x, x);                 editcon.put(key_y, y);                 editcon.put(key_angle, angle);                 ourdatabase.insert(database_table, null, editcon);             }          }          public string getdata() {             // todo auto-generated method stub             string[] columns= new string[]{key_rowid, key_x, key_y, key_angle};             cursor c= ourdatabase.query(database_table, columns, null, null, null, null, null);             string result= "";             int irow= c.getcolumnindex(key_rowid);             int ix= c.getcolumnindex(key_x);             int iy= c.getcolumnindex(key_y);             int iangle= c.getcolumnindex(key_angle);             int i= 0;              for( c.movetofirst(); !c.isafterlast(); c.movetonext()){                 result= result+ c.getstring(irow)+ " "+ c.getstring(ix)+ " " +c.getstring(iy)+ " "+ c.getstring(iangle)+"\n";              }             return result;         }

but when use entry.createorupdate(1, double.tostring(db1), double.tostring(db2), double.tostring(db3)); in code there nothing in table , no exception , nothing. when use update or insert separately works.. problem?

the check c!=null not enough. cursor can not null when result of query empty. means need amount of rows using c.getcount() , check if returns 0 or 1.

ps: for( c.movetofirst(); !c.isafterlast(); c.movetonext()){ pretty ugly use loop. should change while(c.movetonext()).

movetonext() same movetofirst() on fresh created cursor object.


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more