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.

this.getItemNumber Problem

6 posts in Appeon (partner product) Last posting was on 2012-03-06 21:00:15.0Z
Jay Posted on 2012-03-05 14:39:44.0Z
Sender: 441b.4f54cf48.1804289383@sybase.com
From: jay
Newsgroups: sybase.public.appeon
Subject: this.getItemNumber Problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f54d030.4444.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Mar 2012 06:39:44 -0800
X-Trace: forums-1-dub 1330958384 172.20.134.41 (5 Mar 2012 06:39:44 -0800)
X-Original-Trace: 5 Mar 2012 06:39:44 -0800, 172.20.134.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2923
Article PK: 21950

When following code runs in the PowerBuilder application,
the IF Condition does not become true (and that's what it's
supposed to be), but in the Appeon Web application, the IF
condition always become true. Why this become true in the
web application? Is there something which is not being
supported by the appeon ?


integer li_test
li_test = this.getItemNumber(row, 1)

IF li_test<>long(data) AND li_test<>0 THEN
this.setItem(row, 1, li_test)
RETURN 1
END IF

I tried to see what value li_test gets by printing in
messagebox for example messagebox("test", li_test) but it
does not display the messagebox at all in the Powerbuilder
or either in the web application. Why is that so?


Thanks for the great support.


Jay Posted on 2012-03-05 15:02:08.0Z
Sender: 441b.4f54cf48.1804289383@sybase.com
From: jay
Newsgroups: sybase.public.appeon
Subject: Re: this.getItemNumber Problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f54d570.450f.1681692777@sybase.com>
References: <4f54d030.4444.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Mar 2012 07:02:08 -0800
X-Trace: forums-1-dub 1330959728 172.20.134.41 (5 Mar 2012 07:02:08 -0800)
X-Original-Trace: 5 Mar 2012 07:02:08 -0800, 172.20.134.41
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2924
Article PK: 21951

Regarding my previous message, In my Powerbuilder
application, I get the variable value by following:

messagebox("test value", long(li_test))

But in the Appeon web application, it does not display the
messagebox. So I have understood that the problem is
somewhere with the getItemNumber. Can someone suggest me how
to solve it. Thanks
PS. Im using the newer version of PFC, Anywhere and
PowerBuilder.

> When following code runs in the PowerBuilder application,
> the IF Condition does not become true (and that's what
> it's supposed to be), but in the Appeon Web application,
> the IF condition always become true. Why this become true
> in the web application? Is there something which is not
> being supported by the appeon ?
>
>
> integer li_test
> li_test = this.getItemNumber(row, 1)
>
> IF li_test<>long(data) AND li_test<>0 THEN
> this.setItem(row, 1, li_test)
> RETURN 1
> END IF
>
> I tried to see what value li_test gets by printing in
> messagebox for example messagebox("test", li_test) but it
> does not display the messagebox at all in the Powerbuilder
> or either in the web application. Why is that so?
>
>
> Thanks for the great support.


Mike S Posted on 2012-03-05 17:02:57.0Z
From: "Mike S" <M@M.com>
Subject: Re: this.getItemNumber Problem
Newsgroups: sybase.public.appeon
References: <4f54d030.4444.1681692777@sybase.com> <4f54d570.450f.1681692777@sybase.com>
User-Agent: XanaNews/1.18.1.6
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f54f1c1$1@forums-1-dub>
Date: 5 Mar 2012 09:02:57 -0800
X-Trace: forums-1-dub 1330966977 10.22.241.152 (5 Mar 2012 09:02:57 -0800)
X-Original-Trace: 5 Mar 2012 09:02:57 -0800, vip152.sybase.com
Lines: 56
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2925
Article PK: 13659

is li_test null? is it greater than 32768?
in you code check for null:

if isnull(li_test) then messagebox('li_test is null', 'nul null')


also integer is not a long. i suggest always use longs and never
integers for your datatypes

jay wrote:

> Regarding my previous message, In my Powerbuilder
> application, I get the variable value by following:
>
> messagebox("test value", long(li_test))
>
> But in the Appeon web application, it does not display the
> messagebox. So I have understood that the problem is
> somewhere with the getItemNumber. Can someone suggest me how
> to solve it. Thanks
> PS. Im using the newer version of PFC, Anywhere and
> PowerBuilder.
>
>
>
> > When following code runs in the PowerBuilder application,
> > the IF Condition does not become true (and that's what
> > it's supposed to be), but in the Appeon Web application,
> > the IF condition always become true. Why this become true
> > in the web application? Is there something which is not
> > being supported by the appeon ?
> >
> >
> > integer li_test
> > li_test = this.getItemNumber(row, 1)
> >
> > IF li_test<>long(data) AND li_test<>0 THEN
> > this.setItem(row, 1, li_test)
> > RETURN 1
> > END IF
> >
> > I tried to see what value li_test gets by printing in
> > messagebox for example messagebox("test", li_test) but it
> > does not display the messagebox at all in the Powerbuilder
> > or either in the web application. Why is that so?
> >
> >
> > Thanks for the great support.

--


Jay Posted on 2012-03-06 07:00:30.0Z
Sender: 441b.4f54cf48.1804289383@sybase.com
From: jay
Newsgroups: sybase.public.appeon
Subject: Re: this.getItemNumber Problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f55b60e.665d.1681692777@sybase.com>
References: <4f54f1c1$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Mar 2012 23:00:30 -0800
X-Trace: forums-1-dub 1331017230 172.20.134.41 (5 Mar 2012 23:00:30 -0800)
X-Original-Trace: 5 Mar 2012 23:00:30 -0800, 172.20.134.41
Lines: 86
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2926
Article PK: 21955

Thank you for your answer. Please see below:

if isnull(li_test) then
messagebox("li_test is null", "null null") //this
condition becomes true in PB and Web
else
messagebox("li_test is not null", "not null")
end if

messagebox("value of li_test", li_test) //does not display
messagebox in PB and web
messagebox("value of long data", long(data)) //gets value
99 in PB and web

IF li_test <> long(data) then
messagebox("li_test is not equal to data", "first: li_test
is not equal to data") //becomes true in WEB
else
messagebox("equal to data", "second: li_test is equal to
data") //Becomes true in PB
end if

Please tell me what I'm doing wrong? Why the if part is
being true in the web and else part in the PB?
Thanks.

> is li_test null? is it greater than 32768?
> in you code check for null:
>
> if isnull(li_test) then messagebox('li_test is null', 'nul
> null')
>
>
> also integer is not a long. i suggest always use longs
> and never integers for your datatypes
>
>
>
> jay wrote:
>
> > Regarding my previous message, In my Powerbuilder
> > application, I get the variable value by following:
> >
> > messagebox("test value", long(li_test))
> >
> > But in the Appeon web application, it does not display
> > the messagebox. So I have understood that the problem is
> > somewhere with the getItemNumber. Can someone suggest me
> > how to solve it. Thanks
> > PS. Im using the newer version of PFC, Anywhere and
> > PowerBuilder.
> >
> >
> >
> > > When following code runs in the PowerBuilder
> > > application, the IF Condition does not become true
> > > (and that's what it's supposed to be), but in the
> > > Appeon Web application, the IF condition always become
> > > true. Why this become true in the web application? Is
> > > there something which is not being supported by the
> > > appeon ?
> > >
> > > integer li_test
> > > li_test = this.getItemNumber(row, 1)
> > >
> > > IF li_test<>long(data) AND li_test<>0 THEN
> > > this.setItem(row, 1, li_test)
> > > RETURN 1
> > > END IF
> > >
> > > I tried to see what value li_test gets by printing in
> > > messagebox for example messagebox("test", li_test) but
> > > it does not display the messagebox at all in the
> > > Powerbuilder or either in the web application. Why is
> > > that so?
> > >
> > > Thanks for the great support.
>
>
>
> --
>


Mike S Posted on 2012-03-06 21:00:15.0Z
From: "Mike S" <M@M.com>
Subject: Re: this.getItemNumber Problem
Newsgroups: sybase.public.appeon
References: <4f54f1c1$1@forums-1-dub> <4f55b60e.665d.1681692777@sybase.com>
User-Agent: XanaNews/1.18.1.6
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f567adf@forums-1-dub>
Date: 6 Mar 2012 13:00:15 -0800
X-Trace: forums-1-dub 1331067615 10.22.241.152 (6 Mar 2012 13:00:15 -0800)
X-Original-Trace: 6 Mar 2012 13:00:15 -0800, vip152.sybase.com
Lines: 100
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2928
Article PK: 21954

appeon handles nulls differently.

you must test for nulls separately in your code.

check the document link that leonardo provided

jay wrote:

> Thank you for your answer. Please see below:
>
> if isnull(li_test) then
> messagebox("li_test is null", "null null") //this
> condition becomes true in PB and Web
> else
> messagebox("li_test is not null", "not null")
> end if
>
> messagebox("value of li_test", li_test) //does not display
> messagebox in PB and web
> messagebox("value of long data", long(data)) //gets value
> 99 in PB and web
>
> IF li_test <> long(data) then
> messagebox("li_test is not equal to data", "first: li_test
> is not equal to data") //becomes true in WEB
> else
> messagebox("equal to data", "second: li_test is equal to
> data") //Becomes true in PB
> end if
>
> Please tell me what I'm doing wrong? Why the if part is
> being true in the web and else part in the PB?
> Thanks.
>
>
>
>
>
> > is li_test null? is it greater than 32768?
> > in you code check for null:
> >
> > if isnull(li_test) then messagebox('li_test is null', 'nul
> > null')
> >
> >
> > also integer is not a long. i suggest always use longs
> > and never integers for your datatypes
> >
> >
> >
> > jay wrote:
> >
> > > Regarding my previous message, In my Powerbuilder
> > > application, I get the variable value by following:
> > >
> > > messagebox("test value", long(li_test))
> > >
> > > But in the Appeon web application, it does not display
> > > the messagebox. So I have understood that the problem is
> > > somewhere with the getItemNumber. Can someone suggest me
> > > how to solve it. Thanks
> > > PS. Im using the newer version of PFC, Anywhere and
> > > PowerBuilder.
> > >
> > >
> > >
> > > > When following code runs in the PowerBuilder
> > > > application, the IF Condition does not become true
> > > > (and that's what it's supposed to be), but in the
> > > > Appeon Web application, the IF condition always become
> > > > true. Why this become true in the web application? Is
> > > > there something which is not being supported by the
> > > > appeon ?
> > > >
> > > > integer li_test
> > > > li_test = this.getItemNumber(row, 1)
> > > >
> > > > IF li_test<>long(data) AND li_test<>0 THEN
> > > > this.setItem(row, 1, li_test)
> > > > RETURN 1
> > > > END IF
> > > >
> > > > I tried to see what value li_test gets by printing in
> > > > messagebox for example messagebox("test", li_test) but
> > > > it does not display the messagebox at all in the
> > > > Powerbuilder or either in the web application. Why is
> > > > that so?
> > > >
> > > > Thanks for the great support.
> >
> >
> >
> > --
> >

--