Board index » delphi » Can't create Stored Procedure on the fly

Can't create Stored Procedure on the fly

Hi,

 I can't seem to create a stored procedure on the fly from Delphi. I
can, however, create views on the fly. Please advice.

BC

 

Re:Can't create Stored Procedure on the fly


Bill Chen <bi...@media-services.com> wrote in
news:3CFBEF4F.EEAAB887@media-services.com:

Quote
> Hi,

>  I can't seem to create a stored procedure on the fly from
>  Delphi. I
> can, however, create views on the fly. Please advice.

> BC

Are you getting an error message?  If so, what is the error.  Also,
you should post some sample code.

You should be able to use the TIBSQL component and use the CREATE
PROCEDURE syntax to create a Stored Proc at Runtime.

HTH,

--
Alvin Lee
alvin...@attbi.com

Re:Can't create Stored Procedure on the fly


What code are you using?
What component are you using to execute it?
What error message are you getting?

It is not lilely that anyone can answer your question with absolutely
no information to go on.

On Mon, 03 Jun 2002 15:35:59 -0700, Bill Chen

Quote
<bi...@media-services.com> wrote:
>Hi,

> I can't seem to create a stored procedure on the fly from Delphi. I
>can, however, create views on the fly. Please advice.

>BC

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Re:Can't create Stored Procedure on the fly


Don't forget to turn ParamCheck to false.

Quote
Bill Chen wrote:

> Hi,

>  I can't seem to create a stored procedure on the fly from Delphi. I
> can, however, create views on the fly. Please advice.

> BC

--
Jeff Overcash (TeamB)
      (Please do not email me directly unless  asked. Thank You)
This sad little lizard told me that he was a brontosaurus on his mother's
side.  I did not laugh; people who boast of ancestry often have little else
to sustain them.  Humoring them costs nothing and adds to happiness in
a world in which happiness is in short supply.   (RAH)

Other Threads