Oracle Not Null Constraint

ahijazi · Post by **ahijazi** » Wed 02 Apr 2008 06:00

Dear CoreLab;

The wizared of create dateset using oradirect provider do not take the Not Null Constraint of the oracle table ????

Best Regards,

Ahmed Hijazi P. Eng.

Alexey.mdr · Post by **Alexey.mdr** » Wed 02 Apr 2008 08:34

Could you please post the table definition script?

ahijazi · Post by **ahijazi** » Wed 02 Apr 2008 14:25

Table Structure:

create table TEST
(
OID NUMBER not null,
NAME VARCHAR2(5) not null,
ADDRESS VARCHAR2(50)
)

after creating the table by the data set wizared, i have to set the allowdbnull to False manully, for each applied column.

best regards,

Ahmed Hijazi. P.Eng

ahijazi · Post by **ahijazi** » Wed 02 Apr 2008 15:46

Dear CoreLab;

Another issue, after creating a datatable by using the wizard, and set a ID column (as example) as a Primary Key [by right click of mouse in the ID column], the column became a primary key and a function create in the datatable class called FindByID, till that it ok.....

after modify the dataset, by creating another datatable, this function is dropped from the datatable class, and i have to do the previous steps again.. right click on the ID column, and click Set Primary Key menu command.

I believe that is a Bug need be solved....

Ahmed Hijazi. P. Eng.

Alexey.mdr · Post by **Alexey.mdr** » Thu 03 Apr 2008 16:57

The first bug is being fixed now.
Could you please send me some screenshots for the second problem?