records returned by DBI::selectall_hashref() are not ordered

Example: (Using DBD::SQLite)

$ref_rsch = $dbh->selectall_hashref('
SELECT * FROM rsch ORDER BY Idx
', 'Idx');

while (my ($k, $v) = each(%$ref_rsch)){
while (my ($k, $v) = each(%$v)){
print "$k => $v\n";
}
}



Any ideas and suggestions?

Thanks,

Yu

.