Deny Data Insertion manually through GUI

Question

0.00/5 (No votes)

See more:

I have a MS SQL SERVER 2005 table with 4 columns, Col1, Col2, Col3 and Col4. If Col2 and Col3 are NULL, then Col4 should deny data that is inserted manually through GUI, which means no query is used either to Insert/Update. The work is done manually through GUI. Else if Col2 and Col3 are NOT NULL, then Col4 can accept data. I don't require Stored Procedures or Triggers to have this done.

Posted 27-Mar-12 19:12pm

arunrk87

Updated 28-Mar-12 18:39pm

v3

Add a Solution

Comments

member60 28-Mar-12 1:15am

you can use improve question question tag for editing the question instead of reposting it again.

[no name] 28-Mar-12 10:46am

Please add more details like language / platform

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)

Liju Sankar · Answer 1 · 2012-03-28T04:51:00

Solution 2

You don't need a SP or a Trigger to achieve this, you can either use IF conditions or CASE[^] in your inline query

like

SQL

UPDATE TABLE1 SET COL4 = CASE COL1 IS NULL AND COL2 IS NULL THEN NULL ELSE 'New Value' END

Posted 28-Mar-12 4:51am

Liju Sankar

OriginalGriff · Answer 2 · 2012-03-27T19:24:00

Solution 1

If you don't want an SP or a Trigger, then you either have to submit it as a complete query - inefficient, and the same code as a SP would have been, or better do it in the GUI application.

Since you don't tell use what language, platform etc, you are using, we can't help you.

Posted 27-Mar-12 19:24pm

OriginalGriff

Comments

arunrk87 28-Mar-12 1:27am

I use MS SQL SERVER 2005 and no Front-end applications.

[no name] 28-Mar-12 10:52am

How do you pass the new value to DB? is by using UPDATE COMMAND?