Re: Re: [firebird-support] Multi-column Foreign key

2017-08-10 Thread Paweł Świerzko p_swier...@poczta.onet.pl [firebird-support]
Dear All   thank you for your quick response and support.   The example I have attached was just for help to illustrate problem and is not so important.   I expected firebird to create in such situation the following check in the backgroud:      ALTER TABLE LOCATION ADD CONSTRAINT CHK1_LOCATION

[firebird-support] Multi-column Foreign key

2017-08-09 Thread Paweł Świerzko p_swier...@poczta.onet.pl [firebird-support]
Hi, I have encountered the following situation. Can you tell me - is it bug or feature. Excuse me if it is a silly question. I have two tables: CREATE TABLE UNITES ( CODE VARCHAR(10) NOT NULL, LOT VARCHAR(10) NOT NULL, SITE VARCHAR(10) NOT NULL,