[solved] Master/Detail query

Forum related to SQLite

Moderators: gto, cipto_kh, EgonHugeist

IndianaJones
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: 20.10.2009, 16:11

[solved] Master/Detail query

Postby IndianaJones » 20.12.2012, 14:30

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.
Last edited by IndianaJones on 15.01.2013, 01:01, edited 1 time in total.

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 22.12.2012, 11:26

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;
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

IndianaJones
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: 20.10.2009, 16:11

Postby IndianaJones » 15.01.2013, 01:00

Thanks Egon, case solved.


Return to “SQLite”

Who is online

Users browsing this forum: No registered users and 1 guest