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

[T&B]

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
(
        "First Name" text,
        "Last Name" text,
        Email text,
        Age integer
)

Then you can specifically include the rowid in a select statement or  
view, such as this simple view based just on that table:

create view Teenagers
as
select
        rowid,
        "First Name",
        "Last Name"
from
        People
where
        Age >= 13 and Age <= 19
;

Or to include all fields, you could:

create view Everyone
as
select
        rowid,
        *
from
        People
;

In those cases, the rowid in the view would be the same rowid as the  
matching row in the table.

Tom


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------