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
>> Let's create two unites from one lot:
>>
>> INSERT INTO UNITES (CODE, LOT, SITE, DESCRIPTION) VALUES ('A1', 'L1', 'S1',
>> 'abc'); INSERT INTO UNITES (CODE, LOT, SITE, DESCRIPTION) VALUES ('A2',
>> 'L1', 'S1', 'bcd');
>>
>> I expected that the following instruction will not be exectued:
>>
@yahoogroups.com
Subject: [firebird-support] Multi-column Foreign key
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
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,