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?

Dan

-----Original Message-----
From: Jim Starkey [mailto:jas@...]
Sent: Wednesday, June 07, 2000 2:33 PM
To: IB-Architect@egroups.com; 'IB-Architect@egroups.com'
Subject: RE: [IB-Architect] Select procedures


At 02:30 PM 6/7/00 -0700, Dan Palley wrote:

>Crystal Reports allows you to call Select Stored Procedures via the ODBC
>driver, but you can't do any joins to other tables or procedures.
>

Does it use the ODBC escape mechanism { call procedures (...)} or
just allow a native InterBase sql statement through and run with
the results(et)?

Jim Starkey

------------------------------------------------------------------------
Take your development to new heights. Work with clients like Dell and
pcOrder. Submit your resume to jobs@.... Visit us at
http://click.egroups.com/1/4358/4/_/830676/_/960413728/
------------------------------------------------------------------------

To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com