[sqlite] foreign keys

Hello I tried, (with sqlite3 command line) : create table T(a primary key not null); create table U(a references T not null); insert into U values(4) and it works but i don't want to, because the value 4 is not in T. I've tried PRAGMA foreign_keys first, but it's the same. Can someone give me a

Re: [sqlite] multiple connection to the same DB

The administrator just told me, the server is on debian with CIFS, each machine are on Ubuntu. i try to remember the whole session : me : sqlite3 birth.sqlite create table people ... insert into people  values('o','1') and no closing sqlite all other at the same time (but probably not at the

Re: [sqlite] multiple connection to the same DB

it possible to improve the mechanism If everyone writes an explicit BEGIN IMMEDIATE (or EXCLUSIVE ?) INSERT ... END Thanks for all the answers. De : Simon Slavin À : olivier Ménard ; General Discussion of SQLite Database Envoyé le : Dimanche 22 septembre 2

Re: [sqlite] multiple connection to the same DB

ks. De : Kees Nuyt À : sqlite-users@sqlite.org Envoyé le : Dimanche 22 septembre 2013 10h25 Objet : Re: [sqlite] multiple connection to the same DB On Sun, 22 Sep 2013 08:28:39 +0100 (BST), olivier Ménard wrote: >Hi > >I'll try to give you more details >We were all on Ubunt

Re: [sqlite] multiple connection to the same DB

> select * from people; n       y --   -- 'simon'  1960 and olivier isn't in the DB. Thank's for your help. Olivier. De : Simon Slavin À : olivier Ménard ; General Discussion of SQLite Database Envoyé le : Mard

[sqlite] multiple connection to the same DB

Hi I've tried with my colleagues to write data to the same SQLite DB-file  from differents accounts. When someone added a new line in the DB, sometimes older existing data were lost as if they had never existed and sometimes not. Why ? Multiple access are maybe allowed only for reading ? than