Re: [sqlite] why a VIEW doesn't contain a ROWID

On Mon, 03 Sep 2007 18:05:05 -0300, you wrote: >Hi Kees, > >He is telling about the Rowid the unique number that represents each row >in the table, not about a table column named "ID" or anything else, or >the primary key of the table. > >[]'s, > >Marco Antonio Abreu >IT Quality Systems >[EMAIL PR

Re: [sqlite] why a VIEW doesn't contain a ROWID

Hi Kees, He is telling about the Rowid the unique number that represents each row in the table, not about a table column named "ID" or anything else, or the primary key of the table. []'s, Marco Antonio Abreu IT Quality Systems [EMAIL PROTECTED] http://www.itquality.com.br Kees Nuyt wrote: >

Re: [sqlite] why a VIEW doesn't contain a ROWID

Hi Lokesh, On Mon, 3 Sep 2007 15:30:10 +0530, you wrote: > This I know, but the thing is, I want the ROWID > in VIEW to be sequential even after a SELECT with > some condition has been executed, ie., from 1 to n. > Just like in normal table. > In your case it is not like that. If you delete r

Re: [sqlite] why a VIEW doesn't contain a ROWID

On 9/2/07, Babu, Lokesh <[EMAIL PROTECTED]> wrote: > Why a VIEW doesn't contain a ROWID field. Even though if it is > accessed, it contains (null) value. How to initialise this or how to > make it work as in TABLE. The rowid field exposes SQLite's internal storage mechanism for table rows. It ha

Re: [sqlite] why a VIEW doesn't contain a ROWID

This I know, but the thing is, I want the ROWID in VIEW to be sequential even after a SELECT with some condition has been executed, ie., from 1 to n. Just like in normal table. In your case it is not like that. Ah, OK, I asked a similar question a week or two ago, and had to come up with my ow

Re: [sqlite] why a VIEW doesn't contain a ROWID

This I know, but the thing is, I want the ROWID in VIEW to be sequential even after a SELECT with some condition has been executed, ie., from 1 to n. Just like in normal table. In your case it is not like that. By the way, what I mean to say is, why don't we have default ROWID in VIEW like as in n

Re: [sqlite] why a VIEW doesn't contain a ROWID

Why a VIEW doesn't contain a ROWID field. Even though if it is accessed, it contains (null) value. How to initialise this or how to make it work as in TABLE. To have your view include a rowid, you can include it in the select. For instance, if you have a simple table: create table People

[sqlite] why a VIEW doesn't contain a ROWID

Dear all, Why a VIEW doesn't contain a ROWID field. Even though if it is accessed, it contains (null) value. How to initialise this or how to make it work as in TABLE. - To unsubscribe, send email to [EMAIL PROTECTED] ---