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.
-- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus