Delete Query

Question

0.00/5 (No votes)

See more:

VB

Hie!

Anyone tell me how to delete record logically from ms access databse in vb.net 2005 ?

Posted 5-Jul-10 18:53pm

Npanchasara

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

tiggerc · Answer 1 · 2010-07-05T21:19:00

Solution 4

Add a column to your table like Active, type bit, then use a query like this

this will return all the active rows.

SELECT * FROM TBL_YOUR_TABLE WHERE ACTIVE = 1

to delete the row, use a similar statement to this

UPDATE TBL_YOUR_TABLE SET ACTIVE = 0 WHERE YOUR_UNIQUE_ID = UNIQUEID

Posted 5-Jul-10 21:19pm

tiggerc

Christian Graus · Answer 2 · 2010-07-05T19:19:00

It's really annoying when people ask a question and are given an answer, but because they're not smart enough to understand it, they just wait a day and ask it again. The answer has not changed. You want to add a column to mark what fields are deleted and make sure your SQL always uses that field to filter out deleted records.

Abhinav S · Answer 3 · 2010-07-05T19:19:00

Solution 2

You can go through this [^] article - it does not talk about any database in particular but can give you ideas on implementing this type of delete.

Posted 5-Jul-10 19:19pm

Abhinav S

v2

Dhavall Vadher · Answer 4 · 2010-07-05T19:03:00

Solution 1

Sorry, i cant get your answer. Do you mean to Hide a record, that you do not want to display or call ?

Posted 5-Jul-10 19:03pm

Dhavall Vadher

Comments

Npanchasara 6-Jul-10 1:07am

Yes.. when i make it delete logically means falseafter that it will not displayed or call .