Page 1 of 1

[solved] Master/Detail query

Posted: 20.12.2012, 14:30
by 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.

Posted: 22.12.2012, 11:26
by 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;

Posted: 15.01.2013, 01:00
by IndianaJones
Thanks Egon, case solved.