Re: [sqlite] How to get the RecNo ???

2013-02-11 Thread BareFeetWare
select rowid, * from TestTable Tom Tom Brodhurst-Hill BareFeetWare -- iPhone/iPad/iPod and Mac software development, specialising in databases develo...@barefeetware.com -- Follow us on Twitter: http://twitter.com/barefeetware/ Like us on Facebook: http://www.facebook.com/BareFeetWare On

Re: [sqlite] How to get the RecNo ???

2013-02-11 Thread Simon Slavin
On 11 Feb 2013, at 3:01pm, Clemens Ladisch wrote: > Igor Tandetnik wrote: >> INTEGER PRIMARY KEY simply introduces a named alias for ROWID; its >> presence doesn't make anything possible that wasn't already possible >> without it. > > If the ROWID isn't 'officially' made

Re: [sqlite] How to get the RecNo ???

2013-02-11 Thread Clemens Ladisch
Igor Tandetnik wrote: > INTEGER PRIMARY KEY simply introduces a named alias for ROWID; its > presence doesn't make anything possible that wasn't already possible > without it. If the ROWID isn't 'officially' made part of the table's columns by declaring some INTEGER PRIMARY KEY, then it can be

Re: [sqlite] How to get the RecNo ???

2013-02-11 Thread Igor Tandetnik
On 2/10/2013 11:55 PM, Mohit Sindhwani wrote: I just meant to say that ROWID is not a sequence number of insertion in the case when an INTEGER PRIMARY KEY is used - it comes across as a sequence number when we don't have an integer primary key. I'm pretty sure (but too lazy to check) that you

Re: [sqlite] How to get the RecNo ???

2013-02-11 Thread Igor Tandetnik
On 2/11/2013 6:51 AM, Simon Slavin wrote: On 11 Feb 2013, at 3:45am, Igor Tandetnik wrote: On 2/10/2013 10:06 PM, Mohit Sindhwani wrote: * You decide then to do a sort by ROWID ASC - expecting that ROWID is maintaining the sequence since when you do a general SELECT *

Re: [sqlite] How to get the RecNo ???

2013-02-10 Thread Mohit Sindhwani
Hi Igor, Keith, I think my explanation wasn't very clear. I just meant to say that ROWID is not a sequence number of insertion in the case when an INTEGER PRIMARY KEY is used - it comes across as a sequence number when we don't have an integer primary key. Rest of the answers less relevant

Re: [sqlite] How to get the RecNo ???

2013-02-10 Thread Keith Medcalf
> I have been caught out by this - I read what the documentation says but > just did not carefully understand it. What the above means is this: > * You do an insert in the sequence as above, you say that I should not > sort by id ASC because you want it in insertion order > * You decide then to

Re: [sqlite] How to get the RecNo ???

2013-02-10 Thread Mohit Sindhwani
Hi Peter, I have been caught out on this. On 11/2/2013 8:40 AM, Peter Aronson wrote: You can add it to the select list as OID, ROWID or _ROWID_ or, if the table has a column defined INTEGER PRIMARY KEY (but not INTEGER PRIMARY KEY DESC) it'll also be this value. See:

Re: [sqlite] How to get the RecNo ???

2013-02-10 Thread Peter Aronson
You can add it to the select list as OID, ROWID or _ROWID_ or, if the table has a column defined INTEGER PRIMARY KEY (but not INTEGER PRIMARY KEY DESC) it'll also be this value. See: http://www.sqlite.org/lang_createtable.html#rowid Peter On 2/10/2013 5:23 PM, roystonja...@comcast.net wrote:

[sqlite] How to get the RecNo ???

2013-02-10 Thread roystonjames
After you do a retrieve from the database, how would to access the RecNo for each record? I can get to all the fields but I don't know how to access the record number that sqlite creates when it creates your record. I am not looking for the last record number created. I will be populating a