Allow users to enter limited records without Triggers

Question

0.00/5 (No votes)

See more:

I have a table structured like this
EMP(name varchar(45), sal money...);

i want the users to enter up to 20 records only..if 21 st record is entered an exception has to be raised... i want to do this witout the use of triggers..

Please help me

Posted 29-Jun-12 2:55am

shashavali

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)

Tim Corey · Accepted Answer · 2012-06-29T03:04:00

There are two places that I see that this could be done. First, you could create a stored procedure that would take up to twenty records as an input. The stored procedure could throw an error if more than that were passed in (at once). The downside here is that you could call the stored procedure more than once. However, you could get complicated and have the stored procedure look up the table and ensure that the user had not already entered 20 values before the insertion began.

The other option would be to put this logic into your application. Have the application do a lookup on the table to see how many records the user had already entered. Then, only allow the remaining number of records to be added.

No matter what you do, it won't be as foolproof as a trigger, but it is possible to achieve your requirements using either of the two methods listed above.

_Amy · Accepted Answer · 2012-06-29T03:04:00

Solution 2

Hi,
Use this:

SQL

DECLARE @count INT
SET @count = (SELECT COUNT(*) FROM test1)
IF @count > 20
BEGIN
   PRINT 'You cannot insert more than 20 records'
END
ELSE
   INSERT INTO test1 VALUES('1', 'Amit', 'Bangalre')

All the best.
--Amit

Posted 29-Jun-12 3:04am

_Amy

Comments

shashavali 29-Jun-12 9:21am

thank you

_Amy 29-Jun-12 9:26am

Welcome shashavali. :)