DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: allow delete on new insert

  1. #1
    Join Date
    May 2007
    Posts
    22

    allow delete on new insert

    imagine this:
    what i did beforehand was declare to form and trigger levels that the deletion of everything is not allowed. but then there is a need that when i am to insert something but didn't commit it, is it possible for me to bypass the other statements and delete it? i know that the form needs to be closed to ignore the "supposed-to-be" added row but is it possible to just delete it without closing the whole form?
    SOMETIMES all we need are just SIMPLE answers.


    ++++++++++++++++++++++++++++++++++++++++
    be proud to be a filipino. be proud to be asian. be proud that your race is a maharlika.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking



    You could just ROLLBACK the transaction before commit.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

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


Click Here to Expand Forum to Full Width