Oracle Constraints

Oracle Constraints

Postby 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.
ahijazi
 
Posts: 45
Joined: Mon 01 Oct 2007 11:13

Postby Alexey.mdr » Thu 20 Mar 2008 10:44

All constraints should be resolved by the DataSet wizard.
Could you post the tables definition?
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby 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.
ahijazi
 
Posts: 45
Joined: Mon 01 Oct 2007 11:13

Postby Alexey.mdr » Mon 24 Mar 2008 10:17

We are investigating this issue.
We will make necessary changes in the next build.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby ahijazi » Mon 24 Mar 2008 14:23

Dear Core Lab;

When you intend to release an new version??


Best Regards,


Ahmed Hijazi P. Eng.
ahijazi
 
Posts: 45
Joined: Mon 01 Oct 2007 11:13

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for Oracle