Insert in correct order

Oct 9, 2012 at 3:33 PM

Hi to all, I'm trying to convert a SQLite DB with FKs.

the schema migration is ok, but I got a lot of errors like:

SQLite2CE Error: Could not insert data into table: medicine_sub_category
Insert command: INSERT INTO [medicine_sub_category] ([medicine],[sub_category]) VALUES (326,37)
Reason: A foreign key value cannot be inserted because a corresponding primary key value does not exist. [ Foreign key constraint name = FK__medicine_sub_category__0000000000000156 ]

I think that is because the tool does not understand the priority of the insertions.

Could you please fix this?

thanks,
Luca