Page 1 of 1
Oracle Not Null Constraint
Posted: Wed 02 Apr 2008 06:00
by ahijazi
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.
Posted: Wed 02 Apr 2008 08:34
by Alexey.mdr
Could you please post the table definition script?
Posted: Wed 02 Apr 2008 14:25
by ahijazi
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
Posted: Wed 02 Apr 2008 15:46
by ahijazi
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.
Posted: Thu 03 Apr 2008 16:57
by Alexey.mdr
The first bug is being fixed now.
Could you please send me some screenshots for the second problem?