Le 30/03/2015 00:34, marco bra a écrit : > There must something i cannot understand with this > > I try on the same sqlite3 database > - creating a different new test project > - defining new datasource > - defining a databrowser that use that datasource tables, the tables do not > have any primary key defined.... > i can browse the entire tables contents (56K records), so i cannot see this > issue more. > > Then i suppose isn't a primary key relate issue... > > Fyi: my first test pc was an ubuntu 14.04 in this second test i'm using > ubuntu 15.04 unstable > > So, i'm really confused... i supposing there is some in my code... > > Thank you > Marco >
The DataView browses a table or a request by chunk of multiple of 128 rows, and so needs a unique primary key to be able to read the next chunks. Without a unique primary key, there is no way to emit a SQL request that can return part of a table from a specific row. When there is no primary key, the result is read entirely in one shot. But until recently, there was a bug: a primary key was assumed falsely in some cases with sqlite, and so the DataView was losing some records, hence the red errors while displaying its contents. Regards, -- Benoît Minisini ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
