Hi to all,
I'm trying to create an index as follow:
CREATE TABLE FattureCli
(
fat_id INTEGER PRIMARY KEY,
fat_rif_sogid INTEGER DEFAULT NULL,
fat_rif_mpaid INTEGER DEFAULT NULL,
fat_numfat INTEGER NOT NULL, -- It would be unique by year;
fat_datfat CHAR(10) NOT NULL, -- YYYY-MM-DD;
fat_datter CHAR(10) NOT NULL,
fat_datpag CHAR(10) NOT NULL,
fat_totfat REAL DEFAULT 0,
fat_caufat VARCHAR(100) NOT NULL,
fat_stapag CHAR(2) NOT NULL DEFAULT 'Si',
fat_note TEXT NOT NULL
);
CREATE UNIQUE INDEX Numerazione ON FattureCli (fat_numfat, strftime('%Y',
fat_datfat)) ON CONFLICT FAIL;
Could it be translated into a corret sintax without add another field
(fat_year)?
Thanks in advance, Danilo
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
