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 the following tables in my database, "Files", "Trustors", "Files_Trustors". Both tables "Files" and "Trustors" have a DateTime column "CreatedOn". When I import the tables into a LightSpeed Model, "CreatedOn" is missing from the entity, whereas, the column, "ModifiedOn" is visible. The "CreatedOn" columns are not nullable. In the code, I get an Ambiguous reference. Any idea on what is going on here? I've attached three images showing the situation. Thanks, James |
|
|
|
|
CreatedOn is a reserved name in LightSpeed and is used for entity tracking so we dont surface this within your model, rather it becomes an auto-assigned property which you toggle on/off within the entity properties - see http://www.mindscapehq.com/documentation/lightspeed/Implementing-Storage-Policies-with-LightSpeed/Entity-Tracking for details on this. If you want to have this as a column you manage yourself you will need to create and entity property with a different name and then map it to CreatedOn by changing the Column Name value for that property. You may still get notifications in the designer wanting to delete that property and set the CreatedOn flag for the entity so you will have to ignore these.
|
|
|
|
|
Hi Jeremy, Ok, that makes sense. I changed CreatedOn to CreatedDate and it's working fine now. Thanks for the help. James |
|
|
|
