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.

Null Values

4 posts in Appeon (partner product) Last posting was on 2004-07-13 18:47:57.0Z
Jose Avalos Posted on 2004-07-02 14:27:54.0Z
Sender: 62ac.40e48bb2.1804289383@sybase.com
From: Jose Avalos
Newsgroups: sybase.public.appeon
Subject: Null Values
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40e57194.6bf7.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 2 Jul 2004 07:30:44 -0700, 10.22.241.42
Lines: 23
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Jul 2004 07:23:04 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Jul 2004 07:27:54 -0700
X-Trace: forums-1-dub 1088778474 10.22.108.75 (2 Jul 2004 07:27:54 -0700)
X-Original-Trace: 2 Jul 2004 07:27:54 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:309
Article PK: 12476

When execute the next statement in a report:

string ls_null
date ld_null
integer li_null

setnull(ls_null)
setnull(ld_null)
setnull(li_null)
dw_maestro.retrieve(ls_null, li_null , ld_null)

The report dont work, but when i change the datawindows
parameters without the li_null parameter by :
dw_maestro.retrieve(ls_null, ld_null)

That work very well, other solution that i execute is to
change the parameter type from integer to string , and i
change the SQL statement from datawindow with the
"to_number", from oracle, but my system have many "SELECT",
and it take us a lot of time, please giveme other solution
with less work.

Thanks


Rex Geissler Posted on 2004-07-08 22:42:10.0Z
From: "Rex Geissler" <Rex.Geissler@sybase.com>
Newsgroups: sybase.public.appeon
References: <40e57194.6bf7.1681692777@sybase.com>
Subject: Re: Null Values
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: rgeisslew2k.sybase.com
Message-ID: <40edce84$1@forums-2-dub>
X-Original-Trace: 8 Jul 2004 15:45:24 -0700, rgeisslew2k.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Jul 2004 15:36:44 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Jul 2004 15:42:10 -0700
X-Trace: forums-1-dub 1089326530 10.22.108.75 (8 Jul 2004 15:42:10 -0700)
X-Original-Trace: 8 Jul 2004 15:42:10 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:315
Article PK: 12480

Hi Jose,

I don't understand. Can you provide more detail? Are you sure this is an
Appeon question or just a straight PowerBuilder question or a database SQL
question?

Thanks, Rex

<Jose Avalos> wrote in message news:40e57194.6bf7.1681692777@sybase.com...
> When execute the next statement in a report:
>
> string ls_null
> date ld_null
> integer li_null
>
> setnull(ls_null)
> setnull(ld_null)
> setnull(li_null)
> dw_maestro.retrieve(ls_null, li_null , ld_null)
>
> The report dont work, but when i change the datawindows
> parameters without the li_null parameter by :
> dw_maestro.retrieve(ls_null, ld_null)
>
> That work very well, other solution that i execute is to
> change the parameter type from integer to string , and i
> change the SQL statement from datawindow with the
> "to_number", from oracle, but my system have many "SELECT",
> and it take us a lot of time, please giveme other solution
> with less work.
>
> Thanks


Rex Geissler Posted on 2004-07-13 18:47:57.0Z
From: "Rex Geissler" <Rex.Geissler@sybase.com>
Newsgroups: sybase.public.appeon
References: <40edce84$1@forums-2-dub> <40eedd79.4b00.1681692777@sybase.com>
Subject: Re: Null Values
Lines: 76
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: rgeisslew2k.sybase.com
X-Original-NNTP-Posting-Host: rgeisslew2k.sybase.com
Message-ID: <40f42e5d$1@forums-1-dub>
Date: 13 Jul 2004 11:47:57 -0700
X-Trace: forums-1-dub 1089744477 10.20.20.145 (13 Jul 2004 11:47:57 -0700)
X-Original-Trace: 13 Jul 2004 11:47:57 -0700, rgeisslew2k.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:321
Article PK: 20687

Hi Jose,

I suggest that you try Appeon 2.8 in August because we have not seen this
issue in testing it and have changed some of the mechanisms for Retrieving
DataWindows. Also, here is the updated Appeon Help for Null values.


Null values

Supported

NULL means undefined or unknown. It is not the same as an empty string or
zero or a date of 0000-00-00. For example, NULL is neither 0 nor "" (empty
string).

Null in PowerBuilder is directly translated into Null in JavaScript.


Unsupported

Expressions involving Null values may arrive at different values in
JavaScript from their values in PowerScript. For example, the expression A +
B in PowerScript will return Null if any of A or B is Null.

Regards, Rex

<Jose Avalos> wrote in message news:40eedd79.4b00.1681692777@sybase.com...
> Hi,
> I told that i cant use the integer null values in appeon,
> when i pass a integer null values to report that dont work.
> In the Power Builder Application work but when i migrate to
> appeon, that dont work. The solution that i have is to
> change the integer null value to string null values and
> change all the SQL after that i migrate to appeon, too.
>
> Thanks
>
>
> > Hi Jose,
> >
> > I don't understand. Can you provide more detail? Are you
> > sure this is an Appeon question or just a straight
> > PowerBuilder question or a database SQL question?
> >
> > Thanks, Rex
> >
> >
> > <Jose Avalos> wrote in message
> > > news:40e57194.6bf7.1681692777@sybase.com... When execute
> > the next statement in a report: >
> > > string ls_null
> > > date ld_null
> > > integer li_null
> > >
> > > setnull(ls_null)
> > > setnull(ld_null)
> > > setnull(li_null)
> > > dw_maestro.retrieve(ls_null, li_null , ld_null)
> > >
> > > The report dont work, but when i change the datawindows
> > > parameters without the li_null parameter by :
> > > dw_maestro.retrieve(ls_null, ld_null)
> > >
> > > That work very well, other solution that i execute is to
> > > change the parameter type from integer to string , and i
> > > change the SQL statement from datawindow with the
> > > "to_number", from oracle, but my system have many
> > > "SELECT", and it take us a lot of time, please giveme
> > > other solution with less work.
> > >
> > > Thanks
> >
> >