Urgent: Different order of records on MySQL and DBGrid
Posted: Thu 21 Feb 2008 13:04
I am using FetchOnDemand true and am performing the following query:
In MySQL I am getting the following
The table is defined as latin1/latin1_general_ci.
I haven't specified any index or anything else on the SimpleDataSet that might cause reordering of the records. I tried adding tatanaam as index, but that leads to the same result.
I would expect the grid to show the records in the order they were retrieved by the MySQL server. Instead some kind of sorting is applied.
What can be the problem ?
Code: Select all
select tatanaam from tatranp where tatanaam like '%m%' order by tatanaam
- ' name
1 name
2 name
and so on
The table is defined as latin1/latin1_general_ci.
I haven't specified any index or anything else on the SimpleDataSet that might cause reordering of the records. I tried adding tatanaam as index, but that leads to the same result.
I would expect the grid to show the records in the order they were retrieved by the MySQL server. Instead some kind of sorting is applied.
What can be the problem ?