> Just figured out my mistake, it was that in my database the column types > were INTEGER and not INT4. Once I changed it to INT4 everything started > working great. Sorry to bother! >
No problem. You must be aware that sqlite does not use datatypes, so I have to simulate them by using the datatype keyword you specified when creating the table. But there as so many different datatype keywords in that f...... SQL pseudo-standard that I had to choose! Normally "INTEGER" should have been correctly interpreted as a Gambas Integer datatype. But if there is no primary key in your table, I suppose that the first field of INTEGER datatype is the primary key. Because I use INTEGER only when creating an AUTOINCREMENT field (db.Serial in Gambas). In other words, if you want peace, just create your sqlite database directly from Gambas. Regards, -- Benoît Minisini ------------------------------------------------------------------------------ Using storage to extend the benefits of virtualization and iSCSI Virtualization increases hardware utilization and delivers a new level of agility. Learn what those decisions are and how to modernize your storage and backup environments for virtualization. http://www.accelacomm.com/jaw/sfnl/114/51434361/ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user