This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Some time ago I had some questions concerning changing and removing columns using SQLite provider (http://www.mindscapehq.com/forums/thread/3780). Now we came to the point that AddForeignKeyColumn doesn't work for SQLite at all. According to http://sqlite.org/foreignkeys.html#fkschemacommands, it should work for nullable references: "It is not possible to use the "ALTER TABLE ... ADD COLUMN" syntax to add a column that includes a REFERENCES clause, unless the default value of the new column is NULL. Attempting to do so returns an error. " I attach an example where our tests fail on AddForeignKeyColumn in "ModifyDB" migration. |
|
|
|
|
This limitation will be removed in the next nightly build. Let us know if you still see problems. |
|
|
|
|
It works fine now. Thank you!!! However it still would be great if you provided workarounds of SQLite limitations ... ;-) |
|
|
|
