data deletion query from data database

Question

0.00/5 (No votes)

See more:

pls help me for a problem

how to make a function
when i press a delete key on record in listview then
check its uniqe id in all other tabels of database
if found then give message record used in other table
and stop from delete

access database file

Posted 11-May-12 0:09am

Member 2844892

Updated 11-May-12 20:12pm

v2

Add a Solution

2 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)

Wendelius · Answer 1 · 2012-05-11T11:00:00

Solution 2

You didn't mention the database you're using, but let's say it's SQL Server. Regardless of that, if you want to maintain the integrity of the data in the database, don't check the relations in your code. Use the features of the database instead. So if this is for example SQL Server, see SQL FOREIGN KEY Constraint[^]

Posted 11-May-12 11:00am

Wendelius

Comments

P.Salini 12-May-12 2:16am

My 5!

Wendelius 12-May-12 4:18am

Thanks :)

Sandeep Mewara 12-May-12 5:56am

5 again! :)

Wendelius 12-May-12 6:05am

Thanks again ;)

RDBurmon · Answer 2 · 2012-05-11T00:25:00

Why you need function ? You can achieve this using stored procedure.

SQL

CREATE PROC SearchRecordInAllTableById
(
 @Id BIGINT
)
AS
BEGIN
  IF EXISTS (SELECT Id FROM TABLE1 WHERE ID=@Id)
   BEGIN
    RETURN 1
   END

  IF EXISTS (SELECT Id FROM TABLE1 WHERE ID=@Id)
   BEGIN
    RETURN 1
   END

RETURN 0
END