Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 5 of 5 total |
Master-detail + other Params on the detail table |
Sat, Sep 1 2007 12:55 PM | Permanent Link |
Chris Erdal | Is it possible to mix params on a detail query, i.e. some correspond to the
master query's fields and others are set by the program? I'm getting an error saying there's no field in the master dataset with the param's name, which seems to imply I'll have to use filters instead (which doesn't seem optimal for queries). -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3) |
Tue, Sep 4 2007 9:31 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Chris,
<< Is it possible to mix params on a detail query, i.e. some correspond to the master query's fields and others are set by the program? >> Yes, see here: http://www.elevatesoft.com/dbisam4d7_tdbisamquery_datasource.htm You need to make sure that you set a value for any manual parameters, thus setting the Bound property to True, prior to opening the detail query so that the detail query does not try to populate them. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 5 2007 6:54 AM | Permanent Link |
Chris Erdal | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in
news:2A3C93B3-B619-47D2-B04B-F4A156F60DA2@news.elevatesoft.com: > You need to make sure that you set a value for any manual parameters, > thus setting the Bound property to True, prior to opening the detail > query so that the detail query does not try to populate them. > Thanks Tim. That's what I hadn't realised. (by the way, I don't think it's actually put so clearly in the link you included - perhaps an update to the docs is in order?) -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3) |
Wed, Sep 5 2007 2:47 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Chris,
<< (by the way, I don't think it's actually put so clearly in the link you included - perhaps an update to the docs is in order?) >> It's covered, but in the docs for the Bound property: http://www.elevatesoft.com/dbisam4d7_tdbisamparam_bound.htm I'll see about moving it over there also. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Sep 7 2007 10:03 AM | Permanent Link |
Chris Erdal | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in
news:EF8166C5-D6FC-492A-B01B-770EE90FC150@news.elevatesoft.com: > It's covered, but in the docs for the Bound property: > > http://www.elevatesoft.com/dbisam4d7_tdbisamparam_bound.htm > In fact, for the likes of me even that's not clear enough. what makes it all crystal clear is the paragraph from your message above: ---------------------------------8<---------------------- You need to make sure that you set a value for any manual parameters, thus setting the Bound property to True, prior to opening the detail query so that the detail query does not try to populate them. ---------------------------------8<---------------------- stick it after the body of that text, just before the note, and even the dumbest of us will understand! -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3) |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |