Difference between revisions of "SET PCFILTER"

From Recital Documentation Wiki
Jump to: navigation, search
(See Also)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET PCFILTER=
 
 
 
==Class==
 
Xbase Compatibility
 
 
 
 
==Purpose==
 
==Purpose==
 
Provide compatibility with dBASE filters
 
Provide compatibility with dBASE filters
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[EDITFIELD()]], [[FILETYPE()]], [[INDEXEXT()]], [[SET CLIPPER]], [[SET CLIPPER5]], [[SET COMPATIBLE]], [[SET EDITFIELD]], [[SET FILECASE]], [[SET FILETYPE]], [[SET FILTER]], [[SET INDEXEXT]], [[SET MEMOEXT]], [[SET PCEDIT]], [[SET PCEXACT]], [[SET PCFKEYS]], [[SET PCLOCKING]], [[SET PCKEYS]], [[SET PCPICTURE]], [[SET PCSAYS]], [[SET PCUNIQUE]], [[DB_FOXPLUSBUGS]], [[DB_FOXPROKEYS]], [[DB_SAMBA]]
+
[[DB_FOXPLUSBUGS]], [[DB_FOXPROKEYS]], [[DB_SAMBA]], [[EDITFIELD()]], [[FILETYPE()]], [[INDEXEXT()]], [[SET CLIPPER]], [[SET CLIPPER5]], [[SET COMPATIBLE]], [[SET EDITFIELD]], [[SET FILECASE]], [[SET FILETYPE]], [[SET FILTER]], [[SET INDEXEXT]], [[SET MEMOEXT]], [[SET PCEDIT]], [[SET PCEXACT]], [[SET PCFKEYS]], [[SET PCLOCKING]], [[SET PCKEYS]], [[SET PCPICTURE]], [[SET PCSAYS]], [[SET PCUNIQUE]]
  
 
==Description==
 
==Description==
Line 24: Line 17:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
set pcfilter on
 
set pcfilter on
goto 23         && record outside of filter
+
goto 23   && record outside of filter
replace fld_name with "new value"</pre>
+
replace fld_name with "new value"</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|PCFILTER]]
 
[[Category:Set_Commands|PCFILTER]]

Latest revision as of 16:35, 23 November 2009

Purpose

Provide compatibility with dBASE filters


Syntax

SET PCFILTER ON | OFF | (<expL>)


See Also

DB_FOXPLUSBUGS, DB_FOXPROKEYS, DB_SAMBA, EDITFIELD(), FILETYPE(), INDEXEXT(), SET CLIPPER, SET CLIPPER5, SET COMPATIBLE, SET EDITFIELD, SET FILECASE, SET FILETYPE, SET FILTER, SET INDEXEXT, SET MEMOEXT, SET PCEDIT, SET PCEXACT, SET PCFKEYS, SET PCLOCKING, SET PCKEYS, SET PCPICTURE, SET PCSAYS, SET PCUNIQUE

Description

The PCFILTER command allows compatibility with dBASE filter conditions.

When PCFILTER is ON, records that are outside the filter condition can be accessed and updated in the same way as in dBASE. When PCFILTER is set OFF, records that are outside the filter condition are never accessible. This command has been added to aid in the porting of applications that use this feature in dBASE. The default for PCFILTER is OFF.


Example

set pcfilter on
goto 23    && record outside of filter
replace fld_name with "new value"


Products

Recital Server, Recital