Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Retrieving a dddw based on value in another col

2 posts in DataWindow .NET Last posting was on 2004-08-31 16:32:22.0Z
Rajeev Gupta Posted on 2004-08-31 16:26:01.0Z
Sender: 1bcc.4134a0e9.1804289383@sybase.com
From: Rajeev Gupta
Newsgroups: sybase.public.datawindow.net
Subject: Retrieving a dddw based on value in another col
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4134a699.1c90.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Aug 2004 09:26:01 -0700
X-Trace: forums-1-dub 1093969561 10.22.241.41 (31 Aug 2004 09:26:01 -0700)
X-Original-Trace: 31 Aug 2004 09:26:01 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:253
Article PK: 124686

I searched for the method GetChild but did not find
How can I filter or restrict the values in a drop down data
window based on the value of another col say I have a col of
states and a col for cities I want the cities dddw to show
on those belonging to the currently selected state in the
state dddw col

thanks


Jack Addington Posted on 2004-08-31 16:32:22.0Z
From: "Jack Addington" <jaddington@shaw.ca>
Newsgroups: sybase.public.datawindow.net
References: <4134a699.1c90.1681692777@sybase.com>
Subject: Re: Retrieving a dddw based on value in another col
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: s010600e018e32f17.cg.shawcable.net
X-Original-NNTP-Posting-Host: s010600e018e32f17.cg.shawcable.net
Message-ID: <4134a816$1@forums-1-dub>
Date: 31 Aug 2004 09:32:22 -0700
X-Trace: forums-1-dub 1093969942 68.147.193.82 (31 Aug 2004 09:32:22 -0700)
X-Original-Trace: 31 Aug 2004 09:32:22 -0700, s010600e018e32f17.cg.shawcable.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:255
Article PK: 124685

The getChild method is there...
DataWindowChild dwc_ptype

dwc_ptype = dwProgramDetails.GetChild("program_type_code");

dwc_ptype.SetTransaction(programTrans);

dwc_ptype.Retrieve("ProgramType");

dwProgramDetails.Retrieve(1);

As for changing the dropdown based on the col it should work exactly the
same as in PB. If the row state column changes then you have to redo the
getChild and retrieve/ ShareData/filter functions to get the new list of
cities. Of course you run in to the fun problem that the list changes for
all the rows in the datawindow.

<Rajeev Gupta> wrote in message news:4134a699.1c90.1681692777@sybase.com...
> I searched for the method GetChild but did not find
> How can I filter or restrict the values in a drop down data
> window based on the value of another col say I have a col of
> states and a col for cities I want the cities dddw to show
> on those belonging to the currently selected state in the
> state dddw col
>
> thanks