mrmitchmitchell
Programmer
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
"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