Hi  
i found this thread
# 3917 EXPORT TABLE Statement Not Exporting Rows in Primary Key Order

I am runing v2.19 Build 1 but facing the same problem
need help ?
Regards,
Abdulaziz Jasser

Abdulaziz


It works fine here with 2.27b1

Looking at that incident report it was a bug (Fixed Problem on 11/5/2013 in version 2.14 build 5) so there's not much that can be done other than upgrade. However, it may be your data. Can you post a copy of the cvs file for us to look at please.



Roy Lambert

Roy Lambert wrote:

Abdulaziz


It works fine here with 2.27b1

Looking at that incident report it was a bug (Fixed Problem on 11/5/2013 in version 2.14 build 5) so there's not much that can be done other than upgrade. However, it may be your data. Can you post a copy of the cvs file for us to look at please.



Roy Lambert

Thanks  Roy
Attached  
Code used to export ,table data exported from and txt file after export.
The exported data in not in the same seq as the ORIGINAL data.
Regards,
Abdulaziz Jasser

Abdulaziz Jasser wrote:

Roy Lambert wrote:

Abdulaziz


It works fine here with 2.27b1

Looking at that incident report it was a bug (Fixed Problem on 11/5/2013 in version 2.14 build 5) so there's not much that can be done other than upgrade. However, it may be your data. Can you post a copy of the cvs file for us to look at please.



Roy Lambert

Thanks  Roy
Attached  
Code used to export ,table data exported from and txt file after export.
The exported data in not in the same seq as the ORIGINAL data.
Regards,
Abdulaziz Jasser
Regards,
Abdulaziz Jasser

Abdulaziz Jasser wrote:

Abdulaziz Jasser wrote:

Roy Lambert wrote:

Abdulaziz


It works fine here with 2.27b1

Looking at that incident report it was a bug (Fixed Problem on 11/5/2013 in version 2.14 build 5) so there's not much that can be done other than upgrade. However, it may be your data. Can you post a copy of the cvs file for us to look at please.



Roy Lambert

Thanks  Roy
Attached  
Code used to export ,table data exported from and txt file after export.
The exported data in not in the same seq as the ORIGINAL data.
Regards,
Abdulaziz Jasser
Regards,
Abdulaziz Jasser
Regards,
Abdulaziz Jasser

Abdulaziz


You are creating a temporary table what order is that in?

Roy Lambert

Roy Lambert wrote:

Abdulaziz


You are creating a temporary table what order is that in?

Roy Lambert

Thanks  Roy
Kindly see attached file
Regards,
Abdulaziz Jasser

Abdulaziz


Looking at that I can see no key, primary or otherwise, to the table. I'm not sure what order I would expect in the export file.

Roy Lambert

Roy Lambert wrote:

Abdulaziz


Looking at that I can see no key, primary or otherwise, to the table. I'm not sure what order I would expect in the export file.

Roy Lambert

Roy
I am expecting the oreder tb be the same as the source  table.
the index is  (BRANCHSYSNO).
Regards,
Abdulaziz Jasser

Abdulaziz,

<< I am expecting the oreder tb be the same as the source  table. >>

Why would you expect that ?  You're creating a temporary table from a SELECT statement with no ORDER BY.  Therefore, the order is undefined.

If you want a specific order, then you need to explicitly state that ordering using an ORDER BY clause.

Tim Young
Elevate Software
www.elevatesoft.com