bansshilpi
Programmer
I have a window which is a questionnaire. It has a datawindow in it which displayed question and there is a dropdown list for each questions's answer to be selected by user.
Like question 1. Are you a school going? Answer drop down list can have answers like (DisplayColumn/DataColumn)
Yes/a_y
No/a_n
Now each question filters the answers dddw to fetch its corresponding answer list. but as soon as i click to other dropdown list to answer other question, the previous window displays data values instead of displaying text value.
i have created a function with below code which is getting called on each itemfocusedchanged event
idwc_answer.SetFilter("")
idwc_answer.Filter()
ls_question_code = dw_1.GetItemString(ai_row, "question_code")
ls_filter = "question_code='" + ls_question_code
idwc_answer.SetFilter(ls_filter)
idwc_answer.Filter( )
dw_1.Setfocus( )
dw_1.SetColumn("answer_code")
I have tried resetting display property using
dw_1.Modify("answer_code.dddw.DisplayColumn='answer_text'")
but it is destroying references of each dddw and i am not getting correct answers code.
Please help me if this can be done in PB 12.5
PFA image to see the layout of window
Link
Like question 1. Are you a school going? Answer drop down list can have answers like (DisplayColumn/DataColumn)
Yes/a_y
No/a_n
Now each question filters the answers dddw to fetch its corresponding answer list. but as soon as i click to other dropdown list to answer other question, the previous window displays data values instead of displaying text value.
i have created a function with below code which is getting called on each itemfocusedchanged event
idwc_answer.SetFilter("")
idwc_answer.Filter()
ls_question_code = dw_1.GetItemString(ai_row, "question_code")
ls_filter = "question_code='" + ls_question_code
idwc_answer.SetFilter(ls_filter)
idwc_answer.Filter( )
dw_1.Setfocus( )
dw_1.SetColumn("answer_code")
I have tried resetting display property using
dw_1.Modify("answer_code.dddw.DisplayColumn='answer_text'")
but it is destroying references of each dddw and i am not getting correct answers code.
Please help me if this can be done in PB 12.5
PFA image to see the layout of window
Link