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
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
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
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
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 *
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
> 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
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:
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:
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
10 matches
Mail list logo