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.

Way to get Original value of the field into computed field

6 posts in DataWindow Last posting was on 2009-12-07 19:56:42.0Z
Sravan Posted on 2009-12-03 17:03:49.0Z
From: Sravan <sr.100102@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Way to get Original value of the field into computed field
Date: Thu, 3 Dec 2009 09:03:49 -0800 (PST)
Organization: http://groups.google.com
Lines: 7
Message-ID: <121a4797-cc11-4927-8613-ba3f69a6e009@e31g2000vbm.googlegroups.com>
NNTP-Posting-Host: 199.90.35.11
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1259859829 19934 127.0.0.1 (3 Dec 2009 17:03:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Dec 2009 17:03:49 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: e31g2000vbm.googlegroups.com; posting-host=199.90.35.11; posting-account=UTzE8QoAAAC3nYtUFSzhmOMS6rL8Ql2h
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1),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!postnews.google.com!e31g2000vbm.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90391
Article PK: 410001

Hello,
My Environment is PB10. Is there any way to get the orinal value
(Similar to the Original buffer value in olden days) of the field into
computed field.

Thanks,
Sra


Scott Morris Posted on 2009-12-03 17:20:04.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <121a4797-cc11-4927-8613-ba3f69a6e009@e31g2000vbm.googlegroups.com>
Subject: Re: Way to get Original value of the field into computed field
Lines: 10
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: <4b17f344$1@forums-1-dub>
Date: 3 Dec 2009 09:20:04 -0800
X-Trace: forums-1-dub 1259860804 10.22.241.152 (3 Dec 2009 09:20:04 -0800)
X-Original-Trace: 3 Dec 2009 09:20:04 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90392
Article PK: 409992


"Sravan" <sr.100102@gmail.com> wrote in message
news:121a4797-cc11-4927-8613-ba3f69a6e009@e31g2000vbm.googlegroups.com...
> Hello,
> My Environment is PB10. Is there any way to get the orinal value
> (Similar to the Original buffer value in olden days) of the field into
> computed field.

Just add ".original" to the column name. E.g., transaction_date.original


Sravan Posted on 2009-12-07 16:16:00.0Z
From: Sravan <sr.100102@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Way to get Original value of the field into computed field
Date: Mon, 7 Dec 2009 08:16:00 -0800 (PST)
Organization: http://groups.google.com
Lines: 1
Message-ID: <86ad05e9-d997-40cc-8dd9-bb546537e166@f16g2000yqm.googlegroups.com>
References: <121a4797-cc11-4927-8613-ba3f69a6e009@e31g2000vbm.googlegroups.com> <4b17f344$1@forums-1-dub>
NNTP-Posting-Host: 199.90.35.11
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1260202560 3024 127.0.0.1 (7 Dec 2009 16:16:00 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 7 Dec 2009 16:16:00 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f16g2000yqm.googlegroups.com; posting-host=199.90.35.11; posting-account=UTzE8QoAAAC3nYtUFSzhmOMS6rL8Ql2h
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1),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!postnews.google.com!f16g2000yqm.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90409
Article PK: 410014

Can some body help me out on this.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-07 16:44:46.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <121a4797-cc11-4927-8613-ba3f69a6e009@e31g2000vbm.googlegroups.com> <4b17f344$1@forums-1-dub> <86ad05e9-d997-40cc-8dd9-bb546537e166@f16g2000yqm.googlegroups.com>
Subject: Re: Way to get Original value of the field into computed field
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: <4b1d30fe$1@forums-1-dub>
Date: 7 Dec 2009 08:44:46 -0800
X-Trace: forums-1-dub 1260204286 10.22.241.152 (7 Dec 2009 08:44:46 -0800)
X-Original-Trace: 7 Dec 2009 08:44:46 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90410
Article PK: 410015

What Scott said.
For instance if you wanted to see if the column value has changed, if
(my_column = my_column.original, <true>, <false>)
Note that if you have not called AcceptText the value may be in the edit
control, so you would need GetText() instead of the column name.
Or were you trying to accomplish something completely different?

--
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

"Sravan" <sr.100102@gmail.com> wrote in message
news:86ad05e9-d997-40cc-8dd9-bb546537e166@f16g2000yqm.googlegroups.com...
> Can some body help me out on this.


Sravan Posted on 2009-12-07 19:23:43.0Z
From: Sravan <sr.100102@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Way to get Original value of the field into computed field
Date: Mon, 7 Dec 2009 11:23:43 -0800 (PST)
Organization: http://groups.google.com
Lines: 5
Message-ID: <ae48bd0b-be97-4d90-936b-c7f89e493718@u25g2000prh.googlegroups.com>
References: <121a4797-cc11-4927-8613-ba3f69a6e009@e31g2000vbm.googlegroups.com> <4b17f344$1@forums-1-dub> <86ad05e9-d997-40cc-8dd9-bb546537e166@f16g2000yqm.googlegroups.com> <4b1d30fe$1@forums-1-dub>
NNTP-Posting-Host: 199.90.35.11
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1260213823 5171 127.0.0.1 (7 Dec 2009 19:23:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 7 Dec 2009 19:23:43 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: u25g2000prh.googlegroups.com; posting-host=199.90.35.11; posting-account=UTzE8QoAAAC3nYtUFSzhmOMS6rL8Ql2h
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1),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!postnews.google.com!u25g2000prh.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90413
Article PK: 410016

Thanks for the reply.I am just wondering that Does PB10 supports
gives the originial value of my_column if we use
"my_column.original".
I have tried it, my_column.original gives the current value of
my_column. I ammissing some thing??


Scott Morris Posted on 2009-12-07 19:56:42.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <121a4797-cc11-4927-8613-ba3f69a6e009@e31g2000vbm.googlegroups.com> <4b17f344$1@forums-1-dub> <86ad05e9-d997-40cc-8dd9-bb546537e166@f16g2000yqm.googlegroups.com> <4b1d30fe$1@forums-1-dub> <ae48bd0b-be97-4d90-936b-c7f89e493718@u25g2000prh.googlegroups.com>
Subject: Re: Way to get Original value of the field into computed field
Lines: 73
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: <4b1d5dfa$1@forums-1-dub>
Date: 7 Dec 2009 11:56:42 -0800
X-Trace: forums-1-dub 1260215802 10.22.241.152 (7 Dec 2009 11:56:42 -0800)
X-Original-Trace: 7 Dec 2009 11:56:42 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90414
Article PK: 410018


"Sravan" <sr.100102@gmail.com> wrote in message
news:ae48bd0b-be97-4d90-936b-c7f89e493718@u25g2000prh.googlegroups.com...
> Thanks for the reply.I am just wondering that Does PB10 supports
> gives the originial value of my_column if we use
> "my_column.original".
> I have tried it, my_column.original gives the current value of
> my_column. I ammissing some thing??

Been using it since PB7. Apparently you must be missing something, but what
that is cannot be determined from a distance without any other information.
Try the datawindow export below (adjust for wrapping!) - notice the 2
computed fields and their expressions. Import it and use the preview pane
in the datawindow painter to view the code in action.


$PBExportHeader$d_test.srd
release 11;
datawindow(units=0 timer_interval=0 color=1073741824 processing=0 HTMLDW=no
print.printername="" print.documentname="" print.orientation = 0
print.margin.left = 110 print.margin.right = 110 print.margin.top = 96
print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0
print.canusedefaultprinter=yes print.prompt=no print.buttons=no
print.preview.buttons=no print.cliptext=no print.overrideprintjob=no
print.collate=yes print.preview.outline=yes hidegrayline=no
showbackcoloronxp=no )
header(height=72 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=248 color="536870912" )
table(column=(type=char(10) updatewhereclause=yes name=mycolumn
dbname="mycolumn" )
)
data("Fred","Barney","Wilma","Betty",)
text(band=detail alignment="2" text="Mycolumn:" border="0" color="33554432"
x="18" y="44" height="64" width="375" html.valueishtml="0" name=mycolumn_t
visible="1" font.face="Arial" font.height="-10" font.weight="400"
font.family="2" font.pitch="2" font.charset="0" background.mode="1"
background.color="536870912" )
column(band=detail id=1 alignment="0" tabsequence=10 border="5"
color="33554432" x="425" y="44" height="76" width="416" format="[general]"
html.valueishtml="0" name=mycolumn visible="1" edit.limit=0 edit.case=any
edit.autoselect=yes edit.autohscroll=yes font.face="Arial"
font.height="-10" font.weight="400" font.family="2" font.pitch="2"
font.charset="0" background.mode="1" background.color="536870912" )
compute(band=detail alignment="0" expression="~"Current value: ~" + mycolumn
"border="0" color="33554432" x="997" y="8" height="64" width="617"
format="[GENERAL]" html.valueishtml="0" name=compute_1 visible="1"
font.face="Arial" font.height="-10" font.weight="400" font.family="2"
font.pitch="2" font.charset="0" background.mode="1"
background.color="536870912" )
compute(band=detail alignment="0" expression="~"Original value: ~" +
mycolumn.original"border="0" color="33554432" x="997" y="92" height="64"
width="617" format="[GENERAL]" html.valueishtml="0" name=compute_2
visible="1" font.face="Arial" font.height="-10" font.weight="400"
font.family="2" font.pitch="2" font.charset="0" background.mode="1"
background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1"
clientformatting="0" clientscriptable="0" generatejavascript="1"
encodeselflinkargs="1" netscapelayers="0" pagingmethod=0
generatedddwframes="1" )
xhtmlgen() cssgen(sessionspecific="0" )
xmlgen(inline="0" )
xsltgen()
jsgen()
export.xml(headgroups="1" includewhitespace="0" metadatatype=0
savemetadata=0 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
export.xhtml()