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 same second), on different
machines
sqlite 3 birth.sqlite
someone (name s):
insert into people values('s','2')
me :
select * from people; got only 's','2'
someone else (name t)
insert into people values('t','3')
someone else (name u)
insert into people values('u','4')
me :
select * from people; got 't', '3' AND 'u', '4', but 's','2' was not there
________________________________
De : Simon Slavin <[email protected]>
À : General Discussion of SQLite Database <[email protected]>
Envoyé le : Dimanche 22 septembre 2013 17h52
Objet : Re: [sqlite] multiple connection to the same DB
On 22 Sep 2013, at 4:50pm, Gerry Snyder <[email protected]> wrote:
> If I am right, then something else is happening, such as somehow using
> different files, or something else deleting or otherwise modifying the file
> between accesses.
Worth testing. Have one user create an entry in the table then quit their
program. Then have the other user open the file, do a SELECT on the table and
see whether the entry is there.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
