[solved] Master/Detail query

[IndianaJones]

Hi all,
I have a small database and two tables with master/detail relation. I just try to make a simple query and test it with the try except block. So the query works without error. But the DBGrid doesnt refresh the data. Any help highly appreciated.
Regards.

[EgonHugeist]

IndianaJones,

currently i do not really understand you? ):

What exactly is the issue we're talking about?

An MasterDetail example:

Code: Select all

  MasterQuery.SQL.Text := 'SELECT * FROM department ORDER BY dep_id';
  MasterQuery.Open;

  DetailQuery.SQL.Text := 'SELECT * FROM people';
  DetailQuery.MasterSource := MasterDataSource;
  DetailQuery.MasterFields := 'dep_id';
  DetailQuery.LinkedFields := 'p_dep_id';
  DetailQuery.Open;

[IndianaJones]

Thanks Egon, case solved.