Difference between revisions of "SET PCUNIQUE"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Xbase Compatibility | Xbase Compatibility | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[APPEND]], [[ | + | [[APPEND]], [[DB_FOXPLUSBUGS]], [[DB_FOXPROKEYS]], [[DB_SAMBA]], [[EDITFIELD()]], [[FILETYPE()]], [[INDEXEXT()]], [[INDEX]], [[SET CLIPPER]], [[SET CLIPPER5]], [[SET COMPATIBLE]], [[SET EDITFIELD]], [[SET FILECASE]], [[SET FILETYPE]], [[SET INDEXEXT]], [[SET MEMOEXT]], [[SET PCEXACT]], [[SET PCFILTER]], [[SET PCGRAPHICS]], [[SET PCKEYS]], [[SET PCLOCKING]], [[SET PCPICTURE]], [[SET PCSAYS]], [[SET UNIQUE]], [[UNIQUE()]] |
==Description== | ==Description== | ||
| − | The SET PCUNIQUE command causes unique indexes to be treated in the same manner as dBASE. When PCUNIQUE is set ON, it ’hides’ records with the same key value in the UNIQUE index file. Duplicate records can be added to the UNIQUE index file but will not be displayed. However, the GOTO command will still position the record pointer on the record. When SET PCUNIQUE is OFF, duplicate records cannot be entered into the UNIQUE index file. If the attempt is made from the FORMS system, an error message is displayed, and a new index key can be entered, or the [ABANDON] key pressed. If the attempt is made elsewhere, then an error is returned. The default for PCUNIQUE is OFF. | + | The SET PCUNIQUE command causes unique indexes to be treated in the same manner as dBASE. When PCUNIQUE is set ON, it ’hides’ records with the same key value in the UNIQUE index file. Duplicate records can be added to the UNIQUE index file but will not be displayed. However, the GOTO command will still position the record pointer on the record. |
| + | |||
| + | When SET PCUNIQUE is OFF, duplicate records cannot be entered into the UNIQUE index file. If the attempt is made from the FORMS system, an error message is displayed, and a new index key can be entered, or the [ABANDON] key pressed. If the attempt is made elsewhere, then an error is returned. The default for PCUNIQUE is OFF. | ||
| Line 25: | Line 24: | ||
<code lang="recital"> | <code lang="recital"> | ||
set pcunique on | set pcunique on | ||
| − | append from temp</code> | + | append from temp |
| + | </code> | ||
Revision as of 09:51, 17 April 2009
Class
Xbase Compatibility
Purpose
Cause ’unique’ indexes to be treated as they are in dBASE
Syntax
SET PCUNIQUE ON | OFF | (<expL>)
See Also
APPEND, DB_FOXPLUSBUGS, DB_FOXPROKEYS, DB_SAMBA, EDITFIELD(), FILETYPE(), INDEXEXT(), INDEX, SET CLIPPER, SET CLIPPER5, SET COMPATIBLE, SET EDITFIELD, SET FILECASE, SET FILETYPE, SET INDEXEXT, SET MEMOEXT, SET PCEXACT, SET PCFILTER, SET PCGRAPHICS, SET PCKEYS, SET PCLOCKING, SET PCPICTURE, SET PCSAYS, SET UNIQUE, UNIQUE()
Description
The SET PCUNIQUE command causes unique indexes to be treated in the same manner as dBASE. When PCUNIQUE is set ON, it ’hides’ records with the same key value in the UNIQUE index file. Duplicate records can be added to the UNIQUE index file but will not be displayed. However, the GOTO command will still position the record pointer on the record.
When SET PCUNIQUE is OFF, duplicate records cannot be entered into the UNIQUE index file. If the attempt is made from the FORMS system, an error message is displayed, and a new index key can be entered, or the [ABANDON] key pressed. If the attempt is made elsewhere, then an error is returned. The default for PCUNIQUE is OFF.
Example
set pcunique on append from temp
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
