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
|
Hello there, I have created a storedprocedure that returns returns data from multiple table. When i drag and drop the storedprocedure into the desinger the Lightspeed doesn,t seem to create a new entity for the returned data. Thanks Parthi |
|
|
|
|
Could you let us know which database you are using, and provide us with the CREATE TABLE and CREATE PROCEDURE scripts please? Thanks! Inferring entities for procedures is somewhat heuristic because procedures don't provide column metadata, and schema-only queries aren't always available against sprocs (e.g. Oracle). Also, if you have an existing entity type which looks like it fits the returned columns of the procedure then we will assign the sproc to that entity type rather than creating a new entity type -- could that be what's happened in your case? |
|
|
|
|
I am using SQL 2005. Light speed returns a entity type which is similar to one that already exist. Is there a way to return a dataset, reader or read the returned data in a different way .
|
|
|
|
|
No, LightSpeed always materialises returned rows as entities: we do not provide a way to access the underlying data reader, or to materialise the data as a DataSet. If the LightSpeed designer is inferring the entity type incorrectly, all you need to do is create the entity definition by hand using the Toolbox, and change the Return Type of the stored procedure to the desired entity type. E.g. create a MyProcedureResult entity type, then select MyProcedure, go to the Properties box and change Return Type to MyProcedureResult. |
|
|
|
