Can't append records to SQLite3-DB's
Posted: 20.10.2009, 10:20
Hello
I want to add several records to 2 SQLite3-DB's which are empty on startup. I use TZTable to connect to the tables.
Here is the monitor log :
My Connection is in AutoCommit-Mode, no CachedUpdates on the Table. i add 26 records to both tables, but at the end, the tables are empty.
When I use a Connection.StartTransation before adding the records an a Connection.Commit afterwards I get the following. First the same log than before... and at the end the error :
2009-10-20 10:49:17 cat: Execute, proto: sqlite-3, msg: COMMIT TRANSACTION, errcode: 5, error: database is locked
But there is no other Process running which has this DB opened.
Someone has an idea?
I want to add several records to 2 SQLite3-DB's which are empty on startup. I use TZTable to connect to the tables.
Here is the monitor log :
Code: Select all
2009-10-20 10:49:17 cat: Execute, proto: sqlite-3, msg: INSERT INTO PhysPersons (ID,matricule,nom,prenom,adresse,pays,cp,ville,nationalite,sexe) VALUES (NULL,'19709999000','XYZ Abcdef',NULL,NULL,'D',NULL,NULL,'D',0)
2009-10-20 10:49:17 cat: Execute, proto: sqlite-3, msg: SELECT LAST_INSERT_ROWID()
2009-10-20 10:49:17 cat: Execute, proto: sqlite-3, msg: INSERT INTO Salaries (ID,firme,salarie,salaire,h_travail,h_base) VALUES (NULL,9,1,1.38502612880718,40,2)
2009-10-20 10:49:17 cat: Execute, proto: sqlite-3, msg: SELECT LAST_INSERT_ROWID()
.
.
.
.
.
When I use a Connection.StartTransation before adding the records an a Connection.Commit afterwards I get the following. First the same log than before... and at the end the error :
2009-10-20 10:49:17 cat: Execute, proto: sqlite-3, msg: COMMIT TRANSACTION, errcode: 5, error: database is locked
But there is no other Process running which has this DB opened.
Someone has an idea?