Hello
I´ve installed Firebird client 2.7.7.0
When I generate a model, if column it´s not defined as not null a get an
error about primary key can´t be null.
If I define all columns as not null, model is generated but all columns are
marked as primary key.
With this table I get error
CREATE TABLE ARTICULOS (
CODIGO VARCHAR(30) NOT NULL,
DESCRIPCION VARCHAR(80),
TARIFA NUMERIC(15,2) DEFAULT 0 NOT NULL
);
ALTER TABLE ARTICULOS ADD CONSTRAINT PK_ARTICULOS PRIMARY KEY (CODIGO);
And with this:
CREATE TABLE ARTICULOS1 (
CODIGO VARCHAR(30) NOT NULL,
DESCRIPCION VARCHAR(80) not null,
TARIFA NUMERIC(15,2) DEFAULT 0 NOT NULL
);
ALTER TABLE ARTICULOS1 ADD CONSTRAINT PK_ARTICULOS1 PRIMARY KEY (CODIGO);
The model are generated but or column marked as key
Thanks
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider