Difference between revisions of "SET NULLDISPLAY"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
SQL Applications | SQL Applications | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[ALTER TABLE]], [[CREATE TABLE]], [[EMPTY()]], [[INSERT]], [[ISBLANK()]], [[ISNULL()]], [[SET NULL]] | + | [[ALTER TABLE]], [[CREATE TABLE]], [[EMPTY()]], [[INSERT]], [[ISBLANK()]], [[ISNULL()]], [[SET NULL]], [[SET SQL]] |
| Line 23: | Line 20: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
| − | set | + | set sql to vfp |
set null on | set null on | ||
set heading off | set heading off | ||
| Line 38: | Line 35: | ||
set nulldisplay to | set nulldisplay to | ||
list off | list off | ||
| − | .NULL. Smith</ | + | .NULL. Smith |
| + | </code> | ||
Revision as of 16:24, 16 April 2009
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, 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 Database Server, Recital Mirage Server, Recital Terminal Developer
