C cnicolapc Active Member Licensed User Longtime User Feb 23, 2011 #1 hi, is it possible in a sql database to relate multiple tables? Or you have to find another solution to ensure data integrity? Nicola
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 B4X founder Staff member Licensed User Longtime User Feb 23, 2011 #2 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 Upvote 0
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
C cnicolapc Active Member Licensed User Longtime User Feb 23, 2011 #3 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 Upvote 0
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 B4X founder Staff member Licensed User Longtime User Feb 24, 2011 #4 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. Upvote 0
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.
