Devart Forums

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.

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

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.

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

Dear Core Lab;

When you intend to release an new version??


Best Regards,


Ahmed Hijazi P. Eng.

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.