Hello,

I have found a small error when adding a question to a survey page. If you add, for example, three questions to a survey page then the "QuestionOrder" field will have the values: 0,1,2. Then if you delete then question number 1 then "QuestionOrder" field will contain the values 1,2. Then if you add a new field then "QuestionOrder" values will be: 0,2,2. If we repeat the steps, deleting the first question and adding a new one we end up with the questions with order "2". This will happen if we repeat it with any number of questions. Now if we try to sort the questions we will find some strange behavior, specifically, if we move up the las question we will see that it is moved to the top.

This is not a big deal since the step for making the error happen are no very common, the problem comes in from the procedure mp_SurveyQuestions_Insert, the way it sets the order is selecting the count of records. The simpler solution will be replacing the count with a max plus one:

SELECT@pageQuestionCount = Max(QuestionOrder)+1
FROM mp_SurveyQuestions
WHERE PageGuid = @PageGuid

The same problem occurs un the survey pages.