Re: How to programmatically through a multirow block - Forms 4.5?

garethgadd_at_my-dejanews.com wrote in article <6t653c$ako$1_at_nnrp1.dejanews.com>...
> In article <01bddba9$57f916e0$c70c400a_at_cms_bssup>,
> "Andy Hardy" <aph_at_glink.net.hk> wrote:
> > Hi,
> >
> > I have a multirow block which contains a date. I'd like to 'centre' the
> > cursor on the date which is closest to sysdate.
> >
> > So far I have achieved this through use of three loops and the
next_record
> > and previous_record commands - one to find the closest record, another
to
> > go past it a certain number of records and a final one to go back to
the
> > closest record!

> number. When all records are returned, you will have the Record No stored
as
> Parameter A. Then wherever you are doing all your loop processing which
you
> no longer need issue a go_record command using the value held in
Parameter A.
> there is no need to make any comparisons to sysdate (from what you've
said)
> as the record you wish to go to will be the greatest date value of those
> returned (assuming that all dates are in the past). If that is not the
case
> than create another Parameter - Parameter C to store sysdate at form
startup
> and make your comparisons against this value. Hope the above is of some
help
> and the processing should be alot quicker than using a series of loops..

That sounds pretty good to me - I'll try it out!

Andy Received on Thu Sep 10 1998 - 15:46:43 CEST