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..

Gautam Parmar · Answer

Use a boolean field for status of delete yes or no

Prem Sahani · Answer

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

Gautam Parmar · Answer

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

Tapan Patel · Answer

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