sqlite order by does not order the result on simulator

[swijaya0101]

Hi,

Whatever the sql statement is, it always retrieve the same order.

I have a columns: id (primary key), filename, filepath & filedate

here is my select statement:

select * from test order by filename
select * from test order by filepath
select * from test order by filedate

but the result set is always the same. it does not follow the order by column.

any advise?

Thanks. [import]uid: 32376 topic_id: 7614 reply_id: 307614[/import]

[jmp909]

post your code… how are you outputting? [import]uid: 6645 topic_id: 7614 reply_id: 27287[/import]