admin 7/21/2021 | |
You are attacking this issue from the wrong angle. Data is the database is not "sorted" but it can be sorted when you retrieve it. If I understand your question right you just need to modify your SQL query adding the following at the end: |
I
|
Ivan van Oosterhout author 7/22/2021 |
Hello, But the tricky part is that when i insert into the database I give an numbering to the rows like Batch and batch number. like this: So during import when i define all colomns to import, It should be Inserted in the DB like this, So before it is inserting in the database i need the sorting, the insert in the database with the correct numbering. |
admin 7/22/2021 | |
It makes more sense now. The solution would be inserting your data into a temporary table first and then moving it to the permanent table in the correct order. |
I
|
Ivan van Oosterhout author 7/22/2021 |
Thank you, It is clear to me, Kind regards |