DelphiFAQ Home Search:
General :: Programming :: Delphi :: Database
Database development with Delphi. Includes issues with BDE, ADO and InterBase.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Only the 40 most recently viewed articles are shown.
You can see the full list here.

Featured Article

Update controls bound to a query without a primary index

If a query has a primary index, you may just code "Query1.Refresh"
to update a form. This fails if the query has no primary index.
The following procedure shows a flicker-reduced solution:

procedure UpdateQuery(aQuery : TQuery);
 var
   aBookmark : TBookmark;
 begin
   aQuery.DisableControls;
   aBookmark := aQuery.GetBookmark;
   aQuery.Close;
   aQuery.Open;
   aQuery.GotoBookmark (aBookmark);
   aQuery.FreeBookmark (aBookmark);
   aQuery.EnableControls;
 end;
 

Generated 8:01:31 on Feb 21, 2017