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

[Lewis Balentine]

I have over three decades of dealing with SQL and I can still not 
understand how this myth got propagated.

There is NO valid SQL reason why a table should be required to have a 
unique primary key or any predefined key for that matter. One can always 
use the row number (record number) if such a key is required for one's 
application.


On 03/28/2015 12:31 PM, gambas at ...2524... wrote:
> Updates:
> 	Status: Accepted
>
> Comment #4 on issue 612 by benoit.m... at ...626...: BUG Cannot browse more of
> 128 records on tables "No current connection"
> https://code.google.com/p/gambas/issues/detail?id=612
>
> The reason why DataBrowser or DataView fails is because your table does not
> have a unique primary key. This is mandatory, otherwise DataBrowser or
> DataView can't work correctly.
>
> I will modify them in the future so that they raise an explicit error if no
> unique primary key is found.
>