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? ------------------------------------------------------------------------------ What happens now with your Lotus Notes apps - do you make another costly upgrade, or settle for being marooned without product support? Time to move off Lotus Notes and onto the cloud with Force.com, apps are easier to build, use, and manage than apps on traditional platforms. Sign up for the Lotus Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
