Yes I don't issue any sort statement, and I indeed want the data to be show as it is stored in the database. But after updating a row (I don't update the ID, just some fields), it keeps its same place on the DB but jumps to the end of the dataset and by the way to the end of the DBGrid.
Nacef On Tue, Apr 22, 2008 at 12:06 PM, Roland Voegtli <[EMAIL PROTECTED]> wrote: > Has anyone an idea about what could be the cause of such a behavior. > > > > You don't issue any sort statement with the query, obviously. So you get > the records the way they are stored in the database. > > cheers > (R) > >