TIBODataset has singleton output columns, such as you have here, handled
along with the input parameters. This can be detected by looking at the
param type of ptInput, ptOutput or ptInputOutput. If you happen to give an
input and an output param the same name then you will get a parameter of
type ptInputOutput. When you execute it the input value will be changed to
the output value.

TIB_Dataset, such as with TIB_Cursor or TIB_Query (the native IBO data
access components) will not put any output columns in with the Params
columns. They will be in the Fields columns as you are expecting. Also, you
can retrieve singleton output values if you like.

Mason's suggestion is also good but it does add in a little extra work to
have the result delivered via a query that can return potentially multiple
rows. There is the overhead of opening and closing a server cursor and the
fetch calls. Doing it the way you were you simply call execute and all of
the information is handled by that one API call. You can compare the
difference by looking at the SQL trace monitor to see the difference.

Hope this helps,
Jason Wharton
www.ibobjects.com



-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Wednesday, May 28, 2014 6:09 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Correct usage of RETURNING clause

Hi

I am doing an SQL like

UPDATE TableA
SET Fieldname = 2
WHERE Fieldname2 = 3
RETURNING PkField


In an IBOQuery I write

Query.ExecSQL;

Showmessage(Query.ParamByName('PkField').AsString);


This works, I thought I should have used FieldByName but while this does
not Error it does not return a result. Is the above correct?

Thanks
Rob


------------------------------------
Posted by: Robert Martin <rob@...>
------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgradeYahoo
Groups Links