Frank 177 Posted August 12, 2015 Report Share Posted August 12, 2015 Thanks Nick. Very interesting!! I'm going to investigate this alternative too. But when using the paid plugin, question for you, I know how to do an insert into a table, but what's the most effective way to get back the result with a row number right after the entry, from your experience. Frank Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted August 13, 2015 Author Report Share Posted August 13, 2015 This is proll;y the best 4 down vote accepted The SQL statement SELECT max(id) FROM table_name should give you the maximum id. If you're auto-incrementing then this would be the same as the last inserted. source http://stackoverflow.com/questions/13177324/cant-get-the-last-row-id-from-sqlite3-database here is a couple resources for python SQLite Python tutorial really gooood▶ Python 2.7 Tutorial Pt 12 SQLite - YouTube Hope that helps.CD Quote Link to post Share on other sites
Frank 177 Posted August 16, 2015 Report Share Posted August 16, 2015 Hey Nick, awesome. I've been looking into the Python method too. I'll be trying the max function for sure. Quote Link to post Share on other sites
steelersfan 38 Posted October 23, 2016 Report Share Posted October 23, 2016 Any chance on an update for this? The needed plugins from Aymen (file management and string management) are no longer available, so I can't run this to learn. Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted October 24, 2016 Author Report Share Posted October 24, 2016 I intend to make a python one too so you wont need the sqlite plugin either. 1 Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.