Re: [sqlite] sequential row numbers from query

On 3 May 2013, at 2:22am, James K. Lowden wrote: > I considered writing such a function, too. I didn't because relations > have no order. > > One might be tempted to say that's solved by ORDER BY. But > > 1. It's not clear that the rows are presented to the UDF

Re: [sqlite] sequential row numbers from query

Hi, all. How about this approach? I just implemented a simple code(User Defined Function) that returns a number as like as row number. It was worked pretty good with my simple SQL test cases. sqlite> insert into test values ('first record'); sqlite> insert into test values ('second record');

Re: [sqlite] sequential row numbers from query

Hi Hitesh, Here all the VB6 code to do with this. Ignore all the Debug stuff and also all the RaiseEvent lines. Note that this uses the free VB SQLite wrapper from Olaf Schmidt and if you don't use that then that is very much recommended. Let me know if you want that and I will explain. Also

Re: [sqlite] sequential row numbers from query

Hi Hitesh, Attached all the VB6 code to do with this. Ignore all the Debug stuff and also all the RaiseEvent lines. Note that this uses the free VB SQLite wrapper from Olaf Schmidt and if you don't use that then that is very much recommended. Let me know if you want that and I will explain. Also

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

Have a look at this thread in the archive: find sequential groups It can be done with SQL, but it is slow and it can be done enormously faster in code. I did this in VB6 and let me know if you are interested and I mail you the code off-list. RBS On Sat, Apr 27, 2013 at 8:10 AM, hiteshambaliya

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

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

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

Re: [sqlite] sequential row numbers from query

memory when used. Eli Adler -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Robert Citek Sent: Saturday, March 28, 2009 12:03 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] sequential row numbers from query

Re: [sqlite] sequential row numbers from query

That would work. In fact, my current solution, which actually pipes to perl, works pretty well. It's just that I have to then import the data back into the database. So, I'd prefer to do the process entirely in SQL. I was thinking maybe a view, but that didn't work. Apparently, there is no

Re: [sqlite] sequential row numbers from query

On Fri, 27 Mar 2009 16:37:37 -0400, Thomas Briggs wrote: > > Holy cow that feels inefficient. Yes, it certainly is. > It's a bit clunky, but why not insert into a temporary table, >ordered as desired, and then use the rowid from the temp table? Yes, or solve it in the host