U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Multiple DUAL_UNIQUE generate conflicting statements

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

Re: Multiple DUAL_UNIQUE generate conflicting statements [message #52084 is a reply to message #52066]

Wed, 17 July 2019 10:42

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Thanks, applied, with a small addition:

#define DUAL_UNIQUE(k1, k2)        ATTRIBUTE("alter table @t add constraint DQ_@t$" #k1 "$" #k2 " unique "\
                                             "(" #k1 ", " #k2 ");",\
                                             "alter table @t drop constraint DQ_@t$" #k1 "$" #k2 ";")

Report message to a moderator

[Message index]

		Multiple DUAL_UNIQUE generate conflicting statements By: busiek on Wed, 23 May 2018 11:36
		Re: Multiple DUAL_UNIQUE generate conflicting statements By: mirek on Wed, 27 June 2018 10:35
		Re: Multiple DUAL_UNIQUE generate conflicting statements By: busiek on Wed, 27 June 2018 15:50
		Re: Multiple DUAL_UNIQUE generate conflicting statements By: zsolt on Sun, 14 July 2019 02:30
		Re: Multiple DUAL_UNIQUE generate conflicting statements By: mirek on Wed, 17 July 2019 10:42

Previous Topic:	SQLite On delete cascade .sch ?
Next Topic:	BOOL in SQLite

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Apr 29 19:42:50 CEST 2024

Total time taken to generate the page: 0.03911 seconds