Does "?" is NULL value .

Posted by Admin on 22-Nov-2007 08:43

Hi,

All I just want to know .

What is difference between "NULL" value and "UNKNOWN" value

and in which category does "?" lies ?

Is there any way to make an index " not-null " oracle ?

Thanks

OpenEdge Development - Forum

All Replies

Posted by Thomas Mercer-Hursh on 22-Nov-2007 13:50

Don't know about the Oracle side, but ? = NULL = Unknown Value on the ABL side. In the Progress dictionary there is a boolean called Mandatory? will will force the field to be non-null even if you don't give it a default value.

Posted by Admin on 23-Nov-2007 03:15

Actully, I get confused ,

Since i could not find any "NULL" type value in progress.

There must be NULL value for RDBMS. So , Progress uses "?" as null.

Thanks.

Posted by Thomas Mercer-Hursh on 23-Nov-2007 16:42

Yes

This thread is closed