Oracle Constraints

ahijazi · Post by **ahijazi** » Thu 20 Mar 2008 06:59

Dear CoreLab;

When useing the dataset wizared to create a datatable, it take the columns so fine, in case of oracle constraints it does not work, i have to add them manualy .... is there any solution for this issue.

Ahmed Hijazi P. Eng.

Alexey.mdr · Post by **Alexey.mdr** » Thu 20 Mar 2008 10:44

All constraints should be resolved by the DataSet wizard.
Could you post the tables definition?

ahijazi · Post by **ahijazi** » Sat 22 Mar 2008 09:46

Dear CoreLab;
the table is:
------------------------
create table BUILDINGS
(
OID NUMBER(8) not null,
STREET_OID NUMBER(8) not null,
STREET_SIDE NUMBER(1) not null,
FORM_NO NUMBER(1) not null,
BUILDING_NO NUMBER(8) not null,
BUILDING_NAME VARCHAR2(300),
ZONE NUMBER(2) not null,
SUB_ZONE VARCHAR2(4) not null,
SUB_ENTRIES_COUNT NUMBER(2) not null,
OLD_BUILDING_NO VARCHAR2(10) not null,
NOTES VARCHAR2(500),
RESEARCHER_OID NUMBER(8) not null,
OBSERVER_OID NUMBER(8) not null,
AUDITOR_OID NUMBER(8) not null,
SUPERVISOR_OID NUMBER(8) not null,
DATA_ENTRANCE_OID NUMBER(8) not null,
RESEARCH_DATE DATE not null,
OBSERVE_DATE DATE not null,
AUDIT_DATE DATE not null,
SUPERVISE_DATE DATE not null,
DATA_ENTRY_DATE DATE not null,
DATA_TYPE NUMBER(1) not null
);
alter table BUILDINGS add constraint BUILDINGS_PK primary key (OID);
alter table BUILDINGS add constraint BUILDINGS_FORM_UK unique (BUILDING_NO, STREET_OID, STREET_SIDE, FORM_NO, DATA_TYPE);
alter table BUILDINGS add constraint BUILDINGS_ST_B_UK unique (BUILDING_NO, STREET_OID, DATA_TYPE);
----------------

the constraints that are created are (XML file):
------------

---------------

I belive that is wrong, Constraints 2 to 6 must be one constraint, not seprated constraints.

Ahmed Hijazi P. Eng.

Alexey.mdr · Post by **Alexey.mdr** » Mon 24 Mar 2008 10:17

We are investigating this issue.
We will make necessary changes in the next build.

ahijazi · Post by **ahijazi** » Mon 24 Mar 2008 14:23

Dear Core Lab;

When you intend to release an new version??

Best Regards,

Ahmed Hijazi P. Eng.

Alexey.mdr · Post by **Alexey.mdr** » Mon 24 Mar 2008 16:04

The build is scheduled to be released in a month.
But it is likely we will make a minor build as soon as the problem is fixed.