We have a 10 question survey. Each question is on a separate page. So there are 10 pages.
When we click Insert-Page-Break on Question 9, we expect Q9 pushed to P10, Q10 pushed to P11 and be left with a blank Page 9.
That isn't what's happening. Multiple blank pages get inserted in multiple areas. Some questions merge into other pages. Whole thing gets all messed up.
Looking at the vts_spSurveyInsertPageBreak procedure, the query is updating all questions in the survey based on DisplayOrder.
The problem is, the DisplayOrder values in the tbQuestion table don't correspond to the PageNumber values for the respective questions. They're completely different. I don't see how the stored-procedure can ever succeed in this situation.
I can provide an XML if anyone wants to take a look at it. If we can't get the survey builder to function as expected, it kills our whole project.