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 » SQLite Schema Bugfix
SQLite Schema Bugfix [message #24318] Sun, 10 January 2010 18:29 Go to next message
zsolt is currently offline  zsolt
Messages: 693
Registered: December 2005
Location: Budapest, Hungary
Contributor
In Sqlite2Schema.h DUAL_UNIQUE and UNIQUE_LIST definitions are not for sqlite, I think.
The correct definitions would be:
#define DUAL_UNIQUE(k1, k2)        ATTRIBUTE("create unique index DQ_@t$" #k1 #k2 " on @t "\
                                             "(" #k1 ", " #k2 ");",\
                                             "drop index DQ_@t$" #k1 #k2 ";")

#define UNIQUE_LIST(u, l)          ATTRIBUTE("create unique index DQ_@t$" #u " on @t  "\
                                             "(" l ");",\
                                             "drop index UQ_@t$" #u ";")
Re: SQLite Schema Bugfix [message #24362 is a reply to message #24318] Tue, 12 January 2010 18:59 Go to previous message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Thanks!

Mirek
Previous Topic: Database Scheme(*.sch): Can two tables share a field with the same field name?
Next Topic: PostgreSQL and binary data
Goto Forum:
  


Current Time: Thu Mar 28 10:02:29 CET 2024

Total time taken to generate the page: 0.01040 seconds