How restrict repeated addition of same record

218 100+

I want to restrict the continous addition of same record in a database using Access and ASP.how to check?
all same field values should not repeat again in the database how to do?

Jan 3 '07 #1

Subscribe Post Reply

1194

karthi84

271

100+

i think there is no option to do so for all the fields. if u r using a datagrid in ur page then u can make an alternative for this.

Jan 3 '07 #2

iam_clint

1,208

Expert 1GB

you can check and see if the record is in the DB before adding it... select whatever from wherever where col = 'whatever'

if recordset.eof then its not in there else it is in there.

Jan 3 '07 #3

subashini Thiyagarajan

218

100+

clint,
I was also having the same idea which u said that defiantely worksout.

Anyother tricks simple tricks are there?any one can share your experience

Jan 4 '07 #4

by: Robert Sturzenegger | last post by:

// Code sequence A for (int i = 0; i < 10; ++i) { int k = something(); // some more code which uses k } // Code sequence B int k; for (int i...

C / C++

restrict keyword from ISO C99?

by: tweak | last post by:

Can someone give me a short example as how to best use this keyword in your code? This is my understanding: by definition restrict sounds like it...

C / C++

repeated data managment on listview control

by: Sérgio Almeida | last post by:

Greetings I have a problem using listview control. Well, I belive that this is not realy a problem, but it's consuming me precious time. ...

C# / C Sharp

How can I restrict that the some ID can only login once in the some time

by: ad | last post by:

I use Login control's Authenticate event to authenticate use. I find that different users can use the same ID to login in the same time. How can I...

ASP.NET

restrict query

by: pemo | last post by:

In Harbison and Steele's book, they say that using 'restrict' allows functions like memcpy() to be prototyped like this: void * memcpy(void *...

C / C++

restrict record deletions between tables.

by: shorti | last post by:

Here is an example of what I want to do (syntax might not be entirely correct as this is just an example): CREATE TABLE ParentA ( name CHAR (6)...

DB2 Database

'restrict' in plain English?

by: Me | last post by:

I'm trying to wrap my head around the wording but from what I think the standard says: 1. it's impossible to swap a restrict pointer with another...

C / C++

What does 'restrict' mean?

by: Niu Xiao | last post by:

I see a lot of use in function declarations, such as size_t fread(void* restrict ptr, size_t size, size_t nobj, FILE* restrict fp); but what...

C / C++

what is restrict keyword used for

by: raashid bhatt | last post by:

what is restrict keyword used for? eg int *restrict p;

C / C++

The Top 5 Skills You Need in a PowerApps Developer

by: concettolabs | last post by:

In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...

.NET Framework

Discuss your understanding of the Java platform.

by: better678 | last post by:

Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...

General

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...

General

How to minimize a tool bar that shows up when in reports

by: CD Tom | last post by:

This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...

Oracle Database

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

General

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

General

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

General

How restrict repeated addition of same record

Similar topics