Very Computer

by **Kevin Stussm** » Wed, 07 Feb 1996 04:00:00

I have a self-referencing table (i.e. ER fish-hok or this kind of
relationship:

(Field) Department ID : ID Type
(Field) Reports to : ID Type

The "Reports to" field will be either null (reports to no-one) or with
a valid Department ID (within the same table). Recursion 101 :-)

Anyway, when I insert into this table, the row goes in fine but the
Drop Down List Box i'm using for the "Reports To" field doesn't show
the new row. Even when I cause the parent (i.e. the datawindow the
DDLB is in) to retrieve, it still won't put the new entry in the DDLB.
Only when I close the window and open it again will the DDLB have the
new row. This makes some sense if a retrieve of the DataWindow the
DDLB is in does not cause the DataWindow of the DDLB itself to
refresh, but I need to in this case.

How can I tell the Data Window DDLB to re-read it's table?

Puzzled..

Kevin Stussman

by **Bob Rege** » Thu, 08 Feb 1996 04:00:00

Quote:
>I have a self-referencing table (i.e. ER fish-hok or this kind of
>relationship:

>(Field) Department ID : ID Type
>(Field) Reports to : ID Type

>The "Reports to" field will be either null (reports to no-one) or with
>a valid Department ID (within the same table). Recursion 101 :-)

>Anyway, when I insert into this table, the row goes in fine but the
>Drop Down List Box i'm using for the "Reports To" field doesn't show
>the new row. Even when I cause the parent (i.e. the datawindow the
>DDLB is in) to retrieve, it still won't put the new entry in the DDLB.
>Only when I close the window and open it again will the DDLB have the
>new row. This makes some sense if a retrieve of the DataWindow the
>DDLB is in does not cause the DataWindow of the DDLB itself to
>refresh, but I need to in this case.

>How can I tell the Data Window DDLB to re-read it's table?

First off, I believe you are referring to a drop down datawindow (DDDW) and
not a drop down list box.
You must manually force a dddw to re-retrieve. You first obtain its handle,
set the transaction object of the child datawindow, and then retrieve.
Please see the help for Child Datawindows for more complete info.

bob

by **Your Na** » Thu, 08 Feb 1996 04:00:00

Quote:
>I have a self-referencing table (i.e. ER fish-hok or this kind of
>relationship:

>(Field) Department ID : ID Type
>(Field) Reports to : ID Type

>The "Reports to" field will be either null (reports to no-one) or with
>a valid Department ID (within the same table). Recursion 101 :-)

>Anyway, when I insert into this table, the row goes in fine but the
>Drop Down List Box i'm using for the "Reports To" field doesn't show
>the new row. Even when I cause the parent (i.e. the datawindow the
>DDLB is in) to retrieve, it still won't put the new entry in the DDLB.
>Only when I close the window and open it again will the DDLB have the
>new row. This makes some sense if a retrieve of the DataWindow the
>DDLB is in does not cause the DataWindow of the DDLB itself to
>refresh, but I need to in this case.

>How can I tell the Data Window DDLB to re-read it's table?

>Puzzled..

>Kevin Stussman

look into dwgetchild and then do a retrieve on what that function returns

dwgetchild is a function search in help, it has a good example

Very Computer

Help : Refreshing the Data Window within a Drop Down List Box

Help : Refreshing the Data Window within a Drop Down List Box

Help : Refreshing the Data Window within a Drop Down List Box

Help : Refreshing the Data Window within a Drop Down List Box