Subject | Re: [IBO] TIBOStoredProc - Error |
---|---|
Author | Jason Wharton |
Post date | 2003-11-23T06:49:42Z |
> I made a Stored Procedure and works very well.This results because you are trying to open a cursor for returning a batch
> In my application I put a TIBOStoredProc and when
> I active the TIBOStoredProc give me the message
> 'Error Code 335544327 - Invalid request Handle'.
> Why ?
of records when in reality you have prepared an EXECUTE PROCEDURE statement
which is only designed to return a single row of data and uses and entirely
different API call to do so.
But, I did figure out a way to have TIBOStoredProc go ahead and treat that
one record as a complete dataset. Now you can go ahead and set it to Active
= true or call open instead of ExecProc. It will accomplish essentially the
same thing as before, it's just now more flexible about how it can be
interacted with.
Though, I will say using the ExecProc method is what you should do. If you
want to get a dataset out of a stored procedure then please just use an
IBOQuery component with a select statement.
Regards,
Jason Wharton
http://www.ibobjects.com