Saturday, February 11, 2012
  Search
Support Forum
A column named 'Middle Name' already belongs to this DataTable
Last Post 29 Oct 2008 11:42 PM by Code 5. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ynot
New Member
New Member
Send Private Message
Posts:1


--
29 Oct 2008 05:25 PM  
After I updated from 1.06.02 to 2.0.2 on the 18-10-2008 I cannot view the data that was entered on that day.
All the data on other days can be viewed and downloaded just fine.

The error I get when I try to view the data on the 18-10-2008 is:

Error: Form Master Edit is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: A column named 'Middle Name' already belongs to this DataTable. ---> System.Data.DuplicateNameException: A column named 'Middle Name' already belongs to this DataTable. at System.Data.DataColumnCollection.RegisterColumnName(String name, DataColumn column, DataTable table) at System.Data.DataColumn.set_ColumnName(String value) at Code5Systems.FormMaster.Business.FormDataController.GetDataSetFromFormResults(String xml, String modulePath, Boolean fromControl) at Code5Systems.FormMaster.Business.FormDataController.List(Int32 moduleId, DateTime dtStart, DateTime dtEnd, Int32 pageNum, Int32 pageSize, String modulePath, Boolean fromControl) at Code5Systems.FormMaster.FormReport.BindGrid() --- End of inner exception stack trace ---

The error when I try to download the data from the 18-10-2008 is:

A column named 'Middle Name' already belongs to this DataTable.

Please Use your Browser Back button to Return


This is very frustratiing.

I have tried changing the FormResultsDataSet.xslt file as artilce

http://www.code5systems.com/Support...lt.aspx#86

describes and I still get the error.


I have five data entries that were entered on the 18-10-2008. I guess if I can delete them somehow it might work.

Any suggestions?


Cheers

Tony

Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
29 Oct 2008 11:42 PM  
This has been an issue for quite some time with Form Master when a user changes the position of a Field after data has been stored, then runs reports spanning the time before and after the change. The only resolution at this point is to not run reports spanning the change date, or download then remove data prior to the change. The referenced fix works for some people.

To avoid this situation it is recomened that an external table be used to store the data.
You are not authorized to post a reply.

Active Forums 4.2
Copyright 2004-2012 Code 5 Systems, LLC.