Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Multiple DUAL_UNIQUE generate conflicting statements
Re: Multiple DUAL_UNIQUE generate conflicting statements [message #52066 is a reply to message #50048] Sun, 14 July 2019 02:30 Go to previous messageGo to previous message
zsolt is currently offline  zsolt
Messages: 698
Registered: December 2005
Location: Budapest, Hungary
Contributor
Fix:
-#define DUAL_UNIQUE(k1, k2)        ATTRIBUTE("alter table @t add constraint DQ_@t unique "\
+#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;")
+                                             "alter table @t drop constraint DQ_@t$" #k1 #k2 ";")

 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: SQLite On delete cascade .sch ?
Next Topic: BOOL in SQLite
Goto Forum:
  


Current Time: Fri May 17 00:17:30 CEST 2024

Total time taken to generate the page: 0.01567 seconds