How Can We Help?
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.
Answer
This issue has been resolved in SQL Connector and upcoming build of SQL Connector will contain the fix.
Comments are closed.