Hello,
Great job with the new Dynamic Views!
Will this product support “Stored Procedures” in the near future?
For example I created the following example stored procedure below to return one row of data. When I enter the following custom SQL Query “EXEC dbo.DataSpringsDynamicViewsTest” and select generate column names the following error returns.
Thanks in advance,
Matthew
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Creative AutoUpdate v1.40.01)
Timestamp: Tue, 23 Mar 2010 05:42:31 UTC
Message: Sys.WebForms.PageRequestManagerServerErrorException: Incorrect syntax near the keyword 'EXEC'.
Incorrect syntax near ')'.
Line: 5
Char: 62099
Code: 0
URI: http://vessea.com/ScriptResource.ax...ffe29e738d
=============================================
-- Author: Matthew David Elgert
-- Create date: 3/22/2010
-- Description: DataSprings Dynamic Views Stored Procedure Test
-- EXEC dbo.DataSpringsDynamicViewsTest
-- =============================================
CREATE PROCEDURE [dbo].[DataSpringsDynamicViewsTest]
AS
BEGIN
SET NOCOUNT ON;
SELECT 'Matthew' AS [FName],
'Elgert' AS [LName],
'1/1/1900' AS [DOB],
'101 Oak Street' AS [Address],
'Glendale' AS [City],
'CA' AS [State],
'9001' AS [Zip]
END
GO