How to get first value in a view

Here's a fix for a problem I ran across when I developed a news database.

Here's a fix for a problem I ran across when I developed a news database. I needed to display the last news, as todays news even if they were old news. So I made a view categorized by date and the second column was the news titles. The problem was that I didn't know the date for the first value of the view. To solve this problem I did the following:
view:="newsview";
dbc:=@DbColumn("": "NoCache" ; @dbname;view;1);
newsdate:=@If(@IsError(dbc);"";dbc);
key:=@Subset(newsdate;1);
newslist:=@DbLookup("":"NoCache";@dbname;view;key;2);
@If(@IsError(newslist);"";newslist)
This was first published in March 2002

Dig deeper on Domino Resources - Part 7

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.uk

Close