Hi Darren,
If that works, then try using a subquery in the view definition
instead.
create view Enumerated
as
select rowid as Sequence, Name from (
select Name from Planets order by Name
)
Sort of like that.
Thanks for the suggestion, but, unless I'm missing something, it
doesn't
At 1:08 AM +1000 8/26/07, T wrote:
When I create a view, is there any way to enumerate the output rows?
Another method would I've developed/discovered is to create a
temporary table, fill it with the data from the view, then use the
automatically created rowid column as the enumeration. This
Hi All,
Again following up:
When I create a table, SQLite enumerates the rows in the rowid column.
When I create a view, is there any way to enumerate the output rows?
Another method would I've developed/discovered is to create a
temporary table, fill it with the data from the view, then
When I create a table, SQLite enumerates the rows in the rowid column.
When I create a view, is there any way to enumerate the output rows?
For example, say I have a table:
create table Planets( Name text collate nocase );
insert into Planets values( 'Mercury' );
insert into Planets values(
Hi all,
When I create a table, SQLite enumerates the rows in the rowid column.
When I create a view, is there any way to enumerate the output rows?
For example, say I have a table:
create table Planets( Name text collate nocase );
insert into Planets values( 'Mercury' );
insert into Planets
5 matches
Mail list logo
