Am I Missing Anything to use a Stored-Procedure with the Entity Definitions?

How Can We Help?

Am I Missing Anything to use a Stored-Procedure with the Entity Definitions?

< Back

I created a virtual entity and configured the virtual entity to a table and used the read operation.

I added the virtual entity to my form and on-load of the form all the records from my table are shown according to the layout, I designed in the virtual entity.

Now I created a new virtual entity and configured the virtual entity to a stored procedure (instead of a table).
The stored procedure is a simple procedure something like this:

Create PROCEDURE [dbo].[FetchItems]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT ItemNo, ItemDesc, Price from Items
END

Now I added the virtual entity to the form. Now, I would expect on-load of the form I will see all the records that are returning from my stored procedure. But the user interface doesn’t show anything.

I configured the stored procedure as attached in the attachment.

image_271

Answer

This issue has been resolved in SQL Connector and upcoming build of SQL Connector will contain the fix.

Comments are closed.

This is the legacy version of the XMPro Documentation site. For the latest XMPro documentation, please visit documentation.xmpro.com

X