Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Binaries » View Thread |
Messages 1 to 2 of 2 total |
TDBISAMQuery Master Detail Relationship |
Tue, Jul 14 2009 5:46 AM | Permanent 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 PM | Permanent 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. |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |