External data source problem

[k.Anantharaman]

Hai
I have a datawindow created with data source as external. I have a
few dropdown datawindows attaced to a few columns. I have added a few
rows to the datawindow.
The problem iam facing is that the dropdown datwindows do not display
any data.
What is wrong . Is it poosible to have drop down datawindows attached to
datawindows which have external as datasource.What script should I add
for this.
Bye
Thanks
P.Sridhar

[Ron Gallagher]

P. --

By default, data for a dddw is retrieved whenever the 'main' dw is
retrieved. Since you're using an external dw, you're probably not
invoking the Retrieve() method. If that is the case, you must retrieve
data for the dddw's yourself. Use the GetChild() function to get a
handle to the dddw. Once that's done, you can invoke the Retrieve()
function for the datawindowchild.

Example from constructor event of a datawindow
datawindowchild ldwc_child
if this.getchild('colname',ldwc_child) = 1 then
ldwc_child.settransobject(sqlca)
ldwc_child.retrieve()
end if

HTH

Ron Gallagher, CPDP
Atlanta, GA, USA
rongal...@mindspring.com

[Gloria]

On Thu, 05 Mar 1998 20:39:21 +0530,
in powersoft.public.powerbuilder.datawindow

k.Anantharaman <ana...@hclt.com> wrote:
>Hai
> I have a datawindow created with data source as external. I have a
>few dropdown datawindows attaced to a few columns. I have added a few
>rows to the datawindow.
>The problem iam facing is that the dropdown datwindows do not display
>any data.
>What is wrong . Is it poosible to have drop down datawindows attached to
>datawindows which have external as datasource.What script should I add
>for this.
>Bye
>Thanks
>P.Sridhar
>

If you use PFC, simply use dw_1..inv_base.of_refreshdddws() after
dw_1.insert(0). Otherwise, get child dw's handle, settransobject, child
datawindow retrieve.

[Sanjiv Das [TeamPS]]

Sridhar / Anantharaman,

If you have any rows defined in the DW painter and saved with the DDDW
definition, it will not automatically load the DDDWs. Another possibility is
that you may not have performed a SetTransObject ( ) on the parent DW. If
neither of these is the case, the DDDWs should automatically be populated
when the first row is added to the parent DW, either through an InsertRow
) or a Retrieve ( ).

HTH

Sanjiv Das [TeamPS]

k.Anantharaman wrote in message <34FEC021...@hclt.com>...