Thank you for your answer. Meantime i realised the autoincrementation for INT4 "manually" in my project. Because i am a novice developer I learned a lot with this trouble at least. :-)
br attila moon_walker wrote: > > Hi Benoit, > > i am developing a cross platform application. The linux side is on GAMBAS > and the Win side is on > C#.NET. The common part is the SQLite database. > > There is some foreign relations which are coupled with comboboxes. > So the child table has some foreign key fields joined to parent primary > keys. > > In the parent tables the primary keys are defined as autoincrement. Since > i was unable to use the type gb.serial at all, i defined this keys in > SQLite-datamanager in firefox. I realised that SQLite only allows > autoincrement for primary key INTEGER. However gambas database manager use > INT4 for the foreign key fields in the child table. > This causes inconsistency in .NET since it is impossible to create > relations on type mismatched fields (INT4 vs INTEGER). If i switch all > related fields to INTEGER then GAMBAS is unable to handle tha databounded > combobox. > > I would prefer that instead of INT4, only INTEGER would be used general by > SQLite area. > > thx > br > Attila > > -- View this message in context: http://www.nabble.com/SQLite-and-INT4-vs.-INTEGER-tp21041236p21124076.html Sent from the gambas-user mailing list archive at Nabble.com. ------------------------------------------------------------------------------ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
