On 10/24/06, Da Martian [EMAIL PROTECTED] wrote:
For exmaple, Lets say I run a SQL statement (its a very heavy statement
consiting of joins and subqueries). It returns 5000 rows. For speed I dont
want to retrieve 5000 rows, I want to setup a list which shows that there
are 5000 rows on the
Hi
Thanks for your resposne.
In the end its not important as you point out as many options are available,
I guess I allowed myself to indulge in idealic fantasy for a moment :-)
S
On 10/24/06, Dennis Cote [EMAIL PROTECTED] wrote:
Da Martian wrote:
Hi
I understand the problem in thoery
Hi
The optimal way is that you prepare the statement, fetch and
count the results with sqlite3_step.
How would I fetch and count the results via sqlite3_step?
Do you mean fetch all the records first? What if my result set is huge, and
I would only like to show the first few records but
Da Martian [EMAIL PROTECTED] wrote:
Hi
The optimal way is that you prepare the statement, fetch and
count the results with sqlite3_step.
How would I fetch and count the results via sqlite3_step?
Do you mean fetch all the records first? What if my result set is huge, and
I would only
Hi
I understand the problem in thoery and you are saying that sqlite is using
an iterative algorithm which returns data as it finds it, is this correct?
It appears that DBs like oracle etc.. get the whole resultset into temporary
memory/space and then return the query (at least for unions this
Da Martian wrote:
Hi
I understand the problem in thoery and you are saying that sqlite is
using
an iterative algorithm which returns data as it finds it, is this
correct?
It appears that DBs like oracle etc.. get the whole resultset into
temporary
memory/space and then return the query
Hi List,
If I use sqlite3_exec to query a database,
How can I know that the results in the data base got over. For example If
I am expecting a 10 results in some for loop and actually there are only
five results , How can I get a notification or return value that the
results completed or Is
I think you are asking for this... This is the case when we use
wxSQLite3.
wxSQLite3ResultSet result = samp.ExecuteQuery(wxT(select name,age from
test));
while (result.NextRow())
{
cout (const char*)(result.GetString(0).mb_str()) result.GetInt
(1) endl;
}
On Fri, 2006-10-06 at 17:07
Hi List,
If I use sqlite3_exec to query a database,
How can I know that the results in the data base got over. For example If
I am expecting a 10 results in some for loop and actually there are only
five results , How can I get a notification or return value that the
results completed or Is