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 #42399 is a reply to message #42377]

Tue, 11 March 2014 15:08

jibe
Messages: 294
Registered: February 2007
Location: France

Experienced Member

I still have a problem : how can I display a message box when someone is trying to create or modify a record that has a duplicated data on a unique index ?

I tried what is explained in this doc, but sql.IsError() does not (no more ?) exists...

I tried with sql.GetErrorCode(), but the error code is always 0 ! However, the error is written to the log.

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: Fri May 10 17:30:38 CEST 2024

Total time taken to generate the page: 0.02624 seconds