--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> 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

This seems to work well, as long as you only want the one extra
record at a time, (which will do me for now)!

Thanks,
Steve