Re: [sqlite] How to realize the ROWID in a view?

Am 13.06.2006 um 04:14 schrieb PY: Thanks for you reply. I Just want to get a sequence number in a view, that is not the ID field in the table foo. Table foo is a sample of mine. In fact, my table is not only the id and x field. And the x field could be duplicate in the table foo.

Re: [sqlite] How to realize the ROWID in a view?

Thanks for you reply. I Just want to get a sequence number in a view, that is not the ID field in the table foo. Table foo is a sample of mine. In fact, my table is not only the id and x field. And the x field could be duplicate in the table foo. Could you help me to finish that? Thanks.

Re: [sqlite] How to realize the ROWID in a view?

PY uttered: Hi All, I have a problem about the ROWID in a view. I want to simulate a ROWID in a view just like the same purpose in a table. For Example: Create Table foo(id INTEGER PRIMARY KEY AUTOINCREMENT, x TEXT); insert into foo(x) values('X'); insert into foo(x) values('Y'); insert into

Re: [sqlite] How to realize the ROWID in a view?

It's been a while since I did it, but I think I just listed the fields to display and included that field name PY ([EMAIL PROTECTED]) wrote: > > Hi All, > > I have a problem about the ROWID in a view. I want to simulate a ROWID in a > view just like the same purpose in a table. > > For Example: >

[sqlite] How to realize the ROWID in a view?

Hi All, I have a problem about the ROWID in a view. I want to simulate a ROWID in a view just like the same purpose in a table. For Example: Create Table foo(id INTEGER PRIMARY KEY AUTOINCREMENT, x TEXT); insert into foo(x) values('X'); insert into foo(x) values('Y'); insert into foo(x)