Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Insert record before First in Forms 4.5?
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
![]() |
![]() |