Re: HELP: Sorting in INSERT-statements

From: Wolfgang Wagner <ww>
Date: 1995/10/20
Message-ID: <4687bm$5bo_at_news.Austria.EU.net>#1/1


Hi,
it appears to me you want the same order as with "a_column". So why do you need another table? Just use your old table with your order phrase as you try with your insert. If the ordering is not unique as your a_column might arrive more then once, so you would have to use more columns for your order phrase.
You will use an order phrase with your table just inserted, won't you?
If you want to merge more than that one table into your printer table, so you need _one_ value per insert statement. In other words: Do not use nextval for every line, rather use nextval for every insert! This preserves the original order. (You dont want the order of all inserts? Then use a_column as before).
Is there something I did not think of?

Regards
Wolfgang



! Wolfgang Wagner ! Email: ww_at_unisys.co.at
! Unisys Österreich GmbH !
! Seidengasse 33-35 ! Phone: +43-1-52121-327
! POB 27 ! Fax: +43-1-52121-590
! A-1071 Vienna, Austria ! P.S. I do not speak for Unisys.
Received on Fri Oct 20 1995 - 00:00:00 CET

Original text of this message