Difference between revisions of "SET NULLDISPLAY"

From Recital Documentation Wiki
Jump to: navigation, search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET NULLDISPLAY=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
To specify the text displayed for NULL values
 
To specify the text displayed for NULL values
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[ALTER TABLE]], [[CREATE TABLE]], [[EMPTY()]], [[INSERT]],  [[ISBLANK()]], [[ISNULL()]], [[SET NULL]]
+
[[ALTER TABLE]], [[CREATE TABLE]], [[EMPTY()]], [[INSERT]],  [[ISBLANK()]], [[ISNULL()]], [[NVL()]], [[SET NULL]], [[SET SQL]]
  
  
Line 23: Line 16:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
set sqldialect to vfp
+
set sql to vfp
 
set null on
 
set null on
 
set heading off
 
set heading off
Line 30: Line 23:
 
INSERT INTO nullon (lastname) VALUES ("Smith")
 
INSERT INTO nullon (lastname) VALUES ("Smith")
 
list off
 
list off
.NULL. Smith
+
.NULL.   Smith
  
 
set nulldisplay to "<null>"
 
set nulldisplay to "<null>"
 
list off
 
list off
<null> Smith
+
<null>   Smith
  
 
set nulldisplay to
 
set nulldisplay to
 
list off
 
list off
.NULL. Smith</pre>
+
.NULL.   Smith
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|NULLDISPLAY]]
 
[[Category:Set_Commands|NULLDISPLAY]]
 +
[[Category:SQL]]
 +
[[Category:SQL Set Commands]]

Latest revision as of 16:27, 23 November 2009

Purpose

To specify the text displayed for NULL values


Syntax

SET NULLDISPLAY TO [<expC>]


See Also

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


Description

The SET NULLDISPLAY command is used to specify the text displayed for NULL values. By default NULL values are displayed as .NULL.. The optional <expC> is used to specify alternative display text. If <expC> is omitted, then the display is reset to the default.


Example

set sql to vfp
set null on
set heading off
CREATE TABLE nullon (firstname c(20), lastname c(20))
INSERT INTO nullon (lastname) VALUES ("Smith")
list off
.NULL.    Smith
 
set nulldisplay to "<null>"
list off
<null>    Smith
 
set nulldisplay to
list off
.NULL.    Smith


Products

Recital Server, Recital