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 normal TABLE. On 9/3/07, T&B <[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. > > 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] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
