[Gambas-user] Connection.Tables

[tobias]

Benoît Minisini schrieb:
>>>> You can't update the primary index of a table once it has been created
>>>> anyway.
>>>>
>>>> I have understood where the bug with primary key comes from. It is just
>>>> a matter of case: write "integer" in upper case, and the database
>>>> driver will detect the primary key!
>>>>
>>>> To understand all that, you must be aware that SQLite is a non-typed
>>>> database, i.e. the field datatypes given in the CREATE TABLE statement
>>>> are mostly ignored. A SQLite field can hold any datatype, whatever its
>>>> definition!
>>>>
>>>> "Mostly", because there is a big exception: if you declare a field as
>>>> "integer primary key", you actually declare a 64 bits integer-only
>>>> field that will increment automatically as each record creation. And
>>>> this special primary key does not appear in the index list returned by
>>>> SQLite (because it is actually an index present in each table, named
>>>> "rowid").
>>>>
>>>> See http://www.sqlite.org/lang_createtable.html for more information.
>>>>
>>>> To detect it, I added a test on the table SQL declaration: if I don't
>>>> see any index in the table, and if the table has an integer field, I
>>>> assume it is the primary key.
>>>>
>>>> The test is not perfect yet (a table could have an "integer" field and
>>>> no primary key), but, more important, it was buggy, as it assumed that
>>>> "integer" was written in upper case!
>>>>
>>>> I will fix that in the next revision, and your "id integer primary key"
>>>> will be correctly detected as the primary key of the table.
>>>>
>>>> Note that if you create your table by using the Gambas interface, and
>>>> not by sending "CREATE TABLE" statements directly, you won't have the
>>>> problem, because Gambas only uses "integer" when creating an
>>>> autoincrement integer field. For all other integer fields, it uses
>>>> "INT4".
>>>>
>>>> Regards,
>> to be correct, that revision is this about? i couldn't find it in the ide?
>>
> 
> I said I *will* fix the bug. It is not yet committed!
> 

hmm, can you kindly tell me the revision number after it was done?