Difference between revisions of "SET NULLDISPLAY"

From Recital Documentation Wiki
Jump to: navigation, search
Line 15: Line 15:
  
 
==See Also==
 
==See Also==
ALTER TABLE, CREATE TABLE, INSERT, EMPTY(), ISBLANK(), ISNULL(), SET NULL
+
[[ALTER TABLE]], [[CREATE TABLE]], [[INSERT]], [[EMPTY(]]), [[ISBLANK()]], [[ISNULL()]], [[SET NULL]]
  
  
Line 45: Line 45:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
[[Category:Set_Commands]]
+
[[Category:Set_Commands|NULLDISPLAY]]

Revision as of 13:26, 11 March 2009

SET NULLDISPLAY

Class

SQL Applications


Purpose

To specify the text displayed for NULL values


Syntax

SET NULLDISPLAY TO [<expC>]


See Also

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


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 sqldialect 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 Database Server, Recital Mirage Server, Recital Terminal Developer