[Lazarus] DBGrid / DBNavigator not refreshing

[Chris Jennings]

Thanks JoshyFun

procedure TfrmSubjects.zqrySubjectsAfterPost(DataSet: TDataSet);
begin
  zqrySubjects.Close;
  zqrySubjects.Open;
end;

did the trick

cj

JoshyFun wrote:
> Hello Lazarus-List,
>
> Sunday, December 6, 2009, 7:24:37 PM, you wrote:
>
> CJ> I would like to see the DBGrid refresh such that the record followed the
> CJ> mySQL indexing structure and displayed the new entry in alphabetical
> CJ> order for one of the fileds.
>
> >From my point of view you must post, commit and reissue the query,
> once the query is finished you can traverse it looking for your
> inserted field and move the DB cursor to that point. You can disable
> controls while fetching and exploring the table to avoid visual non
> desirable flashes.
>
>