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.

How to get display column value in dddw column

3 posts in DataWindow Last posting was on 2009-11-25 11:39:52.0Z
SamRam Posted on 2009-11-25 00:15:58.0Z
Sender: 3760.4b0c75bd.1804289383@sybase.com
From: SamRAm
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: How to get display column value in dddw column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b0c773e.37b1.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Nov 2009 16:15:58 -0800
X-Trace: forums-1-dub 1259108158 10.22.241.41 (24 Nov 2009 16:15:58 -0800)
X-Original-Trace: 24 Nov 2009 16:15:58 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90342
Article PK: 409946

Using PB 9.
Have a DW with a column of dddw style.
Once the user selects a value in the dddw column, how can I
get the data column value and the display column value?
Thanks.


Jeremy Lakeman Posted on 2009-11-25 06:08:50.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: How to get display column value in dddw column
Date: Tue, 24 Nov 2009 22:08:50 -0800 (PST)
Organization: http://groups.google.com
Lines: 20
Message-ID: <f7e9949d-41bd-448c-a7cd-d7ef8e46cad4@f16g2000yqm.googlegroups.com>
References: <4b0c773e.37b1.1681692777@sybase.com>
NNTP-Posting-Host: 203.122.242.105
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1259129330 10719 127.0.0.1 (25 Nov 2009 06:08:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 25 Nov 2009 06:08:50 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f16g2000yqm.googlegroups.com; posting-host=203.122.242.105; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-Via: 1.1 fly.essential.com.au:3128 (squid/2.5.STABLE8), 1.0 asp.essential.intranet:3128 (squid/2.5.STABLE8)
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!69.16.185.21.MISMATCH!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!f16g2000yqm.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90343
Article PK: 409948


On Nov 25, 10:15 am, SamRAm wrote:
> Using PB 9.
> Have a DW with a column of dddw style.
> Once the user selects a value in the dddw column, how can I
> get the data column value and the display column value?
> Thanks.

data value;
dw_1.object.column[row]
dw_1.getitem<XXX>(row, 'column')

display string;
ls_display = dw_1.describe("evaluate('lookupdisplay(column)',row)")

some other column from the drop down;
datawindowchild ldwc
long ll_row
dw_1.getchild('column', ldwc)
ll_row = ldwc.find('<data_column> = '+string(dw_1.object.column[row]))
ldwc.getitem<XXX>(row, 'some_other_column')


SamRam Posted on 2009-11-25 11:39:52.0Z
Sender: 4425.4b0cae90.1804289383@sybase.com
From: SamRam
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: How to get display column value in dddw column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b0d1788.5553.1681692777@sybase.com>
References: <f7e9949d-41bd-448c-a7cd-d7ef8e46cad4@f16g2000yqm.googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Nov 2009 03:39:52 -0800
X-Trace: forums-1-dub 1259149192 10.22.241.41 (25 Nov 2009 03:39:52 -0800)
X-Original-Trace: 25 Nov 2009 03:39:52 -0800, 10.22.241.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90344
Article PK: 409949


> On Nov 25, 10:15 am, SamRAm wrote:
> > Using PB 9.
> > Have a DW with a column of dddw style.
> > Once the user selects a value in the dddw column, how
> > can I get the data column value and the display column
> > value? Thanks.
>
> data value;
> dw_1.object.column[row]
> dw_1.getitem<XXX>(row, 'column')
>
> display string;
> ls_display =
> dw_1.describe("evaluate('lookupdisplay(column)',row)")
>
> some other column from the drop down;
> datawindowchild ldwc
> long ll_row
> dw_1.getchild('column', ldwc)
> ll_row = ldwc.find('<data_column> =
> '+string(dw_1.object.column[row])) ldwc.getitem<XXX>(row,
> 'some_other_column')

Thank you! This was a great help.