Re: [sqlite] Incremental row number associated to the current Query?

On Mon, 9 Aug 2010 17:53:02 -0500, Mike Henshaw wrote: >>> Is there a way to create an incremental row or show a row number that is >>> linked to the current select query that can be used in >>> calculations? >> >>> Basically a row counter for the current query

Re: [sqlite] Incremental row number associated to the current Query?

Mike Henshaw wrote: > 1. The application is from a third party with no access to the source code > but the SQL query can be updated since the SQL query > is used in a custom HTML template which can also be updated. > 2. The calculations to the RowNum would then

Re: [sqlite] Incremental row number associated to the current Query?

e.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Monday, August 09, 2010 5:25 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Incremental row number associated to the current Query? Mike Henshaw <mhens...@adcomtechnologies.com> wrote: > Is there a way t

Re: [sqlite] Incremental row number associated to the current Query?

Mike Henshaw wrote: > Is there a way to create an incremental row or show a row number that is > linked to the current select query that can be used in > calculations? > > Basically a row counter for the current query that can be used in > calculations. Your