Difference between revisions of "SET PCFILTER"

From Recital Documentation Wiki
Jump to: navigation, search
(See Also)
Line 1: Line 1:
=SET PCFILTER=
 
 
 
 
==Class==
 
==Class==
 
Xbase Compatibility
 
Xbase Compatibility
Line 15: Line 12:
  
 
==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 21:
  
 
==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>
  
  

Revision as of 09:29, 17 April 2009

Class

Xbase Compatibility


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 Database Server, Recital Mirage Server, Recital Terminal Developer