Subject RE: [IBO] IB_Query/SP/KeyLinks
Author Jason Wharton
Using a WHERE clause on select procedures is VERY expensive to the server.
I don't recommend you do this unless it is for very minor adjustments.

Jason Wharton

> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Friday, October 29, 2004 4:12 AM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] IB_Query/SP/KeyLinks
>
>
>
> > 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.
> Alan
>