Sql Table

[cnicolapc]

hi,
is it possible in a sql database to relate multiple tables?
Or you have to find another solution to ensure data integrity?
Nicola

 

[Erel]

Not sure what exactly do you mean with "relate multiple tables". You can add SQL Triggers which act as events each time the database is modified: SQLite Query Language: CREATE TRIGGER

 

[cnicolapc]

Hi Erel
Thanks for the reply.
Maybe something like that ... but I think it's different.
What I mean is the type one to many relationships.
Referential integrity.
Nicola

 

[Erel]

I guess you are looking for foreign keys. The latest version of SQLite support foreign keys. However I believe that it is only available on Android 2.2 and above.