[Gambas-user] SQLite and INT4 vs. INTEGER

[moon_walker]

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.