Updates:
Status: WontFix
Comment #5 on issue 612 by benoit.m...@gmail.com: BUG Cannot browse more of
128 records on tables "No current connection"
https://code.google.com/p/gambas/issues/detail?id=612
(No comment was entered for this change.)
--
You received this message because this
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
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 conten
I over reacted to begin with.
Thus I will not continue to further beat this dead horse. :-)
Lewis
On 03/28/2015 02:27 PM, Benoît Minisini wrote:
> Le 28/03/2015 20:22, Lewis Balentine a écrit :
>> It is just I have heard too many times that SQL tables must have primary
>> keys ... and it just is
Le 28/03/2015 20:22, Lewis Balentine a écrit :
> It is just I have heard too many times that SQL tables must have primary
> keys ... and it just is not true.
>
It depends on what you mean by "must". It is not technically mandatory,
but if you create a table without a primary key, you will have pr
My real point was (and I probably stated it very badly) is there is
nothing in SQL that requires a table to have a primary key defined. Thus
one should not assume such key exist unless it is a known DB structure.
For a known structure there is probably an alternative aproach (orber by
something
SQLite (at least the current versions) will always have a row number:
"/SELECT/rowid FROM ..."
If the system does not have a unique row number built it (the only thing
that I use these days is SQLite) then it should be able to be generated
"on the fly" using a calculated field along with the q
Le 28/03/2015 19:09, Benoît Minisini a écrit :
> Le 28/03/2015 18:58, Lewis Balentine a écrit :
>> 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 prim
Le 28/03/2015 18:58, Lewis Balentine a écrit :
> 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
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
Updates:
Status: Accepted
Comment #4 on issue 612 by benoit.m...@gmail.com: 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
Comment #3 on issue 612 by marcobra...@gmail.com: BUG Cannot browse more of
128 records on tables "No current connection"
https://code.google.com/p/gambas/issues/detail?id=612
FYI creating a new project with a new sqlite subset of data i don't have no
more 128 recs limit in browsing.
There m
Comment #2 on issue 612 by benoit.m...@gmail.com: BUG Cannot browse more of
128 records on tables "No current connection"
https://code.google.com/p/gambas/issues/detail?id=612
This is not a good fix. Please provide a project that reproduces the bug.
--
You received this message because this p
Comment #1 on issue 612 by marcobra...@gmail.com: BUG Cannot browse more of
128 records on tables "No current connection"
https://code.google.com/p/gambas/issues/detail?id=612
A dirty custom temporary solution: raising query limit into gambas code
in ~/src/gambas/trunk/comp/src/gb.db.form/.src/
Status: New
Owner:
Labels: Version-TRUNK Type-Bug Priority-Medium OpSys-Any Dist-Any Arch-Any
Desktop-Any GUI-Any
New issue 612 by marcobra...@gmail.com: BUG Cannot browse more of 128
records on tables "No current connection"
https://code.google.com/p/gambas/issues/detail?id=612
__
15 matches
Mail list logo