procedure.ProcedureText returns NOTHING...

[david.house]

Procedure.ProcedureText will not parse Stored Procedures created with MyGeneration Template...

I have attached a ZIP file containing the script we use to create stored procedures, along with a sample stored procedure created by the script. In order to correctly build a sample procedure, you will need to define one column as a 'SearchField' with a value of 'True' in the schema meta data. Then the script will build a procedure based on any table with this criteria added.

Once built, execute the 'Generate 01.00.00.SqlDataProvider and Uninstall.SqlDataProvider script in the DNN-4x namespace, and you will see what we are running into...The procedure.ProcedureText is EMPTY...It will not parse the procedure and populate the ProcedureText attribute.