> I would like to learn the primary key value of successful SQL
> Insert command.
see "Returning". I think it was introduced with 2.1 or 2.5, definitely
not with 1.5.x
Suppose you don't include an ID in the statement, but only "other
fields" and have the ID created by a Trigger.
Insert into TableXYZ
(
OtherField_1,
OtherField_2
)
Values
(
value_1,
value_2
)
RETURNING
IDField
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
