Difference between revisions of "SET NULLDISPLAY"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 15: | Line 15: | ||
==See Also== | ==See Also== | ||
| − | [[ALTER TABLE]], [[CREATE TABLE]], [[ | + | [[ALTER TABLE]], [[CREATE TABLE]], [[EMPTY()]], [[INSERT]], [[ISBLANK()]], [[ISNULL()]], [[SET NULL]] |
Revision as of 11:50, 19 March 2009
Contents
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, EMPTY(), INSERT, 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
