Re: [sqlite] sequential row numbers from query

Ya I am interested to know more. My mail ID hitesh.ambal...@gmail.com Thank you so much -- View this message in context: http://sqlite.1065341.n5.nabble.com/sequential-row-numbers-from-query-tp47370p68515.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] sequential row numbers from query

You are absolutely right but, I am using VB 6.0 and i have global general function which fill the data in grid so there is if serial number column in query is easy way so.. Any way to do in query??? -- View this message in context:

Re: [sqlite] sequential row numbers from query

Hi, 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