If I go to "Module Configuration" > "General Settings" and check "Enable Debug Mode", here's the debug information generated:
***DYNAMIC FORMS DEBUG MODE ON***
Dynamic Forms Version:4.10.5.20228
DotNetNuke Version: 6.2.5
Web.Config Trust Level: Unrestricted
SQL Debug (Parse SQL Text For Variables):SELECT '71.192.27.163' as DefaultValue
SQL for hidden field:71.192.27.163
Initial Javascript:
Saving Forms Responses: 4:16:24 PM
Processing Events: 4:16:24 PM
Processing SQL Event: InsertData -4:16:24 PM
DBType: SQL
Executing SQL Event
SQL Query: INSERT INTO [IPS_CapeCodHospital_SurveyResponses]( [DateTime], [IPAddress], [RegistrationSatisfaction], [DoctorSatisfaction], [HospitalRoomQuality], [NursingStaffRating], [OverallHospitalExperience], [HowLikelyToRecommend] ) VALUES ( CURRENT_TIMESTAMP, '71.192.27.163', 1, 1, 1, 1, 1, 1 )
Failure URL Redirect (Optional):
Executing SQL Next Step
SQL Error Caught: There is no row at position 0.
Processing Email Event: EmailSQLResponse -4:16:25 PM
Attempted Email Distribution
From:
Larry@CompanionSoftware.com
From Name:iPatientSurvey
To:Larry@CompanionSoftware.com
CC:
BCC:
Priority:0
Subject:iPatientSurvey submission SQL response
Message:
Attachment:
Email Type:Html
*** Ending Debug Mode for Dynamic Forms ***
**** Preparing to process all Affected Field Question Events ****
I've bolded the suspicious "SQL Error Caught", above, on a successful submission (which does insert the desired record into the database). It's my guess that this is the source of the problem that I'm seeing.