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)

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

"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)

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

"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)