You can't necessarily count on the SQL source to have anything....

but could you look at the BLR of the stored proc, to determine if it has a
suspend in it? if so, then "select", if not, then "execute"?

Seems clunky, but it *could* work... at least sometimes....

Am I missing the point of your question entirely?

Jim Starkey wrote:

>
> At 02:36 PM 6/7/00 -0700, Dan Palley wrote:
> >My guess is that it's not passing SQL directly through, since it has some
> >limitations on what type of query you can build (i.e. no joins).
> >
> >I'm not really sure how the internals of Crystal works, but I'd be happy
> to
> >do an ODBC trace for you; what should I be loooking for?
> >
>
> Don't know. If I knew, the trace wouldn't be necessary.
>
> The question is whether to translate "{ call foo }" into
> "execute procedure foo" or "select * from foo".
>
> Jim Starkey
>
> ------------------------------------------------------------------------
> Wrox Wireless Developer Conference, Amsterdam, July 10-12. Choose from
> 40+ technical sessions covering application of WAP, XML, ASP, Java and
> C++ to mobile computing. Early Bird registration - save ?200 NOW!
> http://click.egroups.com/1/4855/4/_/830676/_/960414414/
> ------------------------------------------------------------------------
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com

--
Gregory Deatz
Hoagland, Longo, Moran, Dunst & Doukas
V: (732)545-4717
F: (732)545-4579