You can add faked foreign keys to SQLite with triggers (google it). But you'll take a performance hit for it. Still, orphan records blow. It's a tossup.
On Mon, Dec 22, 2008 at 7:35 AM, Mark Murphy <[email protected]>wrote: > > gsk wrote: > > I am trying to join two tables in the Android SQlite DB but looks > > like SQlite does not support foreign key relationships. > > http://www.sqlite.org/syntaxdiagrams.html#table-constraint > > > I am sure other people must be using multiple tables in their > > Android app, how do you join them? > > Joining does not require foreign key relationships. All foreign key > relationships do is enforce referential integrity. So, you join tables > in SQLite the same way you do in any other SQL-based database. > > -- > Mark Murphy (a Commons Guy) > http://commonsware.com > _The Busy Coder's Guide to Android Development_ Version 1.9 Available! > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
