Dan,

That may be a function of the current ODBC driver as well as a Crystal
limitation.

Could you try and use the ODBC driver with MS Excel/Query to see where
the limitation resides. (Personally, I'm out of the office right now
and don't have a GDB file handy).


Sean

-----Original Message-----
From: Dan Palley [mailto:Dan@...]
Sent: Wednesday, June 07, 2000 5:37 PM
To: 'IB-Architect@egroups.com'
Subject: RE: [IB-Architect] Select procedures

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



------------------------------------------------------------------------
Old school buds here:
http://click.egroups.com/1/4057/4/_/830676/_/960413914/
------------------------------------------------------------------------

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