I'm using TDBGrid to output data from Informix DB via ODBC driver.
Dataset Close / Open is used to reread the data from the DB on user's request.
Now I have to make DBGrid to refresh automatically.
Of course, I can initiate Dataset Close / Open every minute with Timer.
But maybe there is a more clever solution available?
E.g., update the DBGrid only when new record is added to the underlying table.
And not to load the whole table, but only the new records.
(Old records are never changed. Old records are deleted after a year, while I have to output data for current day only)