>>>>Can a grid style datawindow contain a DDDW style column as one of it's
>>>>columns. The DDDW could have a seperate list of values for each row in
>>>>the grid. I am using external datawindows...and embedded SQL
>>>Yes it can....
>>Not so fast...The dddw for each row can have different values for
>>each row...based on a retreival arg...I'll be real happpy if you can get
>>it to work now..
>I recently posted a request for information on this same problem. My
>grid column DDDW affects the other columns for that row, as well.
>I was looking for info on how to determine the selected row from the
>DDDW, since I don't know how to address each DDDW distinctly within
>the larger DW.
>Can you forward any full responses to me please ?!
If I understand your requirement, you should be able to achieve your
objective. I would first suggest reviewing the dddw example in the
4.0 example applications. If you run it you can get a nice report of
the application. The primary window is w_dddw_techniques.
When you say "DDDW affects other columns", I assume you mean
that the value of the item chosen from the DDDW will be used to
calculate other columns in the row (e.g., a computed column).
When you drop the DDDW down and choose an item, remember
that the DATA value, not the DISPLAY value will effect other values
that depend on that column. You will need a separate "child
datawindow handle" for each column that contains a DDDW.
Obtaining the handle is demonstrated in the example I referenced.
If you need to modify other columns once you select an item in
the dddw, simply use the itemchanged event to detect the change,
use "getitemxxxxx()" to extract the data from the dddw column,
and then use SetItem() to set the value of your computed column.