Oracle Not Null Constraint

Oracle Not Null Constraint

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

Postby Alexey.mdr » Wed 02 Apr 2008 08:34

Could you please post the table definition script?
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

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

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

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


Return to dotConnect for Oracle