Difference between revisions of "BLANK"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 1: Line 1:
=BLANK=
 
 
 
 
==Class==
 
==Class==
 
Fields and Records
 
Fields and Records
Line 23: Line 20:
  
 
==See Also==
 
==See Also==
[[APPEND BLANK]], [[EMPTY()]], [[ISBLANK()]], [[REPLACE]]
+
[[APPEND BLANK]], [[EMPTY()]], [[GENERATE]], [[ISBLANK()]], [[REPLACE]]
  
  

Revision as of 11:21, 21 April 2009

Class

Fields and Records


Purpose

Fill fields with blanks


Syntax

BLANK [<scope>]

[FIELDS <field list> | LIKE | EXCEPT <skeleton>]

[REINDEX]

[FOR <condition>]

[WHILE <condition>]


See Also

APPEND BLANK, EMPTY(), GENERATE, ISBLANK(), REPLACE


Description

The BLANK command is used to fill a field or fields with empty values. This command is often used to empty out records that have been marked for deletion. This allows the record to be re-used without the need to perform an APPEND BLANK. Fields in the current record of the active table will be blanked, unless a <scope> is specified.

The way that the BLANK command fills each field depends on its data type. The following table describes how each data type is filled with blanks.


Data Type Description
Character All spaces
Data Empty date
Logical .F.
Memo Length of 0
Numeric 0


FIELDS <expC>

You may specify which fields to fill with blanks with a field list of comma-separated fieldnames, or a pattern matching skeleton to blank those fields whose contents either match (LIKE), or do not match (EXCEPT) the specified pattern. If no fields or patterns are specified, the BLANK command will fill all fields in the current record with empty values.

FOR <condition>

Use a FOR <condition> to blank the specified fields in records where a certain condition is true.

WHILE <condition>

To blank fields until a condition is false, use the WHILE <condition>. Blanking a field that is involved in a WHILE <condition> is not recommended as the order of the records will be changed for each key field blanked.


Example

blank all for deleted()


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer