Hi,

I believe this problem has been reported on before but I don't see a fix.

1. Dynamic Views Trial - "Generate Columns" does not return any columns for selected Dyn Form Module

Version 2.1.0.29828 /DNN 5.6.2
Mid:409 / Tab:66

DNN 562 , VWD 2010 website using localhost:portaname/virdir
Selected use Dyn Forms Module Instance radio button
Picked a Dyn Forms Module instance from Dropdown.

Clicking on Generate Column Names link - looks for column names but comes back empty.

login as Admin acct

But, I have 4 or 5 dynamic form instances on this testwebsite.
Same empty column result for all.


I can email a screenshot ( don't see a way to attach a file to this post ).

2. Betasprings Module Issue: Dyn Views module shows license required

Unable to test on BetaSprings

This Page
http://www.betasprings.com/Dynamic-...fault.aspx

Clicking on Dropdown for picking Dyn Form Module
shows empty dropdownlist, why is it not finding any ?

Click Generate Links with No Dynamic Form Module ID
causes Module Exception - shouldn't their be validation
on empty dropdownlist ?

Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'ModuleTitle'. ---> System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at
v

Thanks, Paul Chu

Hello Paul,

Can you please try this blog post:

http://www.datasprings.com/news/blog/postid/22

Let me know if this helps.

Thanks,

Ryan

Hi Ryan,

I looked at this post, which suggested that there might be duplicate field names or too many fields ( not the case for me ).

None of the Dyn Form instances show any column names.

 

But I looked at this new sp

http://www.datasprings.com/portals/...Names.txtv

 and tried to install the new sp below
but it won't compile due to the

FOR READ ONLY clause with the Declare Cursor statement
on my SqlExpress 2008 DNN database.mdf file.

So, I commented out the read only clause and the create procedure then ran.
 ( Didn't try re-running the site again )

  
Not sure how to test this sp since it uses an OUTPUT clause ?

DataSprings_DynamicViews_GetDynamicFormsResults

Which stored procedure is running to generate columns and is it using the
FOR READ ONLY clause too ? If so, it probably won't run on my SqlExpress 2008 and that
could be why there are no columns returning ?

Q1. How to run the sql to test your sp ?

Q2. What sp runs for generate columns ?


Alter Procedure {databaseOwner}[{objectQualifier}DataSprings_DynamicViews_GetDynamicFormsResults]

@ModuleID int,
@UserID int,
@MySQL nvarchar(MAX) OUTPUT

AS
Declare curBubba Cursor
FOR
SELECT ShortFieldName, DynamicQuestionID
FROM {databaseOwner}[{objectQualifier}dynamicforms_question]
where QuestionType <> 'HTML'
AND QuestionType <> 'HR'
AND Question NOT LIKE '%('
AND Question NOT LIKE ')%'
AND InActive=0
AND ModuleID = @ModuleID
AND ShortFieldName NOT IN (Select ShortFieldName from {objectQualifier}DynamicForms_Question where ModuleID = @ModuleID
And InActive=0
Group By ShortFieldName
Having Count(*) > 1)

ORDER BY SortOrder
FOR READ ONLY;

Thanks, Paul

Hello Paul,

Whenever dealing with the modules SP's I would recommend using Host -> SQL and by doing this you can update, delete, add, whatever is needed and you won't get the READONLY error.

So if you have the names of the stored procedures then you can get the content of them by going like this:

sp_helptext "DataSprings_DynamicViews_GetDynamicFormsResults"

But I think you might want to take a look at the LoadDynamicForms stored procedure.

Just try to generate columns from this custom SQL:

select * from Users

If that works then you fall under the issues of duplicated question names, invalid characters in the question names - like a '?', ')', '(' etc...

If you have any questions please let me know.

Thanks,

Ryan

Posted By chupaul on 05-09-2011 08:53 PM

Ryan,

Update :

select * from users - works and shows the columns

But I tried Dyn Forms Module Instance on all 5 on my test website forms and none Generate Column names works
and I believe there are no special characters or duplicate column names .

I will try and run the above sp with Host > Sql and retry ...


Update again:

After going to Host > Sql and running the

Alter Procedure {databaseOwner}[{objectQualifier}DataSprings_DynamicViews_GetDynamicFormsResults]

Then Generate Column names is Working !!!

 

Thanks for your help, Paul

 

 

Hello Paul,

Glad to hear that this is working for you now.

If you ever have any questions please let me know.

Thanks,

Ryan