Hi All

When I fill in field values in a series of DBEdits and then click on the Post button of my DBNav the record is inserted in my DB as expected. My problem is that a DBgrid attached to the process does not referesh properley. It does display the addition but does so at the point in the grid where the cursor last resided.

I would like to see the DBGrid refresh such that the record followed the mySQL indexing structure and displayed the new entry in alphabetical order for one of the fileds.

As an example the grid will show

AAA
BBB
ZZZ
CCC after an insert when it should show

AAA
BBB
CCC
ZZZ

Any ideas would be appreciated.

Thanks

Chris

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.

Thanks JoshyFun

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

did the trick

cj

En/na Chris Jennings ha escrit:

Why not simply zqrySubjects.Refresh?
That's what I usually do.

Bye