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'm having to use a stored procedure in SQL 2k5 which all works fine, however in the designer it creates the StoredProcedureNameResult Entity thats returned as a collection when the stored procedure is called. The problem is when i select update database it tries to create a table in the database for that entity.
What am i doing wrong? Is there a property on the entity that i can set to tell it to not create a corresponding table?
Thanks.
|
|
|
|
|
Try setting the created entity type to Transient. Please test to make sure you can still select entities of that type -- it's possible the Transient setting will confuse LightSpeed. (It will certainly mean you can't save entities of this type, but since
you presumably don't have a backing table for them, I'm assuming that
won't be an issue.) If this approach doesn't work, let me know and I'll have a look at making the designer a bit smarter about sproc result types. |
|
|
|
|
that did the trick. Thanks. Stu
|
|
|
|
