Lazarus 1.0.6 32 bits on Windows XP SP 3 - FPC 2.6.0 - Firebird 2.5.2 SuperServer.
I have a TIBConnection, TSQL transaction and TSQLQuery connected together and a TDataSource and TDBGrid.
I can open the query, add, modify and delete records, etc...
In the query, I have an "order by" clause wichc corresponds to the primary key.
When I open the query the records are sorted.
My problem is when I add a record, the record is appended at the end of DBGrid and does not respect the order by clause.
I tried IndexFieldsName, IndexDefs, etc... but no solution works except if I close the query and reopen it.
Did I miss something ?