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 in ORDER BY
> order. Ther
On Fri, 3 May 2013 07:45:25 +0900
Yongil Jang wrote:
> I just implemented a simple code(User Defined Function) that returns a
> number as like as row number.
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 ORDE
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');
sql
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 note
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
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.
__
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
w
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:
http://sqlite.1065341.n5.nabble.com/sequential-row-numbers-fro
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
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 help
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
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 row
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 language, which
Holy cow that feels inefficient.
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?
On Fri, Mar 27, 2009 at 3:48 PM, Kees Nuyt wrote:
> On Fri, 27 Mar 2009 12:52:23 -0500, Robert Citek
> wrote:
>
>>How can I get a
On Fri, 27 Mar 2009 12:52:23 -0500, Robert Citek
wrote:
>How can I get a query to display sequential row number in a select statement?
>
>I have a simple database similar to this:
>
>$ sqlite3 db .dump
>BEGIN TRANSACTION;
>CREATE TABLE foo (field);
>INSERT INTO "foo" VALUES('a');
>INSERT INTO "fo
15 matches
Mail list logo