Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Master-Detail queries with parameters |
Fri, Mar 24 2006 4:06 AM | Permanent Link |
"Godfrey" | Hi All
I have two queries linked in a master-detail relationship. They are linked via a field called "code" which is set as a parameter in the detail query. I need to add extra parameters to the detail query which I will manually set. Is this possible? I get an error that the field(parameter name) does not exist in the master query. Thanks |
Fri, Mar 24 2006 1:33 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Godfrey,
<< I have two queries linked in a master-detail relationship. They are linked via a field called "code" which is set as a parameter in the detail query. I need to add extra parameters to the detail query which I will manually set. Is this possible? I get an error that the field(parameter name) does not exist in the master query. >> You need to assign data types/values to the "manual" parameters prior to opening the query, otherwise the TDBISAMQuery component assumes that they need to be assigned automatically using the master datasource's fields. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |