Guido,

There are quite a lot of restrictions with stored procedures inside
queries. There is no way to optimise selection of records from stored
procedures, they are an all or nothing situation. You cannot even
refresh a single record because you cannot re-retrieve only one record
from the procedure (you must re-execute the entire procedure).

Jason and I have discussed ways of making single record refreshes
available via a special property (like EditSQL but defining a special
procedure for single record retrieval by key value), but this gets
quite convoluted and would not help your HDR situation.

--
Geoff Worboys - TeamIBO
Telesis Computing