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 created a stored procedure and added the sproc to the lightspeed model. When this was done an entity object was also created automatically. When I goto call the sproc I get the following error No Id returned from the stored procedure "xyz" Check that the stored procedure selected the identity column. The query I am returning does not return select an identity column, it is just returning a list of properties, a property value and property description. The query from sproc is below. SELECT p.[Id] AS PropertyId,ISNULL(p.[PropertyValue],d.[PropertyDefaultValue]) AS PropertyValue, d.[PropertyDescription] FROM [ApplicationProperty] AS p WITH (NOLOCK) LEFT JOIN [ApplicationPropertyDef] AS d WITH (NOLOCK) ON p.PropertyDefId=d.Id WHERE p.[RecordId]=@RecordId AND d.[TableName] LIKE @TableName AND d.[Category] LIKE @Category AND d.[PropertyName] LIKE @PropertyName AND p.[DeletedOn] IS NULL I am calling the sproc as follows results=uow.PropertiesfetchSpeific(params in here) Cheers |
|
|
I have solved the error by using the ROW_NUMBER() OVER in my Sproc. Cheers |
|