[Gambas-user] Issue 612 in gambas: BUG Cannot browse more of 128 records on tables "No current connection"

[Benoît Minisini]

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