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.
bug 0.8.2.9 version
Moderators: gto, EgonHugeist, Orbmu2k
that's right, if i add a primary key all is working properly.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.
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