• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6925
  • Last Modified:

How to retrieve data from the selected row from a Dropdown DataWindow

I have the following lines of code:

string ls_school_name
integer     li_school_code

li_school_code = dw_school.GetItemNumber(dw_school.GetRow(),'school_code')
ls_school_name = dw_school.GetItemString(dw_school.GetRow(),'school_name')


The problem is the when I issue the GetRow() function, it always returns 1.  How do I get it to return the ROW that the user selected in the DropDown Datawindow?

dw_school is the name of the datawindow control that contains the dropdown data window.  Also, when I use the function dw_school.GetSelectedRow(0) it returns 0, even though the user has selected an item in the dropdown datawindow.  Do I need to reference the DataWindow Child somehow, and if so how?

Another peculiarity is that when I specify:
li_school_code = dw_school.GetItemNumber(1,'school_code')

It returns the school code value for the item the user "selected", but not the value for ROW 1, as it should.  School Code is defined as the DataColumn.  If I issue the same function but for a string which is defined as the DisplayColumn, then I don't get the school name the user selected but the correct name for that Row, for Row one, which is what should be returned.  Is this a bug with PowerBuilder 6.5?

0
amollsde
Asked:
amollsde
1 Solution
 
BhattiCommented:
When you placed a dropdowndatawindow in the column of the datawindow then you set the two values to this column, Data value & Display value. You can' write the GetItemString() if it is an Integer value.

Use GetChild() funtion to get the display value.

//Declare variable (Instance or Local up to you)
Datawindowchild ldwc_child

dw_1.GetChild("column_name", ldwc_child)
ldwc_child.SetTransObject(sqlca)
//You can retrieve the ldwc_child
ldwc_child.Retrieve()

//REMEMBER do not declare the retrieve values for child-datawindow.

ldwc_child.GetItemString(ldwc_child.GetRow(), "Column_name")
//Name of the column have the string value

Which datawindow you want to retrieve after getting the value from dropdowndatawindow?

Please let me know to solve it .


Best regards

Bhatti
0
 
levrCommented:
Let's say 'school_code' is a column in DataWindow 'dw_school'
and 'school_code' is DropDown DataWindow
and this DropDown DataWindow has two columns: 'school_code' and 'school_name'
and you need both values for selected 'school_code'

string ls_school_name
integer li_school_code
Datawindowchild ldwc_child
integer li_row

li_school_code = dw_school.GetItemNumber(dw_school.GetRow(),'school_code')

// get the reference to Child DW as Bhatti advised
dw_school.GetChild('school_code', ldwc_child)

// find the row
li_row = ldwc_child.GetRow()
// or
li_row = dwc_child.Find("'school_code' = li_school_code")

// and get the value
ls_school_name = ldwc_child.GetItemString(li_row,'school_name')

About your questions:

GetRow() returns 1 because it referring to main DW not Child, that has only one row
GetSelectedRow() returns 0 because you didn't select any row in this DW (you select in Child!)
Only display value could be accessed directly
I don't see any PB bugs in this situation, just use Child DW technique
0
 
amollsdeAuthor Commented:
Lev,

Thank you, thank you, thank you!  You've been a lifesaver. This is the second, VERY precise answer you've given me.  I really appreciate your clarity when responding.  I've aways been able to take your solution, make a slight modification to my script and it's worked everytime.
I really appreciate it!

Alecia
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now