I posted a message about a week ago and I had several responses that
didn't help me resolve the problem (but thanks for the effort!) So I
thought that I would post a message that explains the problem a little more
I reproduced the problem in a very simple application. One window. A
TDBGrid and TDBNavigator share the client area. I have a TQuery and a
TDataSource. The TQuery has the SQL: select country, currency from
country; and is connected to the IBLocal sample Interbase database. I
select the first row, Click on the '+' button in the navigator, edit the
new row in the first position (typing 'zzz', 'zzz') and then if I click in
another row or on the post button, one of my original rows disappears (not
quite what I described before). I delete the row I added and then my
original row reappears.
If I close the query and then reopen it immediately after the post then the
row is there, similarly with closing the application and reopening it.
Could this possibly be a bug? It seems to me this would be a common
problem. A grid is a great tool for allowing users to add, modify and
delete rows in a simple table, in a format that they are quite familiar, if
only it displayed the rows correctly. If you can reproduce it then I'd
like to hear about it and if you have a way to avoid the problem without
having to reselect the entire result set with every post then I would be
extremely happy to hear from you.