How to keep a record in the database, however, hidden to the system?

Question

How to keep a record in the database, however, hidden to the system?

Navigation

#1 by (7 votes)

2

I have an application in Delphi and I need that in this application when the user deletes a record, this record continues in the database, but is hidden in the system.

postgresql

asked by anonymous 07.10.2017 / 16:26

1 answer

Is there a way to implement an interface in a class of a DLL that I can only read? Delphi 10.1, function that only accepts an integer interval in the variable

score 7 · Answer 1

You can apply what is known as logical exclusion: In the application delete procedure run the command UPDATE instead of DELETE , changing the value of the "excluded" column to true . In the records list, consider only those that have the value of the 'excluded' column with the values NULL and false .