Re: Order of rows in block with basetable

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1999/03/01
Message-ID: <7beh99$elk$1_at_nntp.csufresno.edu>#1/1

In article <36D64C15.43B2D9CE_at_sni.de>, Petra Karstensen <karstensen.muc_at_sni.de> wrote:
>Hi there everybody,
>I have a problem with Forms 4.5. I have a block with basetable, make an
>execute_query, delete some rows and then I want to insert new rows in a
>special order. When the new rows have to be inserted after the remaining
>rows, then there is no problem.
>
>Has anybody an idea, what to do to insert rows before the remaining
>rows?
>
>Thanks for answers.
>
>Petra

I don't completely understand your question, but it sounds like you want to do an "insert before" the first record in the block. Forms allows you to insert a record into the block anywhere except above the first record displayed.

If you are asking how to insert before the first record, I posted a method to do that a while back. You can look it up in Deja news with this link:

    http://x1.dejanews.com/getdoc.xp?AN=281012110

Steve Cosner

---

http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Mon Mar 01 1999 - 00:00:00 CET