Re: After updating dataset the record goes to the end of the dataset

Hi all,

I am using Postgres in a Delphi application through ODBC. I am having an issue with updating records.

When I create a dataset to get the records in a table then after I update one of these records and then refresh the dataset, the record goes to the end of the dataset. This is disappointing when editing records on a DBGrid, where users find their updated records jump to the end of the grid. Even after restarting the application, the updated record keeps showing at the end of the grid. I have tried the same thing with SQL Server and it works normally, so I thought it was a postgres behvior.

Has anyone an idea about what could be the cause of such a behavior.