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: [email protected] 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. ***********************************************************************************
