U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » Community » Newbie corner » SQL : how to prevent duplicates ?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: SQL : how to prevent duplicates ? [message #42393 is a reply to message #42378]

Tue, 11 March 2014 11:04

jibe
Messages: 294
Registered: February 2007
Location: France

Experienced Member

Hi, Honza,

Thanks a lot Smile

So, my way to do was good... The problem was that the index was already created as not unique by a precedent try, and I did not saw that... I dopped and re-created it as unique, and all works fine.

And now, I'll know how to do unique indexes on several columns Smile

Report message to a moderator

[Message index]

		SQL : how to prevent duplicates ? By: jibe on Mon, 10 March 2014 20:15
		Re: SQL : how to prevent duplicates ? By: dolik.rce on Mon, 10 March 2014 21:43
		Re: SQL : how to prevent duplicates ? By: jibe on Tue, 11 March 2014 11:04
		Re: SQL : how to prevent duplicates ? By: jibe on Tue, 11 March 2014 15:08
		Re: SQL : how to prevent duplicates ? By: dolik.rce on Tue, 11 March 2014 20:16
		Re: SQL : how to prevent duplicates ? By: jibe on Wed, 12 March 2014 00:33

Previous Topic:	Problem when growing a vector
Next Topic:	Testscatter2 issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Apr 27 21:25:18 CEST 2025

Total time taken to generate the page: 0.04779 seconds