On 4/26/2013 8:56 AM, hiteshambaliya wrote:
I want to get serial numbers for selected record from 1 to number of rows.
Your solution is right but in the situation when i want to sort by 'Party
Name' column then the serial number depend on autoid field arrange also as
sorted party name so i can't get it as serial records nos.
Please help me that what to do????
While you iterate over the rows with sqlite3_step (or the equivalent in
your language of choice), simply keep incrementing a counter.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
