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.

Property .original in Datawindow...

3 posts in Appeon (partner product) Last posting was on 2012-01-21 07:58:00.0Z
Alexey S Posted on 2012-01-20 14:38:25.0Z
Sender: 328d.4f19776f.1804289383@sybase.com
From: Alexey S
Newsgroups: sybase.public.appeon
Subject: Property .original in Datawindow...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f197c61.33a4.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub4f197c61"
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Jan 2012 06:38:25 -0800
X-Trace: forums-1-dub 1327070305 172.20.134.41 (20 Jan 2012 06:38:25 -0800)
X-Original-Trace: 20 Jan 2012 06:38:25 -0800, 172.20.134.41
Lines: 645
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2864
Article PK: 21921

Appeon 6.5.0202 is supports a property field.ORIGINAL in
Datawindow expression?
example expression:
if((port_in <>port_in.original),
rgb(255,224,224),rgb(255,255,0))

Expression_Datawindow.jpg

Steven Posted on 2012-01-21 03:07:00.0Z
Sender: 4e25.4f1a10a3.1804289383@sybase.com
From: steven
Newsgroups: sybase.public.appeon
Subject: Re: Property .original in Datawindow...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f1a2bd4.54d1.1681692777@sybase.com>
References: <4f197c61.33a4.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Jan 2012 19:07:00 -0800
X-Trace: forums-1-dub 1327115220 172.20.134.41 (20 Jan 2012 19:07:00 -0800)
X-Original-Trace: 20 Jan 2012 19:07:00 -0800, 172.20.134.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2865
Article PK: 13632

Hi,

Appeon can't support this expression, you can workaround
this issue as the following solution.
Add a alias column name use same column in datawindow, for
example:
SELECT port_in,
port_inas code_org
FROM fin_code
then you can use expression: if((port_in<>
code_org),rgb(255,224,224),rgb(255,255,0))

Regards,
Steven