Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASA V10 ESQL EXECUTE INTO

Status
Not open for further replies.

mrmitchmitchell

Programmer
Jul 28, 2007
7
US
Sybase manual says this:

"INTO clause If EXECUTE INTO is used with an INSERT
statement, the inserted row is returned in the second
descriptor. For example, when using auto-increment primary
keys or BEFORE INSERT triggers that generate primary key
values, the EXECUTE statement provides a mechanism to
re-fetch the row immediately and determine the primary key
value that was assigned to the row."

I can't seem to get the row to return.
Without posting a bunch of code, and all the different ways I have tried it, I wanted to know if anyone else has tried using EXECUTE INTO in the embedded SQL to retrieve the row after insert, and how they achieved it. Sybase hasn't responded to me and they have no examples in their documentation.

Mitch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top