Call Datawindow according to Drop Down Value

[getjbb]

Is it possible to call a datawindow according to a value selected from a drop down data window, which is located on a parameter type datawindw. The parameter type datawindow has a begin and end date and a code field. The code field determines what type of 2 reports should appear. In this instance I cannot use the window to insert code into for proprietary reasons. I am using Powerbuider 9. Thanks in advance for your answer.

getjbb

 

[mbalent]

One way:

You have two datawindow objects, dw_one and dw_two.
Your frame has a datawindow control dw_results.
Your dropdown has code "one" and code "two".

Based on what is selected by the user in the dropdown you set a string variable (ls_dwo) equal to the datawindow objects name ("dw_one" or "dw_two")

Then

dw_results.dataobject = ls_dwo
dw_results.settransobject(SQLCA)
dw_results.retrieve()

etc...


Matt

"Nature forges everything on the anvil of time

 

[getjbb]

Thanks.

getjbb