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. Thanks to all in advance. Nacef
