Difference between revisions of "SET 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