Subject | Execute procedure with Returning |
---|---|
Author | Robert martin |
Post date | 2009-10-18T23:12:02Z |
Hi
I have a procedure that inserts a record and returns a value. I need to
call it with Execute procedure otherwise the insert fails. When I try
'Execute procedure xxx(...) RETURNING fieldName' I get an error 'Token
unknown RETURNING'. I am using FB 2.0.x and IBOQuery, IB version 4.8.7
and D2007. Any idea what is wrong?
While I am asking am I correct that I would use the params field of the
component to read back the value returned?
Thanks
Rob
I have a procedure that inserts a record and returns a value. I need to
call it with Execute procedure otherwise the insert fails. When I try
'Execute procedure xxx(...) RETURNING fieldName' I get an error 'Token
unknown RETURNING'. I am using FB 2.0.x and IBOQuery, IB version 4.8.7
and D2007. Any idea what is wrong?
While I am asking am I correct that I would use the params field of the
component to read back the value returned?
Thanks
Rob