删除数据，但不完全删除. [英] Deleting data, but not completely.

问题描述

我的问题是:我需要在运行时删除数据，但是当我删除数据时，不应将其完全从Access数据库中删除，而应该访问同一数据库中的另一个表.我如何在Visual Basic 2005(vb.net)中做到这一点，如果可以提供示例代码?请帮我！谢谢.

[edit]主题，标签，TxtSpeak，多个感叹号，大写字母. -OriginalGriff [/edit]

My problem is: I need to delete the data at runtime but when I delete the data it should not be removed completely from access database insteady in another table in the same database should be accessed. how can I do this in visual basic 2005(vb.net) and if you can give sample code? Please help me! Thank you.

[edit]Subject, Tags, TxtSpeak, multiple exclamation marks, capitalization. - OriginalGriff[/edit]

推荐答案

不是从一个表中删除并插入到另一个表中，只需在table1中使用额外的列即可提供记录的状态.如果要删除记录，只需将记录的状态更改为已删除/禁用"即可.

Instead of deleting from one table and Inserting into another just use an extra column in table1 which gives the status of the record. Just change the status of the record to ''deleted/disabled'' if you want to delete the record.

这篇关于删除数据，但不完全删除.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！