Subject | Re: [IBO] Selectable stored procedures and IBO |
---|---|
Author | Helen Borrie |
Post date | 2007-09-10T12:19:46Z |
At 10:10 PM 10/09/2007, you wrote:
Helen
>Hello, how are you?Have you tested your EXECUTE PROCEDURE statement in IB_SQL?
>
>Regarding your last post i tried to do the following:
>
>A TIBOQuery that on the SQL property has "SELECT * FROM SSP(:Param)";
>On that same TIBOQuery, the EditSQL property is like this: "EXCUTE
>PROCEDURE ESP(:SSP_Field)";
>
>This is simply not working! The ESP has several instructions, but to
>make it simpler, i made a very simple update statement. If i
>copy/paste the update statement directly on the EditSQL property it
>works fine, if i put the exact same code on the ESP, when ever i try
>to issue a post to the dataset the following error is displayed:
>
>Dynamic SQL Error
>error code = -303
>internal error
>
>What am i doing wrong here? I Need to use an ESP as explained before
>but i simply cant get it to work!
>Any enlightenment would deeply appreciated!
Helen