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

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 as needed

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 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

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: [sqlite] Populating and scrolling the Listbox using query

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

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

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

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

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

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

-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]> wrote i

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

"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

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