Difference between revisions of "SET PCEXACT"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET PCEXACT=
 
 
 
==Class==
 
Xbase Compatibility
 
 
 
 
==Purpose==
 
==Purpose==
 
Determines how the SET EXACT command compares strings
 
Determines how the SET EXACT command compares strings
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[EDITFIELD()]], [[FILETYPE()]], [[INDEXEXT()]], [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[RIGHT()]], [[RPAD()]], [[RTRIM()]], [[SOUNDEX()]], [[SUBSTR()]], [[TRIM()]], [[SET CLIPPER]], [[SET CLIPPER5]], [[SET COMPATIBLE]], [[SET EDITFIELD]], [[SET EXACT]], [[SET FILECASE]], [[SET FILETYPE]], [[SET INDEXEXT]], [[SET MEMOEXT]], [[SET PCFILTER]], [[SET PCGRAPHICS]], [[SET PCKEYS]], [[SET PCLOCKING]], [[SET PCPICTURE]], [[SET PCSAYS]], [[SET PCUNIQUE]], [[DB_FOXPLUSBUGS]], [[DB_FOXPROKEYS]], [[DB_SAMBA]]
+
[[DB_FOXPLUSBUGS]], [[DB_FOXPROKEYS]], [[DB_SAMBA]], [[EDITFIELD()]], [[FILETYPE()]], [[INDEXEXT()]], [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[RIGHT()]], [[RPAD()]], [[RTRIM()]], [[SOUNDEX()]], [[SUBSTR()]], [[TRIM()]], [[SET CLIPPER]], [[SET CLIPPER5]], [[SET COMPATIBLE]], [[SET EDITFIELD]], [[SET EXACT]], [[SET FILECASE]], [[SET FILETYPE]], [[SET INDEXEXT]], [[SET MEMOEXT]], [[SET PCFILTER]], [[SET PCGRAPHICS]], [[SET PCKEYS]], [[SET PCLOCKING]], [[SET PCPICTURE]], [[SET PCSAYS]], [[SET PCUNIQUE]]
  
  
Line 37: Line 30:
  
 
==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|PCEXACT]]
 
[[Category:Set_Commands|PCEXACT]]

Latest revision as of 16:35, 23 November 2009

Purpose

Determines how the SET EXACT command compares strings


Syntax

SET PCEXACT ON | OFF | (<expL>)


See Also

DB_FOXPLUSBUGS, DB_FOXPROKEYS, DB_SAMBA, EDITFIELD(), FILETYPE(), INDEXEXT(), LEFT(), LPAD(), LTRIM(), RIGHT(), RPAD(), RTRIM(), SOUNDEX(), SUBSTR(), TRIM(), SET CLIPPER, SET CLIPPER5, SET COMPATIBLE, SET EDITFIELD, SET EXACT, SET FILECASE, SET FILETYPE, SET INDEXEXT, SET MEMOEXT, SET PCFILTER, SET PCGRAPHICS, SET PCKEYS, SET PCLOCKING, SET PCPICTURE, SET PCSAYS, SET PCUNIQUE


Description

The SET PCEXACT command affects the way that the SET EXACT command performs string comparisons. If SET PCEXACT is ON, and SET EXACT is ON, the strings compared need not be an exact match in length. PCEXACT allows for the presence of spaces on the right side of strings. If PCEXACT is ON, and SET EXACT is OFF, PCEXACT will have no affect on string comparisons. If SET PCEXACT is OFF, and SET EXACT is ON, strings are compared for exact length and content. If SET PCEXACT is OFF, and SET EXACT is OFF, strings are compared up to the length of the shortest string. By default, PCEXACT is OFF.


Example

set exact on
? "abc" = "abc       "
.F.
set pcexact on
? "abc" = "abc       "
.T.
set pcexact off
set exact off
? "abc" = "abc       "
.F.


Products

Recital Server, Recital