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.

show only most recent row at first...

2 posts in DataWindow Last posting was on 2009-06-09 15:13:36.0Z
j Posted on 2009-06-09 13:36:07.0Z
Sender: 1782.4a2e624b.1804289383@sybase.com
From: J
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: show only most recent row at first...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a2e6547.17d9.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jun 2009 06:36:07 -0700
X-Trace: forums-1-dub 1244554567 10.22.241.41 (9 Jun 2009 06:36:07 -0700)
X-Original-Trace: 9 Jun 2009 06:36:07 -0700, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89450
Article PK: 418640

Hoping you guys can help with this.

I need to find a way to only show the most recent of rows.
For example, I have several rows that are of the same test.
They may have different results and different times, but the
user only wants to see the most current row.

e.g.

Math 84% 6/9/09 13:54
Math 88% 6/9/09 13:57
Math 79% 6/9/09 13:55

The user would initially only want to see the middle row.
But they want the ability to see the other related rows if
they choose, a la treeview type thing. But they would need
to see all the data, not just the "result" and time.

Not sure how to make this happen, any help appreciated!
Thanks!


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-06-09 15:13:36.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a2e6547.17d9.1681692777@sybase.com>
Subject: Re: show only most recent row at first...
Lines: 30
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: <4a2e7c20$1@forums-1-dub>
Date: 9 Jun 2009 08:13:36 -0700
X-Trace: forums-1-dub 1244560416 10.22.241.152 (9 Jun 2009 08:13:36 -0700)
X-Original-Trace: 9 Jun 2009 08:13:36 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89451
Article PK: 418643

Filter on test_date = min (test_date for all). Remove filter to show all.

--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<J> wrote in message news:4a2e6547.17d9.1681692777@sybase.com...
> Hoping you guys can help with this.
>
> I need to find a way to only show the most recent of rows.
> For example, I have several rows that are of the same test.
> They may have different results and different times, but the
> user only wants to see the most current row.
>
> e.g.
>
> Math 84% 6/9/09 13:54
> Math 88% 6/9/09 13:57
> Math 79% 6/9/09 13:55
>
> The user would initially only want to see the middle row.
> But they want the ability to see the other related rows if
> they choose, a la treeview type thing. But they would need
> to see all the data, not just the "result" and time.
>
> Not sure how to make this happen, any help appreciated!
> Thanks!