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 dynamically change DW column type

3 posts in DataWindow Last posting was on 2009-11-30 01:37:25.0Z
SamRam Posted on 2009-11-26 15:55:34.0Z
Sender: 4425.4b0cae90.1804289383@sybase.com
From: SamRam
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: How to dynamically change DW column type
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b0ea4f6.324f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Nov 2009 07:55:34 -0800
X-Trace: forums-1-dub 1259250934 10.22.241.41 (26 Nov 2009 07:55:34 -0800)
X-Original-Trace: 26 Nov 2009 07:55:34 -0800, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90354
Article PK: 409959

Using PB9.
***DW2 is defined with multiple edit stype columns.
***DW1 data requires me to programatically change in DW2 a
column's edit style from "Edit" to "DropDownDW" and assign
to it a predefined dropdown datawindow object, and of couse,
also specify the dddw's attributes such as display column,
data column, vScrollBar, etc, etc.
***How can I programmatically alter the DW2 column so it can
become a functioning DDDW instead of an EDIT stype column?


Scott Morris Posted on 2009-11-27 13:06:26.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b0ea4f6.324f.1681692777@sybase.com>
Subject: Re: How to dynamically change DW column type
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b0fced2$1@forums-1-dub>
Date: 27 Nov 2009 05:06:26 -0800
X-Trace: forums-1-dub 1259327186 10.22.241.152 (27 Nov 2009 05:06:26 -0800)
X-Original-Trace: 27 Nov 2009 05:06:26 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90359
Article PK: 409962


<SamRam> wrote in message news:4b0ea4f6.324f.1681692777@sybase.com...
> Using PB9.
> ***DW2 is defined with multiple edit stype columns.
> ***DW1 data requires me to programatically change in DW2 a
> column's edit style from "Edit" to "DropDownDW" and assign
> to it a predefined dropdown datawindow object, and of couse,
> also specify the dddw's attributes such as display column,
> data column, vScrollBar, etc, etc.
> ***How can I programmatically alter the DW2 column so it can
> become a functioning DDDW instead of an EDIT stype column?

The datawindow syntax tool within the IDE will show you the appropriate
syntax - examples have been posted to the newsgroups in the past. Perhaps
an easier approach is to simply add multiple column objects to the
datawindow associated with the column in question. Define one as the dddw
and the other as the edit. Simply turn visibility on/off as needed.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-11-30 01:37:25.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b0ea4f6.324f.1681692777@sybase.com> <4b0fced2$1@forums-1-dub>
Subject: Re: How to dynamically change DW column type
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b1321d5$1@forums-1-dub>
Date: 29 Nov 2009 17:37:25 -0800
X-Trace: forums-1-dub 1259545045 10.22.241.152 (29 Nov 2009 17:37:25 -0800)
X-Original-Trace: 29 Nov 2009 17:37:25 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90364
Article PK: 409969

IIRC the minimum would be dddw.name, dddw.datacolumn, dddw.displaycolumn.
You may want to use more to get a nice GUI.

--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Scott Morris" <bogus@bogus.com> wrote in message
news:4b0fced2$1@forums-1-dub...
> <SamRam> wrote in message news:4b0ea4f6.324f.1681692777@sybase.com...
>> Using PB9.
>> ***DW2 is defined with multiple edit stype columns.
>> ***DW1 data requires me to programatically change in DW2 a
>> column's edit style from "Edit" to "DropDownDW" and assign
>> to it a predefined dropdown datawindow object, and of couse,
>> also specify the dddw's attributes such as display column,
>> data column, vScrollBar, etc, etc.
>> ***How can I programmatically alter the DW2 column so it can
>> become a functioning DDDW instead of an EDIT stype column?
>
> The datawindow syntax tool within the IDE will show you the appropriate
> syntax - examples have been posted to the newsgroups in the past. Perhaps
> an easier approach is to simply add multiple column objects to the
> datawindow associated with the column in question. Define one as the dddw
> and the other as the edit. Simply turn visibility on/off as needed.
>