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 Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -------------- Original message ---------------------- From: Farzana <[EMAIL PROTECTED]> > > 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 slower. Is there any other > way to do this or can some one provide us a sample code for the same. > We are using a Table say Employees where we have to dsiplay their Job > Description in ascending order in a user defined listbox with scroll up and > scroll down buttons. Can anyone provide us a suggestion. > Thanks in Advance. > > Regards, > Farzana > > > > Igor Tandetnik wrote: > > > > "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 sqlite3_step. > >> But we were able to populate and move the listbox in the downward > >> direction only > > > > http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor > > > > Igor Tandetnik > > > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > View this message in context: > http://www.nabble.com/Populating-and-scrolling-the-Listbox-using-query-tp1667617 > 8p16806114.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
