Dennis,
Thanks for the info/link.....if we must go this route
(http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor), we will, but I'd
much rather pay someone to write a simple embedded "sequence" function for
us because we've got almost 10 (very complex) queries in mySQL that use the
example in my earlier post (see below). We want to maintain the queries as
close as possible to each other because the user needs to see the same
results and not know the difference between running the query on the server
or the (sqlite) client.
Is it possible to find someone for hire to implement a "sequence" function
so I don't have to rework all this query logic and distract my C++
programmer with the example implementation that you've provided??
Thanks again for responding!!
Dewey
We would replace "@a:[EMAIL PROTECTED]" in the query below with "f_sequence()"
to
generate a new relative rownum for each record found. Or more correctly,
since the "Order by" execution phase of sqlite may not match mySQL, perhaps
the function would best go in the outer query.....in either case, is someone
willing to build this for us:
Query:
Set @a = 0;
Select T1.rownumber, T1.Col2 from
(
Select @a:[EMAIL PROTECTED] as rownumber, Col1, Col2
from Table where Col1 = 'abc' Order by Col1
) as T1
Where T1.rownumber between 21 and 30;
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.10/1367 - Release Date: 4/9/2008
7:10 AM
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
