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.

Sort with empty rows

5 posts in DataWindow Last posting was on 2008-09-12 16:01:41.0Z
rob Posted on 2008-09-11 09:29:26.0Z
Sender: 6c6b.48c8e13f.1804289383@sybase.com
From: Rob
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Sort with empty rows
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48c8e4f6.6eb9.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Sep 2008 02:29:26 -0700
X-Trace: forums-1-dub 1221125366 10.22.241.41 (11 Sep 2008 02:29:26 -0700)
X-Original-Trace: 11 Sep 2008 02:29:26 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87745
Article PK: 417000

Hi,
i use the pfc_n_cst_dwsrv_sort. It's possible that exist
empty rows. When i sort for column, at first shows the empty
rows.
Its posible to ignore the empty rows when the user clicke
the Column header.
I know that i can delete the empty rows before the sort,
but i think it exist a function for this problem.

Thanks for help, Rob

PS: I use
// Pfc-Sort-Service
This.of_setSort(TRUE)
inv_sort.of_setcolumnheader(TRUE)


Chris Pollach Posted on 2008-09-11 12:04:07.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48c8e4f6.6eb9.1681692777@sybase.com>
Subject: Re: Sort with empty rows
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48c90937$1@forums-1-dub>
Date: 11 Sep 2008 05:04:07 -0700
X-Trace: forums-1-dub 1221134647 10.22.241.152 (11 Sep 2008 05:04:07 -0700)
X-Original-Trace: 11 Sep 2008 05:04:07 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87747
Article PK: 417003

Rob;

May I suggest that you post this question in the PFC forum for a better
response.

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

<Rob> wrote in message news:48c8e4f6.6eb9.1681692777@sybase.com...
> Hi,
> i use the pfc_n_cst_dwsrv_sort. It's possible that exist
> empty rows. When i sort for column, at first shows the empty
> rows.
> Its posible to ignore the empty rows when the user clicke
> the Column header.
> I know that i can delete the empty rows before the sort,
> but i think it exist a function for this problem.
>
> Thanks for help, Rob
>
> PS: I use
> // Pfc-Sort-Service
> This.of_setSort(TRUE)
> inv_sort.of_setcolumnheader(TRUE)


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-09-11 15:00:41.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48c8e4f6.6eb9.1681692777@sybase.com>
Subject: Re: Sort with empty rows
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48c93299$1@forums-1-dub>
Date: 11 Sep 2008 08:00:41 -0700
X-Trace: forums-1-dub 1221145241 10.22.241.152 (11 Sep 2008 08:00:41 -0700)
X-Original-Trace: 11 Sep 2008 08:00:41 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87748
Article PK: 417007

The DW's Sort method has placed the nulls first:
"The Sort method uses a typical lexical sort, with symbols, such as a hyphen
or underline, ranked higher than alphanumeric characters. It compares
characters in the same manner as does a dictionary. "
You may want to sort on an expression that uses if(isnull(column), ...) - so
you'd have to override the PFC's sort method to do that.

<Rob> wrote in message news:48c8e4f6.6eb9.1681692777@sybase.com...
> Hi,
> i use the pfc_n_cst_dwsrv_sort. It's possible that exist
> empty rows. When i sort for column, at first shows the empty
> rows.
> Its posible to ignore the empty rows when the user clicke
> the Column header.
> I know that i can delete the empty rows before the sort,
> but i think it exist a function for this problem.
>
> Thanks for help, Rob
>
> PS: I use
> // Pfc-Sort-Service
> This.of_setSort(TRUE)
> inv_sort.of_setcolumnheader(TRUE)


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-09-12 16:01:41.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48c93299$1@forums-1-dub> <48ca503f.6248.1681692777@sybase.com>
Subject: Re: Thanks for answer
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ca9265$1@forums-1-dub>
Date: 12 Sep 2008 09:01:41 -0700
X-Trace: forums-1-dub 1221235301 10.22.241.152 (12 Sep 2008 09:01:41 -0700)
X-Original-Trace: 12 Sep 2008 09:01:41 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87753
Article PK: 417011

You should never overWRITE the PFC - inherit an object in the PFE layer and
overRIDE the function you want to add functionality to.

<Rob> wrote in message news:48ca503f.6248.1681692777@sybase.com...
> Thanks for answers.
> Before i overwrite PFC-sort i try in a pfc forum.
> regards Rob
>> The DW's Sort method has placed the nulls first:
>> "The Sort method uses a typical lexical sort, with symbols
>> , such as a hyphen or underline, ranked higher than
>> alphanumeric characters. It compares characters in the
>> same manner as does a dictionary. " You may want to sort
>> on an expression that uses if(isnull(column), ...) - so
>> you'd have to override the PFC's sort method to do that.
>>
>> <Rob> wrote in message
>> > news:48c8e4f6.6eb9.1681692777@sybase.com... Hi,
>> > i use the pfc_n_cst_dwsrv_sort. It's possible that exist
>> > empty rows. When i sort for column, at first shows the
>> > empty rows.
>> > Its posible to ignore the empty rows when the user
>> > clicke the Column header.
>> > I know that i can delete the empty rows before the sort,
>> > but i think it exist a function for this problem.
>> >
>> > Thanks for help, Rob
>> >
>> > PS: I use
>> > // Pfc-Sort-Service
>> > This.of_setSort(TRUE)
>> > inv_sort.of_setcolumnheader(TRUE)
>>
>>