On 6 Dic, 14:43, "Jay A. Kreibich" <j...@kreibi.ch> wrote: > On Mon, Dec 06, 2010 at 06:20:13PM +0600, Dagdamor scratched on the wall: >zac Yes ...my error...i want translate name from italian.... I resolve error! Table models is auto generate from csv import file...and...not have a PK !!! i dont see this macro error!
Correct SQL: Anagrafica (Owner) CREATE TABLE [Anagrafica] ( [Idscheda] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [Nominativo] NVARCHAR(100) NOT NULL, [CF] NVARCHAR(16) NOT NULL, [Indirizzo] NVARCHAR(100) NOT NULL, [Citta] NVARCHAR(50) NOT NULL, [Prov] NCHAR(2), [CAP] NCHAR(5), [telefono] NVARCHAR(30), [fax] NVARCHAR(30), [email] NVARCHAR(40), [web] NVARCHAR(55), [datareg] TIMESTAMP NOT NULL DEFAULT ('datetime(''now'',''localtime'')'), [Mostra] BOOLEAN DEFAULT ('1')); Modelli(Models) CREATE TABLE "Modelli" ( [IDschedamodello] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [Marca] NCHAR(25) NOT NULL, [Modello] NCHAR(45) NOT NULL); and..... Vetture (Cars) CREATE TABLE [Vetture] ( [IDvettura] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [IDmodello] INTEGER NOT NULL CONSTRAINT [FKmodello] REFERENCES [Modelli]([IDschedamodello]), [IDproprietario] INTEGER NOT NULL CONSTRAINT [FKproprietario] REFERENCES [Anagrafica]([Idscheda]), [DataImmatricolazione] DATE, [Targa] NVARCHAR(20) NOT NULL); Sorry! :) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users