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 a stored procedure which return a datatable (from a SELECT FROM WHERE inside SP). When i imported this SP in LightSpeed model, I only see the Integer value returning from generated function. How can i receive this datatable? Thanks |
|
|
|
|
What does the record set being selected look like? Is it selecting back a collection of integers? We dont surface DataTables as we map these against an entity which will have properties to map to the returning fields.
|
|
|
|
|
My SP will return a table which contains 2 columns: Success and Message. The success column will contains true/false value and Message column will contain the success/error message. Something like : SELECT Case xxx WHEN 1 THEN 1 ELSE 0 END AS Success, Case Success WHEN 1 THEN 'Success message' ELSE 'Failed message' END AS Message |
|
|
|
|
Sounds like we were not able to automatically detect the returning columns so you will want to set this manually. Update the generated entity for the stored procedure to specify two properties (Success: bool and Message: string) to match the returning result set.
|
|
|
|
