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.

Datawindow Expressions

3 posts in DataWindow Last posting was on 2008-03-28 17:12:51.0Z
Jason Lipman Posted on 2008-03-27 21:38:36.0Z
From: "Jason Lipman" <NOSPAM-jlipman@oppenheimer>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Datawindow Expressions
Lines: 18
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.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ec13dc$1@forums-1-dub>
Date: 27 Mar 2008 13:38:36 -0800
X-Trace: forums-1-dub 1206653916 10.22.241.152 (27 Mar 2008 13:38:36 -0800)
X-Original-Trace: 27 Mar 2008 13:38:36 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86540
Article PK: 415800

PB 10.5

In a datawindow, I created expressions in the border and protect controls so
that when certain criteria is pulled from the database, I will put a square
border and/or protect the column. This works correctly on a row by row basis
as you would expect when the database is queried.

Problem: These expressions are still evaluated when data changes by the
user, thereby changing the border or protect values. I only want evaluation
at the time the database is queried.

How do I solve this problem?

Thank you!!

Jason Lipman


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-03-27 23:52:07.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47ec13dc$1@forums-1-dub>
Subject: Re: Datawindow Expressions
Lines: 25
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.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ec3327@forums-1-dub>
Date: 27 Mar 2008 15:52:07 -0800
X-Trace: forums-1-dub 1206661927 10.22.241.152 (27 Mar 2008 15:52:07 -0800)
X-Original-Trace: 27 Mar 2008 15:52:07 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86544
Article PK: 415804

It appears that you can use the .original specification as in dot notation
if (<columnname>.original = 'foo', 1, 2)
I tried this in 11.1, don't have 10.5 installed on this machine.

"Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
news:47ec13dc$1@forums-1-dub...
> PB 10.5
>
> In a datawindow, I created expressions in the border and protect controls
> so that when certain criteria is pulled from the database, I will put a
> square border and/or protect the column. This works correctly on a row by
> row basis as you would expect when the database is queried.
>
> Problem: These expressions are still evaluated when data changes by the
> user, thereby changing the border or protect values. I only want
> evaluation at the time the database is queried.
>
> How do I solve this problem?
>
> Thank you!!
>
> Jason Lipman
>


Jason Lipman Posted on 2008-03-28 17:12:51.0Z
From: "Jason Lipman" <NOSPAM-jlipman@oppenheimer>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47ec13dc$1@forums-1-dub> <47ec3327@forums-1-dub>
Subject: Re: Datawindow Expressions
Lines: 35
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.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ed2713$1@forums-1-dub>
Date: 28 Mar 2008 09:12:51 -0800
X-Trace: forums-1-dub 1206724371 10.22.241.152 (28 Mar 2008 09:12:51 -0800)
X-Original-Trace: 28 Mar 2008 09:12:51 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86565
Article PK: 415825

This works ! I did not even know about using .original.

Thanks, Jerry.

Jason Lipman

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:47ec3327@forums-1-dub...
> It appears that you can use the .original specification as in dot notation
> if (<columnname>.original = 'foo', 1, 2)
> I tried this in 11.1, don't have 10.5 installed on this machine.
>
> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
> news:47ec13dc$1@forums-1-dub...
>> PB 10.5
>>
>> In a datawindow, I created expressions in the border and protect controls
>> so that when certain criteria is pulled from the database, I will put a
>> square border and/or protect the column. This works correctly on a row by
>> row basis as you would expect when the database is queried.
>>
>> Problem: These expressions are still evaluated when data changes by the
>> user, thereby changing the border or protect values. I only want
>> evaluation at the time the database is queried.
>>
>> How do I solve this problem?
>>
>> Thank you!!
>>
>> Jason Lipman
>>
>
>