[sqlite] Fetching records from Temp table

for fetching the records from both the table. Kindly clarify us in this regard. Thanks in advance. Regards, Farzana. -- View this message in context: http://www.nabble.com/Fetching-records-from-Temp-table-tp17399000p17399000.html Sent from the SQLite mailing list archive at Nabble.com

Re: [sqlite] nVARCHAR as unique index

The query we used is "SELECT * FROM Brand ORDER BY BrandDescription". The Brand table contains more than 30,000 records. The execution time is reasonable when we execute in the system.But it is slower when we execute the same in the device. Regards, Farzana. Igor Tande

Re: [sqlite] nVARCHAR as unique index

ORDER BY BrandDescription" in the query to be executed, its taking more time than we expected. Is there any work around to sort the data by BrandDescription physically? Thanks in advance. Regards, Farzana. Igor Tandetnik wrote: > > "Farzana" <[EMAIL PROTECTED]> > wrote in message new

[sqlite] nVARCHAR as unique index

nVARCHAR as unique index? Kindly help in this regard. Regards, Farzana. -- View this message in context: http://www.nabble.com/nVARCHAR-as-unique-index-tp17206197p17206197.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users

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

in this regard. Regards, Farzana. epankoke wrote: > > 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 a

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

. 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

[sqlite] sqlite3_prepare performance

the parameters to the function as sqlite3_prepare(db,query,-1,,NULL); Are we missing out something so that the execution of this step gets slower or How can we improve the performance? Kindly help in this regard. Thanks in advance. Regards, Farzana. -- View this message in context: http

[sqlite] Populating and scrolling the Listbox using query

, sqlite3BtreeNext where we are suppose to use cursors. Is it possible to execute the query using cursors and move the pointer in the upward or downward direction? Kindly help in this regard. Thanks in advance. Regards, Farzana. -- View this message in context: http://www.nabble.com/Populating