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.

Describe/Modify Height Expression of Computed Field

2 posts in DataWindow Last posting was on 2009-05-06 16:19:15.0Z
Seth Katz Posted on 2009-04-21 06:31:11.0Z
Sender: 209a.49ed62ad.1804289383@sybase.com
From: Seth Katz
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Describe/Modify Height Expression of Computed Field
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49ed682f.20f7.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Apr 2009 23:31:11 -0700
X-Trace: forums-1-dub 1240295471 10.22.241.41 (20 Apr 2009 23:31:11 -0700)
X-Original-Trace: 20 Apr 2009 23:31:11 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89182
Article PK: 418437

How can I modify the height expression of a computed field
on a grid datawindow (and then set it back) at runtime? The
height is set to the height of all the columns on the grid
(64), with rowheight() as the expression.

When the datawindow is saved in HTMLTable format (as part of
our routine to open the datawindow in Excel), this height
expression results in a blank row between datawindow rows.
Using Describe gets only the height value, not the
expression.

Is there a way to get the height (including the expression),
remove the expression (then save in HTMLTable format), then
reset the expression as it was originally? Thanks in
advance.


"John Olson [Team Sybase]" <john.olson Posted on 2009-05-06 16:19:15.0Z
From: "John Olson [Team Sybase]" <john.olson@nospam_teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49ed682f.20f7.1681692777@sybase.com>
Subject: Re: Describe/Modify Height Expression of Computed Field
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a01b883$1@forums-1-dub>
Date: 6 May 2009 09:19:15 -0700
X-Trace: forums-1-dub 1241626755 10.22.241.152 (6 May 2009 09:19:15 -0700)
X-Original-Trace: 6 May 2009 09:19:15 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89247
Article PK: 418498

One way to get what you need is to have a separate DW which shares data with
your current DW. In the second DW you'd set all the properties specifically
so that the HTMLTable will be generated the way you want. Use the second one
to generate the HTMLTable. The second DW would typically be hidden from the
user.

Regards,
John

<Seth Katz> wrote in message news:49ed682f.20f7.1681692777@sybase.com...
> How can I modify the height expression of a computed field
> on a grid datawindow (and then set it back) at runtime? The
> height is set to the height of all the columns on the grid
> (64), with rowheight() as the expression.
>
> When the datawindow is saved in HTMLTable format (as part of
> our routine to open the datawindow in Excel), this height
> expression results in a blank row between datawindow rows.
> Using Describe gets only the height value, not the
> expression.
>
> Is there a way to get the height (including the expression),
> remove the expression (then save in HTMLTable format), then
> reset the expression as it was originally? Thanks in
> advance.