HOw to do not delete table value when some where using

Question

hello sir,

 

HOw to do not delete table value when some where using in program..

 

thank you..

Answer 1

Use a boolean field for status of delete yes or no

Answer 2

i have one simple program , suppose, one building is there,  have some facility, like Video Game, restuarents  elc..

when some one using those facility  so we can't delete from table...

 

thank you bro

Answer 3

While user delete row in store procedure update that row into isdeleted=1

 

and retriving data stored procedure will be select * Record where isDeleted=0

Answer 4

Please explain little bit about what do you mean by table value and what is your expected output?