Our Training Programs

All contents are copyright of their authors.

check particular cell value and not insert again new value

check particular cell value and not insert again new value

Kanaparthi Sureshma Reddy

11yAsked Jul 8, 2015, 3:27 AM938.NET

Hi,

In my database I have 3 columns ie., Id,Name,Subject(Marks).I inserted records as 1,Sai, 20.

When I am trying to insert new marks to the Sai ,it won't accept new marks to the Sai.

That means I want to restrict to re-enter the marks for particular record and it allows only one time to enter marks..

How to write code for this.. ??

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Hello @sureshma use the trigger for restrict upadte , try following code

create trigger NotUpdate

on
instead of update
as
begin
Print 'You can not re-enter the marks'
end

To make it clear, you want to update the marks if the record already exists?