Re: last_insert_id() in sybase

[boftx]

Did you also do a $sth->execute after your prepare statement? A do combines both of those into one operation.

[Shreyak]

Yes i did $sth->execute(@bindValues) after preparing the statement at start of the database connection and executing with bind variables whenever required in code ,and then did $sth->finish() just before disconnecting database. Also i used different statement handlers for insert and update statement.

[boftx]

Then all I can say at this point is what others have mentioned below, show us what you have that failed and what worked. :)