Difference between revisions of "SET PCEXACT"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
==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]], [[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 | + | 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