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
|
Migrations: Adding a Column to existing Table where Table contains data already I'll be honsest, I've not tried this yet, as I'm looking at the product (CHM) for the first time! I was looking to see if Migrations Add Column had a default value parameter. How it is suggested that one uses Migrations to add a Column which should contain some default value, where during development, the Table already has some test data. thanks John |
|
|
|
|
Hello John, and sorry for the belated reply. You can't currently customise the default value when adding a column. However, for many data types we do supply a sensible default value such as 0 or ''. If necessary, you can further customise behaviour by calling ExecuteNativeCommand to issue an ALTER TABLE statement. |
|
|
|
