Dropdown datawindow

I have 3 column with the name country_id , states_id and city_id in a datawindow with dropdown datawindow style in powerbuilder.
I'm using below code in itemchange event but when re select country then states and city column show country row id and state row id.

this.accepttext( )
long ll_country_id, ll_state_id,ll_city_id
DATAWINDOWCHILD ldwc_state, ldwc_city, ldwc_country

this.getchild('country_id',ldwc_country)
this.getchild('state_id',ldwc_state)
this.getchild('city_id',ldwc_city)

if dwo.name = 'country_id' then
	ldwc_state.reset()
	ldwc_city.reset( )
	this.setitem(this.getrow(),'state_id', ' ' )
	this.setitem(this.getrow(),'city_id',  ' ' )
	ldwc_country.accepttext( )
	ll_country_id = ldwc_country.getitemnumber(ldwc_country.getrow(),'country_id')
	ldwc_state.settransobject(sqlca)
	ldwc_state.accepttext( )	
	ldwc_state.retrieve(ll_country_id)
end if

if dwo.name = 'state_id' then
	ldwc_city.reset( )
	this.setitem(this.getrow(),'city_id',  ' ' )
	ll_country_id = ldwc_country.getitemnumber(ldwc_country.getrow(),'country_id')
	ll_state_id = ldwc_state.getitemnumber(ldwc_state.getrow(),'state_id')
	ldwc_city.settransobject(sqlca)
	ldwc_city.accepttext( )
	ldwc_city.retrieve(ll_state_id,ll_country_id)
end if

long ll_country_id, ll_state_id,ll_city_id, ll_null DATAWINDOWCHILD ldwc_state, ldwc_city, ldwc_country this.getchild('country_id',ldwc_country) this.getchild('state_id',ldwc_state) this.getchild('city_id',ldwc_city) setnull(ll_null) if dwo.name = 'country_id' then ldwc_state.reset() ldwc_city.reset() // Question: are state_id and city_id string or number values? //this.setitem(ROW,'state_id', ' ' ) //this.setitem(ROW,'city_id', ' ' ) // I'm assuming they are numeric values: this.setitem(ROW,'state_id', ll_null ) this.setitem(ROW,'city_id', ll_null ) if isnumber(data) then ll_country_id = Long(DATA) ldwc_state.settransobject(sqlca) ldwc_state.retrieve(ll_country_id) end if end if if dwo.name = 'state_id' then ldwc_city.reset( ) // Question: is city_id a string or numeric value? //this.setitem(this.getrow(),'city_id', ' ' ) // I'm assuming it's a numeric value: this.setitem(ROW, 'city_id', ll_null ) ll_country_id = This.getitemnumber(ROW, 'country_id') if isnumber(data) then ll_state_id = Long(DATA) ldwc_city.settransobject(sqlca) if not isnull(ll_country_id) and not isnull(ll_state_id) then ldwc_city.retrieve(ll_state_id, ll_country_id) end if end if end if

Comment

Mayank Chauhan
Sunday, 7 May 2023 18:22 PM UTC

Thanks

Helpful 0

Marcelo Peñailillo
Tuesday, 15 October 2024 16:39 PM UTC

I confirm this anomalous behavior. In no DatawindowChild the row with the field value is selected. In previous versions of Appeon PowerBuilder it correctly selected the corresponding row. Does anyone know how we can request the correction of this Bug? This post is from a year ago

David Peace (Powersoft)
Friday, 18 October 2024 10:56 AM UTC

I'm not sure what bug you are referring to? The problem above was a coding issue that was answered. I suggest you raise a new request for help with you problem and example code and we will help.

There are no comments made yet.

Resolved Dropdown datawindow