🚀 go-pugleaf

> Thank you for all your valuable input. I have been developing database
> application for years so I am not that newbie.
>
> Maybe I did not put my question very clear so everyone is confused with my
> intention. Let met put it this way:
>
> Let's say PROJECTS is a table created from an external file: abc.txt. While
> NEW_PROJECTS is a corresponding internal table. After some manipulation in
> the NEW_PROJECTS table, I want to export the changes made back to the
> PROJECTS table (and thus reflect the change in abc.txt). Then my concern to
> export the data in a certain order makes perfect sense.

If you're using the data in the external table in an ordered way OUTSIDE IB,
yes.

If you want it ordered INSIDE IB, simply use an ORDER BY clause.

As for the problem, I think the only way to get this ordered would be to select
from a stored procedure that has an ORDER BY clause in it's select ( I haven't
tried it though).


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Tks for any input.
>
> TR@SOE
>
>
> "TR@SOE" <tr@netease.com> д����Ϣ����:3df890a9@newsgroups.borland.com...
> > INSERT INTO PROJECTS
> > SELECT * FROM NEW_PROJECTS
> > WHERE NEW_PROJECTS.START_DATE > ��6-JUN-1994��;
> >
> > I know the above can work. But my question is:
> >
> > Can I add an "ORDER BY" to the SELECT? If yes, how? Something like:
> >
> > INSERT INTO PROJECTS
> > SELECT * FROM NEW_PROJECTS
> > ORDER BY ...
> >
> > doesn't work.
> >
> > If not, what to do if I want to insert into one table with some rows from
> > another dataset which is somehow sorted?
> >
> > Rgds!
> >
> > TR@SOE
> >
> >
>
>