Subject | Re: [IBO] Selectable stored procedures and IBO |
---|---|
Author | crazymenconnected |
Post date | 2007-09-10T12:10:53Z |
Hello, how are you?
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!
Luis Semedo Duarte
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!
Luis Semedo Duarte