discarding the same

[2cxc]

I hope i'm not in the wrong forum..?

I was wondering how one could get access to not accept duplicate enteries in the same column? The db is on-line and is being updated via ASP, if that matters. So basically i want the db to siliently not add the value to the column if the exact value is the same, the column is IPaddress and the values are of an IP format. Also would it actually be quicker to pull the record set by distinct than to set the db to not accept duplicate values?

Thanks

 

[KenReay]

Hi

Just set a unique index on that column

depending on how you are doing the update, you may also need to trap and discard the resulting error message, cannot guide you on this, without knowing the mechanism you are using to do the update

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK