Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread TDBISAMQuery Master Detail Relationship
Tue, Jul 14 2009 5:46 AMPermanent Link

Marty Potokar
In using the latest version of DBISAM in Delphi 2007, does DBISAM
support master detail relationships using TDBISAMQuery? Reason for my
asking is that I am unable to retrieve detail records in using a
TDBISAMQuery component for both a master and detail database table.

SQL for the master table is:

Select * From Labels
Where Code = '05'

SQL for the detail table is:

Select * From Library
Where Code = :Code
And Type = :Type

As I am not new to and accustomed to using SQL along with setting up the
Query components, I have tried everything to no avail. Interestingly
enough, I have reviewed and followed everything to the letter the DBISAM
manual v4 regarding TDBISAMQuery.DataSource Property but still unable to
retrieve any detail records. Any thoughts to resolve this matter are
appreciated.
Tue, Jul 14 2009 3:02 PMPermanent Link

Marty Potokar
No need to answer. Simple oversight in my SQL whereby I needed to change
 Code to Library.Code and Type to Library.Type in the SQL for the
detail Query.

Marty Potokar wrote:
> In using the latest version of DBISAM in Delphi 2007, does DBISAM
> support master detail relationships using TDBISAMQuery? Reason for my
> asking is that I am unable to retrieve detail records in using a
> TDBISAMQuery component for both a master and detail database table.
>
> SQL for the master table is:
>
> Select * From Labels
> Where Code = '05'
>
> SQL for the detail table is:
>
> Select * From Library
> Where Code = :Code
> And Type = :Type
>
> As I am not new to and accustomed to using SQL along with setting up the
> Query components, I have tried everything to no avail. Interestingly
> enough, I have reviewed and followed everything to the letter the DBISAM
> manual v4 regarding TDBISAMQuery.DataSource Property but still unable to
> retrieve any detail records. Any thoughts to resolve this matter are
> appreciated.
Image