Most likely, it means you didn't specify a value for the foreign key
when inserting into the child table (ref_id_value in the snippet below).
-- Kostya
14.03.2011 16:27, Brad Stintson пишет:
Thanks.
I created foreign key, but when I try to insert values using m
application it throws
/android.database.sqlite.SQLiteConstraintException: error code/
/ 19: constraint failed./
/
/
But if I insert values manually usiing console, then values are
inserted properly. Why is it so?
2011/3/13 Kostya Vasilyev <[email protected] <mailto:[email protected]>>
SQLite has foreign key support starting with version 3.6.19.
http://www.sqlite.org/foreignkeys.html
Some versions of Android have SQLite versions earlier than that -
someone posted a breakdown recently, check the list archives.
For earlier versions, it works pretty well to do something like:
CREATE TABLE ....
.....
ref_id_value INTEGER NOT NULL REFERENCES the_other_table (_id)
For transactions, check SQLiteDatabase docs:
http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#beginTransaction()
<http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#beginTransaction%28%29>
The above gives the usual pattern for using transactions.
-- Kostya
13.03.2011 13:16, Brad Stintson пишет:
How to use transaction and how to implement the concept of
foreign key?
2011/3/13 Kostya Vasilyev <[email protected]
<mailto:[email protected]>>
Multiple inserts, one at a time. Preferably using a transaction.
13.03.2011 12:58 пользователь "Brad Stintson"
<[email protected] <mailto:[email protected]>> написал:
> How to insert multiple tables which have few fields in common?
>
> --
> 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]
<mailto:[email protected]>
> To unsubscribe from this group, send email to
> [email protected]
<mailto:android-developers%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
--
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]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:android-developers%[email protected]>
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
--
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]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
--
Kostya Vasilyev --http://kmansoft.wordpress.com
--
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]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:android-developers%[email protected]>
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
--
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
--
Kostya Vasilyev -- http://kmansoft.wordpress.com
--
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
