Suppose you have a TQuery running on a transaction-ish database. You can
select ranges of dates, customers et al happily, and are reluctant to do it
with anything other than SQL. By setting 'request live' true, you can even
edit (table) data directly in a grid.
However, should you also need to be able to access data via, say,
transaction number directly (such as for a 'find transaction' kind of
function) where you can also edit the underlying database, without closing
the DBGrid view of the data (i.e. in a separate window), you wind up with
different versions of the same record in different windows.
So, how can you update the Query so that the fields change to reflect the
changing database without having to rerun the query and search sequentially
through the table to find the record you were on (cursor location) before
you re-ran the query?
This is a problem I've been trying to find a nice tidy solution to for some
time, and I would very much like to know what options are available.
Cheers,
Terry
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
