[sqlite] END TRANSACTION failed with "database is locked"

Hi, I am executing some operations in a loop and all the operations are wrapped inside a transaction. During one iteration the "END TRANSACTION" returned with an error "database is locked". Since this is in a loop my next request to "BEGIN TRASACTION" failed with "cannot start a transaction within

[sqlite] How to Optimize query

Hi, I am working with a project which uses SQLite as the database to store collected data. I am issuing the following query to retrieve data from the table. I noticed this query is taking more time as the number of records in the table increases. Is there a better way to write this query? any help

Re: [sqlite] sql problem

i am able to get the result but the problem is it is case sensitive, i want a case insensitive manoj marathayil <[EMAIL PROTECTED]> wrote: i have two tables like this; CREATE TABLE sp_objects ( dbname varchar(256), object_name varchar (256), arglist varchar(256), type integer, prima

[sqlite] sql problem

i have two tables like this; CREATE TABLE sp_objects ( dbname varchar(256), object_name varchar (256), arglist varchar(256), type integer, primary key ( dbname, object_name, arglist ) ); CREATE TABLE sp_objects ( dbname varchar(256), object_name varchar (256), arglist

[sqlite] Problem with opening

hai, is it possible for two threads to open same database file simultabiously and perform an insert stmt?, if not is ther is any way to implement it? Send instant messages to your online friends http://in.messenger.yahoo.com

Re: [sqlite] store result

thanks, i failed to notice that one, any way thanks for your replay Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 1/19/06, manoj marathayil wrote: > ok this i can do, but the problem is i need to select a set of records and i > want to manipulate with each record then only i ne

Re: [sqlite] store result

ok this i can do, but the problem is i need to select a set of records and i want to manipulate with each record then only i need to delete that record Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 1/19/06, manoj marathayil wrote: > > hi, > is there is any way so that i can s

[sqlite] store result

hi, is there is any way so that i can store the result of a select query and execute a delete query on the same table with out using any other buffer? T h a n k s & R e g a r d s , Manoj M | Webyog | Bangalore | Voice: 91 9886171984, 91 80 51216434(off) "A winner is not one who never fails,