>> 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 application makes a series of sqlite3_step calls, one for each row. Can't >it just increment a counter on each step? >> 2. The application is written in C/CPP so no counters or variables from >> C/CPP can be used. >I don't see how the second statement follows from the first. In fact, it >appears that just the opposite should be the case. 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 have to be in the C/CPP application which would nullify the use of customizable HTML template. Have a dynamite day. Michael Henshaw AdCom Technologies Inc. 1119 Superior Ave. Sheboygan, WI 53081 (920) 694-0039 http://www.adcomtechnologies.com/ -----Original Message----- From: sqlite-users-boun...@sqlite.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 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 application makes a series of sqlite3_step calls, one for each row. Can't it just increment a counter on each step? > 2. The application is written in C/CPP so no counters or variables from C/CPP > can be used. I don't see how the second statement follows from the first. In fact, it appears that just the opposite should be the case. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users