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
|
If you are using Simpledb as a data source and you specify the identity column name for a table in a model it throws an error saying that ItemName is required. If you remove the text specifying this column it works correctly. One of two things and it's not entirely clear. If this is supposed to specify a column in the current table then it should probably be a drop down to make it more obvious that you can only pick items that are currently in the table. I assumed that you could specify a name and it would override the "Id" part of the object. |
|
|
|
|
This setting is relevant in traditional relational databases, where the user can choose the name of the column which contains the identifying key -- the column which will be mapped to the LightSpeed Id. For example, a Product table might have its identity column named ProductId. The Identity Column Name setting doesn't 'override the "Id" part of the object' -- it just tells LightSpeed that the '"Id" part of the object' maps to a column which isn't named "Id". In SimpleDB, the identity 'column' is always the ItemName. You can't choose a different name for ItemName: that's just what it is. Therefore, LightSpeed maps ItemName to Id automatically and you can't override this -- which is what Identity Column Name tries to do. (The obvious question is why in this case don't we hide the option. The reason is that models are database-independent -- although a model may have been generated from a SimpleDB source, the model itself is not bound to SimpleDB. It would be good if we could handle this better though!) |
|
|
|
|
Sounds good Ivan. I just put this up here in case others were running into this problem. |
|
|
|
