Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    4

    Exclamation Unanswered: undelete deleted recrods from table

    hello forum

    Is there way to undelete deleted records from a table? - For security reasons I need to delete records without removing them out of the database.

    In other words: target is to design a procedure to delete records only logical.

    I had the idea to use a field, saying record is deleted or not.
    This field would control if data is hidden (logical deleted) or not. To undelete a record, only this field would change its state.

    But it becomes difficult if you have many FK to logical deleted data.

    Is there a better or easier way to do this?


    Thanks for you help !!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You could always move the "deleted" records into another table
    and the delete the original record(s).

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    one word: VIEWS
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Agree with DUCK

    I believe it was things like this that VIEW were developed, but you must have some-sort of reference in the DELETE table (ie, a column "DELETE"
    then the view would be for all rows where delete <> 'Y' or whatever...

    Gregg

  5. #5
    Join Date
    Oct 2003
    Posts
    87

    Re: undelete deleted recrods from table

    Only the parent tables need carry the logically deleted attribute. And the fact that a parent table may also be a child need not be considered.

    Originally posted by deepdown
    hello forum

    Is there way to undelete deleted records from a table? - For security reasons I need to delete records without removing them out of the database.

    In other words: target is to design a procedure to delete records only logical.

    I had the idea to use a field, saying record is deleted or not.
    This field would control if data is hidden (logical deleted) or not. To undelete a record, only this field would change its state.

    But it becomes difficult if you have many FK to logical deleted data.

    Is there a better or easier way to do this?


    Thanks for you help !!
    Oracle - DB2 - MS Access -

Posting Permissions

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