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.

Invalid Datawindow Row Column specified at retrieve end event.

3 posts in DataWindow Last posting was on 2009-12-11 08:46:37.0Z
Rolando Giron Posted on 2009-12-10 01:08:49.0Z
Sender: 2e22.4b204888.1804289383@sybase.com
From: Rolando Giron
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Invalid Datawindow Row Column specified at retrieve end event.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b204a21.2e63.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Dec 2009 17:08:49 -0800
X-Trace: forums-1-dub 1260407329 10.22.241.41 (9 Dec 2009 17:08:49 -0800)
X-Original-Trace: 9 Dec 2009 17:08:49 -0800, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90420
Article PK: 410024

Hi,

I'm using PB10.5 Ent. I have a grid datawindow and in the
RetrieveEnd event I have the following code. The
OrderNumExists is a boolean variable to verify that the
column ordernum indeed exists in that datawindow. The
variable isTree I use it to identify a treeview datawindow.

IF RowCount = 1 AND OrderNumExists AND isTree = FALSE THEN
il_OrderNum = dw_uo.object.ordernum[RowCount]

This code gives me the error, the column exists and there
were rows retrieved. I also tried using the getItemNumber()
and got the same error.

I can get the value of the column from other functions or
event but this one and I'm stompped.

Any help???


Scott Morris Posted on 2009-12-10 13:13:51.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b204a21.2e63.1681692777@sybase.com>
Subject: Re: Invalid Datawindow Row Column specified at retrieve end event.
Lines: 22
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: <4b20f40f$1@forums-1-dub>
Date: 10 Dec 2009 05:13:51 -0800
X-Trace: forums-1-dub 1260450831 10.22.241.152 (10 Dec 2009 05:13:51 -0800)
X-Original-Trace: 10 Dec 2009 05:13:51 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90421
Article PK: 410025


<Rolando Giron> wrote in message news:4b204a21.2e63.1681692777@sybase.com...
> Hi,
>
> I'm using PB10.5 Ent. I have a grid datawindow and in the
> RetrieveEnd event I have the following code. The
> OrderNumExists is a boolean variable to verify that the
> column ordernum indeed exists in that datawindow. The
> variable isTree I use it to identify a treeview datawindow.
>
> IF RowCount = 1 AND OrderNumExists AND isTree = FALSE THEN
> il_OrderNum = dw_uo.object.ordernum[RowCount]

It is generally a bad approach to use the variable (defined/known in the
window) name to refer to the object within the object's own functions and
events. Replace "dw_uo" with "this". If that does not help, then I would
first verify that the rowcount variable passed to the event is correct (i.e.
rowcount actually equal this.rowcount() ) and that ordernum actually exists
as a column (use this.Describe("DataWindow.Objects") to get the list of
objects and find the column in the returned list).


Jeremy Lakeman Posted on 2009-12-11 08:46:37.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Invalid Datawindow Row Column specified at retrieve end event.
Date: Fri, 11 Dec 2009 00:46:37 -0800 (PST)
Organization: http://groups.google.com
Lines: 27
Message-ID: <902edd9e-8345-4138-908f-80cfd1bc8ab0@u25g2000prh.googlegroups.com>
References: <4b204a21.2e63.1681692777@sybase.com> <4b20f40f$1@forums-1-dub>
NNTP-Posting-Host: 122.49.175.125
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1260521197 23833 127.0.0.1 (11 Dec 2009 08:46:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 11 Dec 2009 08:46:37 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: u25g2000prh.googlegroups.com; posting-host=122.49.175.125; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 (.NET CLR 3.5.30729),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:90426
Article PK: 410030


On Dec 10, 11:13 pm, "Scott Morris" <bo...@bogus.com> wrote:
> <Rolando Giron> wrote in messagenews:4b204a21.2e63.1681692777@sybase.com...
> > Hi,
>
> > I'm using PB10.5 Ent. I have a grid datawindow and in the
> > RetrieveEnd event I have the following code. The
> > OrderNumExists is a boolean variable to verify that the
> > column ordernum indeed exists in that datawindow. The
> > variable isTree I use it to identify a treeview datawindow.
>
> > IF RowCount = 1 AND OrderNumExists AND isTree = FALSE THEN
> > il_OrderNum = dw_uo.object.ordernum[RowCount]
>
> It is generally a bad approach to use the variable (defined/known in the
> window) name to refer to the object within the object's own functions and
> events.  Replace "dw_uo" with "this".  If that does not help, then I would
> first verify that the rowcount variable passed to the event is correct (i.e.
> rowcount actually equal this.rowcount() ) and that ordernum actually exists
> as a column (use this.Describe("DataWindow.Objects") to get the list of
> objects and find the column in the returned list).

And that there is no filter applied to the datawindow. (there might be
a row retrieved, but there may not be a row in the primary buffer)