Text Importer

[peisima]

Hi all,

I found this text importer really useful. However, somehow the order of the input is not preserved when inserted.

For example;
Original data:
data1
data2
data3
data4

The inserted order becomes:
data1
data3
data4
data2

Any suggestion? Thanks.

 

[Marco Kalter]

What exactly do you mean by "the inserted order"?

 

[Bo Pedersen]

Note that a select never garantees any ordering (insertion or other) without an order clause. So 4 insert statements followed by a select may show the four rows in any order.

Bo Pedersen