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
|
Hi. I have some views in the model. The definition of a view is changed in the database (in my example, more columns are added). But in Designer "Update from source" doesn't update entity definition for that view. Same happens if I start "Update from source" for the complete model. Looks like views are ignored in the update. |
|
|
|
|
Yes, views were previously ignored in the update. I've added experimental support for views, and it will be in the 20 Aug nightly build. Please be aware that this may give you what another customer describes as "experimental results," and do let us know if you run into any issues or bugs. This will only work for updating the model from the database (Update From Source). Changes made to a view-backed entity in the model can't be pushed to the database. |
|
|
|
|
I've tested it on some of my cases, looks like it's working OK. Thanks! |
|
|
|
|
When I try to Update from Source, the designer wants to remove my view from the model in the latest nightly build.
|
|
|
|
|
Set the Access Method to View. (It's under Persistence if you have the Properties window categorised.) If the model was created with an older version of the designer, which didn't store access methods, this will be defaulting to Table, and the designer will be looking specifically for a table that the entity could map to (and finding nothing of course). Current versions of the designer will of course set the Access Method correctly when you drag a database object on. |
|
|
|
