Version 1.44 checked in. I also added a setDatabaseFile(char *) and getDatabaseFile() just now complete the file name set. cluster = new Cluster(); cluster->setDatabaseFile("cluster.db"); cluster->dbDelete(); cluster->setHistoFile("histo.csv"); cluster->setHistoSortedFile("histosorted.csv"); cluster->Init(); // loads database and histo file
Michael D. Black Senior Scientist Northrop Grumman Mission Systems ________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Sam Carleton Sent: Sat 7/10/2010 4:16 PM To: General Discussion of SQLite Database Subject: EXTERNAL:[sqlite] why is this table locked? I am on Window 7, opening an existing database with these flags: SQLITE_OPEN_EXCLUSIVE | SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE Then I get a value from one table, begin a transaction, create a temp customer table, fill it with the current values from the customer table. Here is that SQL run by calling sqlite3_exec(): SELECT ItemValue FROM DBLookup WHERE Category = 'SystemSettings' AND ItemName = 'Version'; BEGIN TRANSACTION; CREATE TABLE CustomerTemp ( CustomerId INTEGER NOT NULL, CustomerDetailId INTEGER, IsInSlideShow INTEGER NOT NULL, Username VARCHAR(50) NOT NULL, Password VARCHAR(50), IsDeleted INTEGER NOT NULL DE FAULT 0, CopiedTo INTEGER, insertedby VARCHAR(50) NOT NULL, instertedon TIMESTAMP NOT NULL, updatedby VARCHAR(50) NOT NULL, updatedon TIMESTAMP NOT NULL, PRIMARY KEY (CustomerId), UNIQUE (username)); INSERT INTO CustomerTemp (CustomerId, IsInSlideShow, Username, Password, insertedby, instertedon, updatedby, updatedon) SELECT CustomerId, IsInSlideShow, Username, Password, insertedby, instertedon, updatedby, updatedon FROM Customer ORDER BY CustomerId; This all works fine. Then I go to drop the current customer table and I always get a "database table is locked": DROP TABLE Customer; I tried committing the transaction before the drop and that doesn't have any impact. I also have foreign keys turned off, I tried turning them off but that also has no impact. Low and behold, when I go into SQLite Manager (the Firebird plugin), I am able to drop the table without any problems. Any thoughts on the table is locked and how to unlock it? I know for a fact no other process has it open. Sam _______________________________________________ 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