I have found a weird behavior when selecting data. When I just do something like
SELECT KEY1, KEY2, KEY3, DATA FROM TABLE_A
then I get all data in the order it was inserted
but if I issue a condition like this
SELECT KEY1, KEY2, KEY3, DATA FROM TABLE_A WHERE (KEY1 = 'Nokia_TrafficBalance') AND (KEY2= 'Global')
then the result is sorted
Trying different combinations seems like the problem comes from the condition
KEY1 = 'Nokia_TrafficBalance'
as removing it fixes the issue. The other condition seems to have no issue with order.
It's normal because HXTT Access utilized existent index expression for (KEY1 = 'Nokia_TrafficBalance'), and didsn't do full table search.