I need to fill my sqlda with the data from the row that I am
inserting. I am using default autoincrement id's and I need
to retrieve the id's. Sybase 10 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. The same thing can be
achieved by using @@identity with auto-increment keys.
I am doing just that but my sqlda is empty after executing
the statement. Any and all help would be appreciated.