Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-21 Thread Eric Pankoke
lf Of Neville Franks Sent: Tuesday, April 22, 2008 1:08 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Populating and scrolling the Listbox using query Tuesday, April 22, 2008, 2:52:37 PM, you wrote: Why not just keep the rowid's in an array and query the actual row contents

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-21 Thread Neville Franks
Tuesday, April 22, 2008, 2:52:37 PM, you wrote: Why not just keep the rowid's in an array and query the actual row contents as needed. This is typical with virtual list or tree controls. That is you keep a reference to the data, not the data itself. F> Thanks for the quick reply Epankoke. F> We

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-21 Thread Farzana
Thanks for the quick reply Epankoke. We tried as you mentioned. But we are restricted with the memory size and the storage of the needed data occupies some MB's of space in the memory so we cannot go for it. Is there any other work around to perform the scrolling condition. Kindly help in this re

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-21 Thread epankoke
Is it possible to store all of the needed data in memory? If so, why not read the required information into an array and just update an index variable to keep track of where you are at in the array when the user clicks the up and down buttons? That should be quite fast. -- Eric Pankoke Founde

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-21 Thread Farzana
Thanks for your reply Igor. We tried populating the listbox as mentioned in the URL.We are successful in populating the listbox but when we go for scrolling the data, it takes more time to move forward and backward since it has to execute the query everytime. We are using a PocketPc so it is much

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-14 Thread Clay Dowling
Farzana wrote: > Dear All, > > We are working in eVC++ environment with SQLite database.We need to populate > the listbox with the values obtained by executing the query. > We were able to get the values of the query by using the API’s > sqlite3_prepare and sqlite3_step. > But we were able to popu

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-14 Thread Fred Williams
on. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Igor Tandetnik Sent: Monday, April 14, 2008 6:36 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Populating and scrolling the Listbox using query "Farzana" <[EMAIL PROTECTED]&g

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-14 Thread Igor Tandetnik
"Farzana" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > We are working in eVC++ environment with SQLite database.We need to > populate the listbox with the values obtained by executing the query. > We were able to get the values of the query by using the API's > sqlite3_prepare and

[sqlite] Populating and scrolling the Listbox using query

2008-04-14 Thread Farzana
Dear All, We are working in eVC++ environment with SQLite database.We need to populate the listbox with the values obtained by executing the query. We were able to get the values of the query by using the API’s sqlite3_prepare and sqlite3_step. But we were able to populate and move the listbox in