Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2010
    Posts
    2

    Unanswered: Transaction Rolled back

    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.

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Are there triggers, constraints, foreign keys defined on that table? Are there any other errors displayed?
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Dec 2010
    Posts
    2

    Transaction Rolled back

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

  4. #4
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Quote Originally Posted by chinni2487 View Post
    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?
    I'm not crazy, I'm an aeroplane!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •