Re: Retrieving Identity Value of newly inserted row

<Sybase newby alert>

Couldn't DBD::Sybase internally cache the value of @@identity at the end
of each sql call that has an insert, which could then be returned later
if the method was called?

On 1/1/1970, "Michael Peppler" <[email protected]> wrote:

<snip>
>       will always return an identity value of 0, which is obviously incor-
>       rect.  This behaviour is due to the fact that the handling of ?-style
>       placeholders is implemented using temporary stored procedures in
>       Sybase, and the value of @@identity is reset when the stored procedure
>       has executed. Using an explicit stored procedure to do the insert and
>       trying to retrieve @@identity after it has executed results in the same
>       behaviour.
<snip>