In the BDE / VCL of Delphi you the programmer have to make a decision. If
it is to return a result set you must use:

Select * from stored_Proc

in a TQuery.

if it returns just a singleton / non result set then you can use a
TStoredProc.

JAC.

----- Original Message -----
From: Jim Starkey <jas@...>
To: <IB-Architect@egroups.com>; <IB-Architect@egroups.com>
Sent: 07/mm/2000 10:44 PM
Subject: RE: [IB-Architect] Select procedures


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