Answering these in order...

At 09:12 PM 29/10/2004 +1000, you wrote:

> > With a SP as your detail set, there is no cursor, so there can't
> > be a WHERE
> > clause.
>
>?? I use WHERE clauses on SSPs all the time. There can be, and it works
>from the server, but you must be referring to something else.

Yes, of course you can use WHERE clauses on SSPs. But using
MasterParamLinks implies that the WHERE clause can do a cursor locate to
get the detail rows. There is no cursor, so there can't be a WHERE clause
on a non-existent cursor.

Do you understand the mechanism by which rows are output from an SSP?

Helen