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-tp21041236p21041236.html Sent from the gambas-user mailing list archive at Nabble.com. ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
