No DB product can give you the number of rows in a result set until the
search has been completed. The Sqlite callback and step approach gives
the application the ability to process the query result as the query
finds each row, avoiding the need for intermediate storage, a most
efficient and
Edward Wilson wrote:
What I was trying to say was: with other db products the drivers (or something
somewhere)
calculated the number of rows returned in a query automagicly. I have never
had to do anything
'extra' to get the number of rows in a query other than
resultset-object.rowcout -
Edward Wilson wrote:
What I was trying to say was: with other db products the drivers (or something
somewhere)
calculated the number of rows returned in a query automagicly. I have never
had to do anything
'extra' to get the number of rows in a query other than
resultset-object.rowcout -
What I was trying to say was: with other db products the drivers (or something
somewhere)
calculated the number of rows returned in a query automagicly. I have never
had to do anything
'extra' to get the number of rows in a query other than
resultset-object.rowcout - 'rowcout' being
whatever
On Oct 31, 2005, at 7:54 PM, Edward Wilson wrote:
I simply count the number of elements in my record set
thereby avoiding a double query to the database.
Yes, exactly, I take for granted that the resultset is accumulated at
the database level and not
at the application level.
sorry, I
>I simply count the number of elements in my record set
>thereby avoiding a double query to the database.
Yes, exactly, I take for granted that the resultset is accumulated at the
database level and not
at the application level.
-
ed
--- Puneet Kishor <[EMAIL PROTECTED]> wrote:
>
> On Oct
I had this same problem some time ago. We were trying to make a virtual list
box that could handle ANY number of items. The scroll bar is the wrinkle. You
can't set it or size it without knowing the size of the list.
My conclusion was this:
A list of more than 100 or so items on screen is really
On Oct 28, 2005, at 7:20 PM, SRS wrote:
Edward Wilson wrote:
The idea of issuing two selects is, well, a hack, and knowing how
many records one has in a
result-set is a powerful feature
Are you needing a progress bar for the search (ie the query?) Or some
action based on the result set?
Edward Wilson wrote:
The idea of issuing two selects is, well, a hack, and knowing how many records
one has in a
result-set is a powerful feature
Are you needing a progress bar for the search (ie the query?) Or some
action based on the result set? If the later, get the result set as
Sqlite-Kernel-Hackers:
This is really an important feature to have, I am surprised it's not already
there. I too have
had the same question but have just never asked.
btw, is this by any chance on the feature road-map?
The idea of issuing two selects is, well, a hack, and knowing how many
-
From: vidushi tandon [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 1:09 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Re: Number of rows in a query result
hi all
can anyone tell me how to port sqlite
databases to the handheld devices
rgds
vidushi tandon
--- Dennis
Puneet Kishor wrote:
Igor Tandetnik wrote:
Alfredo Cole <[EMAIL PROTECTED]> wrote:
In order to update a progress bar, I need to know the total number of
rows returned by a query, similar to MySQL's mysql_num_rows. Is there
a function like that in the C API? I may have overlooked it, but
Igor Tandetnik wrote:
Alfredo Cole <[EMAIL PROTECTED]> wrote:
In order to update a progress bar, I need to know the total number of
rows returned by a query, similar to MySQL's mysql_num_rows. Is there
a function like that in the C API? I may have overlooked it, but have
not found it so far.
Alfredo Cole <[EMAIL PROTECTED]> wrote:
In order to update a progress bar, I need to know the total number of
rows returned by a query, similar to MySQL's mysql_num_rows. Is there
a function like that in the C API? I may have overlooked it, but have
not found it so far.
There is no such
14 matches
Mail list logo
