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 We have a problem when doing deletes with Class Table Inheritence. We the following set up Expresionable -- Activity --- .. Other children of Expressionable Activity has a NlBrokerId which points to a person. When we want to delete a person Mindscape tries the update the Expressionable as followed.
UPDATE Expression SET ExpressionableId = NULL WHERE (EXISTS ( SELECT Expressionable.* FROM Expressionable WHERE Expressionable.Id = Expression.ExpressionableId AND EXISTS ( SELECT t0.* FROM Person t0 WHERE t0.Id = Activity.NlBrokerId AND t0.Id = 1076100 ) ) AND Expression.DeletedOn IS NULL); I am not really sure why it even fires this update were deleting a person which should only set NlBrokerId to NULL and not ExpressionableId.
|
|
|
We'd need to see a bit more of the model to diagnose this I think. Could you provide us with a small console or NUnit project that reproduces this issue? Ideally including the database CREATE TABLE scripts and some sample data. You can attach a zip file via the Options tab. Thanks! |
|