Subject Re: [IB-Architect] Select procedures
Author Jason Chapman
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

----- Original Message -----
From: Jim Starkey <jas@...>
To: <>; <>
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!

To unsubscribe from this group, send an email to: