At 11:20 PM 29/01/2003 +0000, you wrote:

>Hi everyone,
>
>What is the best way to get a query (that uses HDR) to add just one
>more record, with a different where clause, to those it's already
>loaded?
>
>eg normally all the jobs for ONE dept are *available* to the query
>(using WHERE DEPT = XXX), but occasionally, I'd like to load one job
>to the buffer from another Dept for viewing/modification, viz WHERE
>JOBNO = :JobNo, without adding all that other Dept's jobs, re-
>preparing, or losing the currently buffered records.
>
>Is this possible?

I see Jason thinks it should be...not sure how he'd envisage it...but this
might do it:

select...........whatever
from xyz...
where dept=:dept
or jobno = :jobno

usual refresh:
...
ParamByName('dept').AsInteger := <Some value>;
ParamByName('jobno').AsInteger := -999; <- spurious jobno

special refresh just supply a real jobno

Helen