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?

Thanks,
Steve