sqlite3 - lastrowid() alternative or syntax without using execute in sqlite python? -

-

in sqlite3 in python, i'm trying make program new row in table written inserted next, needs printed out. read documentation here insert should used in execute() statement. problem program i'm making asks user his/her information , primary key id assigned member his/her id number must displayed. in other words, execute("insert") statement must not executed first id keys wrong assignment of member.

i first thought lastrowid can run without using execute("insert") noticed gave me value "none". read documentation in sqlite3 in python , googled alternatives solve problem.

i've read through google somewhere select last_insert_rowid() can used alright ask syntax of in python? i've tried coding this

nextid = con.execute("select last_insert_rowid()")

but gave me cursor object output ""

i've been thinking of making table there 1 value. value of lastrowid of main table whenever there new input of data in main table. value gets inserted , overwritten in table every time there new set of data needs input in main table , next row id needed, access table 1 value.

or there alternative , easier way of doing this?

any appreciated bows deeply

you guess next id if query table before asking user his/her information select max(id) + 1 newid desiredtable.

before inserting new data (including new id), start transaction, rollback if insert failes (because process faster same operation) , ask user again. if eveything ok commit.


Comments

Post a Comment

Popular posts from this blog

c# - How to set Z index when using WPF DrawingContext? -

-
how set z-index drawing object when using drawingcontext.drawxxx() methods? the object drawn last have higher z index. can't change index of drawn objects. way draw in order. if using wpf (as placed tag), can use, example, canvas control. create shapes need like polyline obj = new polyline(); //... // ... set properties of obj and add them canvas uielementcollection: yourcanvasname.children.add(obj); //or yourcanvasname.children.insert(i, obj); first items of collection have higher z index. advantages in way: no need redraw on window changes, can anytime move objects , change order.
Read more

razor - Is this a bug in WebMatrix PageData? -

-
i think may have found bug in webmatrix's pagedata, not sure. concerns how pass data partial page calling page. in webmatrix documentation (tutorials, e.g. " 3 - creating consistent look ", , example code), pagedata recommended mechanism pass data between pages (e.g. content page layout page, or partial page). however have found not work other way, pass data partial page calling page. modifying or adding entries in pagedata in partial page, not seem calling page. cutting right down simplest possible example, in test page may have this: @{ pagedata["test"] = "initial entry"; } <p>before calling partial page, test value @pagedata["test"]</p> @renderpage("_testpartial.cshtml") <p>after returning calling page, test value @pagedata["test"]</p> and in _testpartial.cshtml page might have this: @{ pagedata["test"] = "modified entry"; } <p>in partial page...
Read more

android - layout with fragment and framelayout replaced by another fragment and framelayout -

-
edit: so after comments below, revisted , realized hanging me up. imagine client list , client details activity started : public class clientsmainactivity extends fragmentactivity { @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); //studiotabopenhelper db; setcontentview(r.layout.main_client_activity); } } so works great, starts main_client_activity (defined in layout below, , call activity when button on main screen clicked): intent intent = new intent(getactivity(), clientsmainactivity.class); startactivity(intent); easy issue is, clientsmainactivity not call oncreateview or anything, sets layout layout defines fragment, , listfragment. fine cause not trying pass clientsmainactivity , if have hypothetical activity like: sessionmainsactivity called when click on session edit of client, not calling sessionsmainactivity same way (starts activity sets alayout), want layout set defines...
Read more