"Sreedhar.a" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Say,I am having 4 entries in the table ALBUM.
>
> "CREATE TABLE ALBUM (AlbumtId INTEGER PRIMARY KEY NOT NULL,Album TEXT NOT
> NULL COLLATE NOCASE DEFAULT 'Unknown',UNIQUE(Album));"
>
> Now I want to list the first 100 Album from ALBUM table.
Prob shd be http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
On 18/12/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "Sreedhar.a" <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Say,I am having 4 entries in the table ALBUM.
> >
> > "CREATE TABLE ALBUM (AlbumtId INTEGER PRIMARY KEY NOT NU
nt: Tuesday, December 18, 2007 4:18:52 AM
Subject: Re: [sqlite]:Using sqlite3_progress_handler for GUI application
"Sreedhar.a" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Say,I am having 4 entries in the table ALBUM.
>
> "CREATE TABLE ALBUM (AlbumtId INTEGER PRIMAR
If you store the last key and have an index on that key you will get
each 100 at the same speed by getting the first 100 greater than your
highest last key.
Sreedhar.a wrote:
Hi,
Say,I am having 4 entries in the table ALBUM.
"CREATE TABLE ALBUM (AlbumtId INTEGER PRIMARY KEY NOT NULL,
On Tue, Dec 18, 2007 at 12:24:25PM +, Simon Davies wrote:
> Prob shd be http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
One question - using the example mentioned there:
If we've created an index: CREATE INDEX example1 ON tracks(singer, title);
So, it'll make the query, like below, muc
Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Tue, Dec 18, 2007 at 12:24:25PM +, Simon Davies wrote:
>
> > Prob shd be http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
>
> One question - using the example mentioned there:
>
> If we've created an index: CREATE INDEX example1 ON track
Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Tue, Dec 18, 2007 at 02:10:02PM -0600, John Stanton wrote:
>
> > It won't be ignored. If you have an index ordered in the sequence
> > specified by the ORDER BY Sqlite will use that order instead of having
> > to assemble the result set and sor
Hi,
Thankyou very much for the suggestions.
Best Regards,
A.Sreedhar.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 12:41 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]:Using sqlite3_progress_handler for GUI application
8 matches
Mail list logo