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.

Problem with 'sort' in datawindow

6 posts in Appeon (partner product) Last posting was on 2012-05-18 14:18:14.0Z
Jay Posted on 2012-05-16 13:35:53.0Z
Sender: 29de.4fb38dea.1804289383@sybase.com
From: jay
Newsgroups: sybase.public.appeon
Subject: Problem with 'sort' in datawindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fb3ad39.2d9e.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 16 May 2012 06:35:53 -0700
X-Trace: forums-1-dub 1337175353 172.20.134.41 (16 May 2012 06:35:53 -0700)
X-Original-Trace: 16 May 2012 06:35:53 -0700, 172.20.134.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2963
Article PK: 13677

Hello,
I have deployed a powerbuilder with Appeon. The deployed web
application has problems with the 'sort' which is used in
one of the datawindow. The datawindow has some code like

sort="column1 A column2 A column3 A"

group(by=("column1" ))
group(by=("column2" ))
group(by=("column3" ))

This displays the deta in right order in the desktop
application, but it gets totally messed up in the web
application.
Can someone please help me with this to make it compatible
with the Appeon.
Thanks.


Jay Posted on 2012-05-18 09:32:49.0Z
Sender: 90b.4fb613f9.1804289383@sybase.com
From: jay
Newsgroups: sybase.public.appeon
Subject: Re: Problem with 'sort' in datawindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fb61741.995.1681692777@sybase.com>
References: <4fb3ad39.2d9e.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 18 May 2012 02:32:49 -0700
X-Trace: forums-1-dub 1337333569 172.20.134.41 (18 May 2012 02:32:49 -0700)
X-Original-Trace: 18 May 2012 02:32:49 -0700, 172.20.134.41
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2966
Article PK: 13679

I have figured out that the problem is being caused by one
of the expression used in the datawindow. The expressions
is:

"if ( column1 = 0, 99, column1 )".

If I remove the if condition from the expression and use
only "column1" as expression, most of the problem is solved.
So how can I use this expression in appeon?
Thanks.

> Hello,
> I have deployed a powerbuilder with Appeon. The deployed
> web application has problems with the 'sort' which is used
> in one of the datawindow. The datawindow has some code
> like
>
> sort="column1 A column2 A column3 A"
>
> group(by=("column1" ))
> group(by=("column2" ))
> group(by=("column3" ))
>
> This displays the deta in right order in the desktop
> application, but it gets totally messed up in the web
> application.
> Can someone please help me with this to make it compatible
> with the Appeon.
> Thanks.


Mike S Posted on 2012-05-18 14:18:14.0Z
From: "Mike S" <M@M.com>
Subject: Re: Problem with 'sort' in datawindow
Newsgroups: sybase.public.appeon
References: <4fb3ad39.2d9e.1681692777@sybase.com> <4fb61741.995.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: <4fb65a26$1@forums-1-dub>
Date: 18 May 2012 07:18:14 -0700
X-Trace: forums-1-dub 1337350694 10.22.241.152 (18 May 2012 07:18:14 -0700)
X-Original-Trace: 18 May 2012 07:18:14 -0700, vip152.sybase.com
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2968
Article PK: 13678

can column1 be null?

jay wrote:

> I have figured out that the problem is being caused by one
> of the expression used in the datawindow. The expressions
> is:
>
> "if ( column1 = 0, 99, column1 )".
>
> If I remove the if condition from the expression and use
> only "column1" as expression, most of the problem is solved.
> So how can I use this expression in appeon?
> Thanks.
>
>
>
> > Hello,
> > I have deployed a powerbuilder with Appeon. The deployed
> > web application has problems with the 'sort' which is used
> > in one of the datawindow. The datawindow has some code
> > like
> >
> > sort="column1 A column2 A column3 A"
> >
> > group(by=("column1" ))
> > group(by=("column2" ))
> > group(by=("column3" ))
> >
> > This displays the deta in right order in the desktop
> > application, but it gets totally messed up in the web
> > application.
> > Can someone please help me with this to make it compatible
> > with the Appeon.
> > Thanks.

--


Chris Pollach Posted on 2012-05-18 12:16:14.0Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.appeon
Subject: Re: Problem with 'sort' in datawindow
References: <4fb3ad39.2d9e.1681692777@sybase.com> <4fb61741.995.1681692777@sybase.com>
In-Reply-To: <4fb61741.995.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fb63d8e$1@forums-1-dub>
Date: 18 May 2012 05:16:14 -0700
X-Trace: forums-1-dub 1337343374 10.22.241.152 (18 May 2012 05:16:14 -0700)
X-Original-Trace: 18 May 2012 05:16:14 -0700, vip152.sybase.com
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2967
Article PK: 13680

Can you tell us more about what you are trying to accomplish with that
expression?

On 5/18/2012 5:32 AM, jay wrote:
> I have figured out that the problem is being caused by one
> of the expression used in the datawindow. The expressions
> is:
>
> "if ( column1 = 0, 99, column1 )".
>
> If I remove the if condition from the expression and use
> only "column1" as expression, most of the problem is solved.
> So how can I use this expression in appeon?
> Thanks.
>
>
>
>> Hello,
>> I have deployed a powerbuilder with Appeon. The deployed
>> web application has problems with the 'sort' which is used
>> in one of the datawindow. The datawindow has some code
>> like
>>
>> sort="column1 A column2 A column3 A"
>>
>> group(by=("column1" ))
>> group(by=("column2" ))
>> group(by=("column3" ))
>>
>> This displays the deta in right order in the desktop
>> application, but it gets totally messed up in the web
>> application.
>> Can someone please help me with this to make it compatible
>> with the Appeon.
>> Thanks.


Chris Pollach Posted on 2012-05-16 16:05:31.0Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.appeon
Subject: Re: Problem with 'sort' in datawindow
References: <4fb3ad39.2d9e.1681692777@sybase.com>
In-Reply-To: <4fb3ad39.2d9e.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fb3d04b@forums-1-dub>
Date: 16 May 2012 09:05:31 -0700
X-Trace: forums-1-dub 1337184331 10.22.241.152 (16 May 2012 09:05:31 -0700)
X-Original-Trace: 16 May 2012 09:05:31 -0700, vip152.sybase.com
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2964
Article PK: 21973

Hi Jay;

Have tried doing a GroupCalc () command after the sort commands?

--
Regards ... Chris
President: OSUG / STD Inc.
Vice President: ISUG
Blog: http://chrispollach.blogspot.com
SourceForge: http://sourceforge.net/projects/stdfndclass
PBDJ: http://chrispollach.sys-con.com

On 5/16/2012 9:35 AM, jay wrote:
> Hello,
> I have deployed a powerbuilder with Appeon. The deployed web
> application has problems with the 'sort' which is used in
> one of the datawindow. The datawindow has some code like
>
> sort="column1 A column2 A column3 A"
>
> group(by=("column1" ))
> group(by=("column2" ))
> group(by=("column3" ))
>
> This displays the deta in right order in the desktop
> application, but it gets totally messed up in the web
> application.
> Can someone please help me with this to make it compatible
> with the Appeon.
> Thanks.


Jay Posted on 2012-05-17 06:05:26.0Z
Sender: 315f.4fb3ca9a.1804289383@sybase.com
From: jay
Newsgroups: sybase.public.appeon
Subject: Re: Problem with 'sort' in datawindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fb49526.4db8.1681692777@sybase.com>
References: <4fb3d04b@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 16 May 2012 23:05:26 -0700
X-Trace: forums-1-dub 1337234726 172.20.134.41 (16 May 2012 23:05:26 -0700)
X-Original-Trace: 16 May 2012 23:05:26 -0700, 172.20.134.41
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2965
Article PK: 21974

Hey Chris,
Thank you for your answer. Can you please give me an example
how to use GroupCalc or where I can find any documentation
about it? I cold not find.

Thanks again,
jay.

> Hi Jay;
>
> Have tried doing a GroupCalc () command after the sort
> commands?
>
> --
> Regards ... Chris
> President: OSUG / STD Inc.
> Vice President: ISUG
> Blog: http://chrispollach.blogspot.com
> SourceForge: http://sourceforge.net/projects/stdfndclass
> PBDJ: http://chrispollach.sys-con.com
>
>
> On 5/16/2012 9:35 AM, jay wrote:
> > Hello,
> > I have deployed a powerbuilder with Appeon. The deployed
> > web application has problems with the 'sort' which is
> > used in one of the datawindow. The datawindow has some
> code like >
> > sort="column1 A column2 A column3 A"
> >
> > group(by=("column1" ))
> > group(by=("column2" ))
> > group(by=("column3" ))
> >
> > This displays the deta in right order in the desktop
> > application, but it gets totally messed up in the web
> > application.
> > Can someone please help me with this to make it
> > compatible with the Appeon.
> > Thanks.
>