Hi,

I have a table alamode on my database. When ever I perform an update on to the database it throws the message "Transaction Rolled back". It it not going to update the row. I am using the isql prompt to update the table. I can see the other tables in the database being updated but not this.

I tried to delete the row in the database and then insert the row I wanted. This case worked fine without any errors. Why is it that the update query failing with the message "Transaction Rolled back".

I am using 12.5.4 Sybase Adaptive server.

Thanks,
Chinni.

Are there triggers, constraints, foreign keys defined on that table? Are there any other errors displayed?

There are no foreign keys or constraints defined on the table. We have one trigger defined on it.

Does ther trigger contain clauses or situations in which a rollback is issued?