Difference between revisions of "SET NULL"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
To determine NULL value support
 
To determine NULL value support
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[ALTER TABLE]], [[CREATE TABLE]], [[EMPTY()]], [[INSERT]], [[ISBLANK()]], [[ISNULL()]], [[SET NULLDISPLAY]], [[SET SQL]]
+
[[ALTER TABLE]], [[CREATE TABLE]], [[EMPTY()]], [[INSERT]], [[ISBLANK()]], [[ISNULL()]], [[NVL()]], [[SET NULLDISPLAY]], [[SET SQL]]
  
  
Line 64: Line 60:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Latest revision as of 16:28, 23 November 2009

Purpose

To determine NULL value support


Syntax

SET NULL ON | OFF


See Also

ALTER TABLE, CREATE TABLE, EMPTY(), INSERT, ISBLANK(), ISNULL(), NVL(), SET NULLDISPLAY, SET SQL


Description

The SET NULL ON | OFF command is used to determine whether columns in a table support NULL values. With SET NULL ON, table columns will support NULL values by default. INSERT will insert a NULL into any column that does not have a value specified. With SET NULL off, NULL values are not supported by default. INSERT will insert a NULL into any column that does not have a value specified.. This default can be overridden by specifying the NULL or NOT NULL column constraint on an individual column.

SET NULL is OFF by default.


Example

set sql to vfp
set null on
CREATE TABLE nullon (firstname c(20), lastname c(20))
INSERT INTO nullon (lastname) VALUES ("Smith")
? [SET NULL ON]
? [ISNULL() ], isnull(firstname)
? [EMPTY() ], empty(firstname)
wait
SET NULL ON
ISNULL()  .T.
EMPTY()  .F.
Press any key to continue...
 
set null off
CREATE TABLE nulloff (firstname c(20), lastname c(20))
INSERT INTO nulloff (lastname) VALUES ("Smith")
? [SET NULL OFF]
? [ISNULL() ], isnull(firstname)
? [EMPTY() ], empty(firstname)
wait
SET NULL OFF
ISNULL()  .F.
EMPTY()  .T.
Press any key to continue...
 
 
set null off
CREATE TABLE nulloff2 (firstname c(20) NULL, lastname c(20))
INSERT INTO nulloff2 (firstname,lastname) VALUES (NULL,"Smith")
? [SET NULL OFF, NULL Column Constraint]
? [ISNULL() ], isnull(firstname)
? [EMPTY() ], empty(firstname)
wait
SET NULL OFF, NULL Column Constraint
ISNULL()  .T.
EMPTY()  .F.
Press any key to continue...


Products

Recital Server, Recital