Zeoslib Portal

create a table named T1 with 2 row (Nom, Prenom) as text
create data like
Nom1,Prenom1
Nom2,Prenom2
Nom2,Prenom3
Nom4,Alphonse,
...

try

select count(*) from T1 where Prenom like "A%";

then clic back to the "data tab" and you will see that all yours data were lost and you will see something like ;
Nom4,Alphonse
Nom4,Alphonse
Nom4,Alphonse
Nom4,Alphonse
Nom4,Alphonse,
....

good luke to debug.
am using sqlite administrator 0.8.2.9 in french language.

seems to be a bug on the zeoslib with tables without primary key field.

for workaround, add an autoincrement pk field to the table, close db and reopen it.

Orbmu2k wrote:seems to be a bug on the zeoslib with tables without primary key field.

for workaround, add an autoincrement pk field to the table, close db and reopen it.

that's right, if i add a primary key all is working properly.

thank for your answer.
you have done a great job regarding sqlite administrator.
and because it's the "epoch", i wish you an happy new year