Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Insert record before First in Forms 4.5?

Insert record before First in Forms 4.5?

From: Fraser Boswell <Fraser.Boswell_at_spamme.ed.ac.uk>
Date: Mon, 12 Jul 1999 15:27:48 +0100
Message-ID: <3789FB64.10CEB5F2@spamme.ed.ac.uk>


We have a table of including from_date sorted descending, so the most recent from_date is at the top, and we want to insert a new record above the first_record, which will carry the current date (sysdate). That way all records will still be in proper from_date order. We then have to cycle through the records so it is important that the records are Date ordered.
So how do you sort it so that if you are on the first_record of the block, an insert will appear above it?

Thanks in advance

Fraser Received on Mon Jul 12 1999 - 09:27:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US