Re: Insert record before First in Forms 4.5?

[Quoted] I'm not sure if you can do that. There could be a feature in which i don't know about.
When forms gets to the last record and you press the down key, it assumes a new record is going to be created.

Couldn't you create your record at the bottom of the block and then sort it after insert?

M

Fraser Boswell wrote in message <3789FB39.9FDD07CC_at_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 - 16:48:26 CEST