I had post about oracle constraints like [NOT NULL], and [UNIQUE key with more than one Columns], and I had told the this issue will be solve in the next build, I have download v 4.6 but the problem is still their,
When I build the dataset, and select my table, the wizard did not recognize Oracle constraints so well,
Not Null Constraint is not included,
UNIQUE key with 2 fields is defined as ((2 unique keys for each column)).
I believe that is a bug ….
I wait you fix for this bug, I hope it be ASAP.
Best Regards,
Ahmed P.Eng.
Oracle Table Structure:
Code: Select all
create table TEST
(
OID NUMBER not null,
F_NAME VARCHAR2(5) not null,
L_NAME VARCHAR2(5) not null,
AGE NUMBER not null,
ADDRESS VARCHAR2(50)
);
alter table TEST add constraint TEST_PK primary key (OID);
alter table TEST add constraint TEST_UK unique (F_NAME, L_NAME);
Code: Select all
select * from HR.TEST
INSERT INTO HR.TEST (OID, F_NAME, L_NAME, AGE, ADDRESS) VALUES (:OID, :F_NAME, :L_NAME, :AGE, :ADDRESS)
UPDATE HR.TEST SET F_NAME = :F_NAME, L_NAME = :L_NAME, AGE = :AGE, ADDRESS = :ADDRESS WHERE OID = :Original_OID
DELETE HR.TEST WHERE OID = :Original_OID