>The other workaround is to select the data into a temporary table, and hook
>that up to the dbgrid. It will still generate locks, but these will not
>affect the data that is to be updated.
Or if the amount of data is not too large you could use a clientdataset to
cache the records at the client end. Connect it to the query using a
datasetprovider, open it, and you can close the query, releasing all locks.
The dbgrid can then run off the clientdataset.
Cheers,
Carl
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
