Subject | Correct usage of RETURNING clause |
---|---|
Author | Robert Martin |
Post date | 2014-05-28T23:08:40Z |
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
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