Difference between revisions of "BLANK"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==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
Contents
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
