Hi all.

Any way to export a table using EXPOR TABLE statement with an order?. I'm exporting a table and I don't know what order takes the csv file to export rows.

Thank's and regards.

Francisco,

<< Any way to export a table using EXPOR TABLE statement with an order?. I'm
exporting a table and I don't know what order takes the csv file to export
rows. >>

At the moment, no.  The export/import uses raw access to the tables for
performance reasons.  However, I'll see about adding an option to specify
the ordering.

As a workaround, you can define a VIEW with an ORDER BY and then export it
using EXPORT TABLE.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

Ok.

Thank's and regards.

Hi again.

I have tryed exporting an ordered view and when I export data the csv file don't take the order of the view, may be I'm doing anything wrong but I don't know.

Thank's.

Francisco,

<< I have tryed exporting an ordered view and when I export data the csv
file don't take the order of the view, may be I'm doing anything wrong but I
don't know. >>

Darn it, forget what I said - the view is going to suffer from the same
issue as before.  I'm just going to have to change the way that EDB opens
the table for the export.

Sorry about that,

Tim Young
Elevate Software
www.elevatesoft.com

Tim.

Don't worry, I've solved the problem importing the csv file to a memory ClientDataSet and handle it instead.