| Subject | Re: [IBO] TIBOQuery EditSQL with an anonymous sql block |
|---|---|
| Author | Jason Wharton |
| Post date | 2003-10-23T20:16:52Z |
It is best to use a stored procedure, that way your execution takes place on
the server. It is also great because the stored procedure is pre-compiled
and thus ready to run more quickly and there isn't associated parsing going
on at the same time. Trust me, you want to use a stored procedure instead of
that. Also, its nice having your programming on the server instead of
embedded in the client app for maintenance purposes.
Jason
the server. It is also great because the stored procedure is pre-compiled
and thus ready to run more quickly and there isn't associated parsing going
on at the same time. Trust me, you want to use a stored procedure instead of
that. Also, its nice having your programming on the server instead of
embedded in the client app for maintenance purposes.
Jason
----- Original Message -----
From: "lsolart" <lsolar@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, October 23, 2003 12:53 PM
Subject: Re: [IBO] TIBOQuery EditSQL with an anonymous sql block
> So there is no way to create anonymous pl-sql block like oracle? (I
> used it frequently with ODAC/Oracle), or is it a design issue of
> fb/ib?
>
> Thanks again,
> Luis Solar.
>