That sounds like a feature request to me! Sorry it didn't work. On 1/10/06, Adler, Eliedaat <[EMAIL PROTECTED]> wrote: > Nope - select rowid returns NULL for each row. > > -----Original Message----- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: Monday, January 09, 2006 4:48 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Finding relative position in VIEW > > > > > At present I have a "counting" callback function on "select myid from > > myview" that returns the number of rows encountered before > > myid=this_myid - severely inefficient. > > > > Any other ideas? > > Count the rows with a counter as you fetch them? > > I'm not sure if ROWID works on a view or not... > does this work? > > select rowid, myview.* from myview > *********************************************************************************** > This email message and any attachments thereto are intended only for use by > the addressee(s) named above, and may contain legally privileged and/or > confidential information. If the reader of this message is not the intended > recipient, or the employee or agent responsible to deliver it to the intended > recipient, you are hereby notified that any dissemination, distribution or > copying of this communication is strictly prohibited. If you have received > this communication in error, please immediately notify the [EMAIL PROTECTED] > and destroy the original message. > *********************************************************************************** >
-- --- The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call http://www.lulu.com/content/77264
