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
|
I have got two problems with ClassTableInheritance
Looks like that LS forget to join the RootProject table.
Kind regards, |
|
|
Another thing: It would be helpful if LS creates a DB constraints from the RootProject and SubProject table to the BaseProject table (vai the PKs), because I can enforce a cascading deletion for the BaseProject at the DB level. |
|
|
When adding a RootProject LS creates that SQL: INSERT INTO RootProject and fails because of the BaseProject_Id column which isn't there (BaseProject_Id is the PK of the base class). LS should use the RootProject_Id instead.
|
|
|
Forget to mention that I use the LightSpeed30Professional-20100501 |
|
|
Just to let you know, we have been working on fixes but it is taking longer than expected. We'll let you know when they become available. Thanks for letting us know about these issues! |
|
|
Thank you for the update. I will be waiting... :-) Regards, |
|
|
We believe these issues are fixed in the current (10 May) nightly build. Please download it and give it a go, and as always do let us know if you run into any problems -- we really appreciate your taking the time to work with this functionality during its development stage! We weren't able to reproduce the RootProject insert issue. We're not sure whether this is because we haven't understood the issue or because it's been fixed as a side effect of other work we're doing. If you still see that issue, could you provide us with repro code please? Thanks! |
|
|
Forgot to add: thanks for the suggestion about creating a database constraint on the primary keys. Unfortunately we won't be doing this for 3.1 due to lack of time. Of course you can still add those constraints manually to the database that LightSpeed creates for you. |
|