Difference between revisions of "SET PCPICTURE"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Class== | ==Class== | ||
Xbase Compatibility | Xbase Compatibility | ||
| Line 14: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[@...SAY]], [[APPEND]], [[CHANGE]], [[CREATE SCREEN]], [[ | + | [[@...SAY]], [[APPEND]], [[CEILING()]], [[CHANGE]], [[CREATE SCREEN]], [[DB_FOXPLUSBUGS]], [[DB_FOXPROKEYS]], [[DB_SAMBA]], [[EDIT]], [[EDITFIELD()]], [[FILETYPE()]], [[FLOOR()]], [[FMT()]], [[INDEXEXT()]], [[MODIFY SCREEN]], [[ROUND()]], [[SET CLIPPER]], [[SET CLIPPER5]], [[SET COMPATIBLE]], [[SET EDITFIELD]], [[SET FILECASE]], [[SET FILETYPE]], [[SET FORMAT]], [[SET INDEXEXT]], [[SET MEMOEXT]], [[SET PCEDIT]], [[SET PCEXACT]], [[SET PCFILTER]], [[SET PCGRAPHICS]], [[SET PCKEYS]], [[SET PCLOCKING]], [[SET PCSAYS]], [[SET PCUNIQUE]] |
| Line 29: | Line 27: | ||
set pcpicture off | set pcpicture off | ||
@ 0,0 say num picture "99.9" | @ 0,0 say num picture "99.9" | ||
| − | 34.7</code> | + | 34.7 |
| + | </code> | ||
Revision as of 09:48, 17 April 2009
Class
Xbase Compatibility
Purpose
Truncate extra decimal places for dBASE compatibility
Syntax
SET PCPICTURE ON | OFF | (<expL>)
See Also
@...SAY, APPEND, CEILING(), CHANGE, CREATE SCREEN, DB_FOXPLUSBUGS, DB_FOXPROKEYS, DB_SAMBA, EDIT, EDITFIELD(), FILETYPE(), FLOOR(), FMT(), INDEXEXT(), MODIFY SCREEN, ROUND(), SET CLIPPER, SET CLIPPER5, SET COMPATIBLE, SET EDITFIELD, SET FILECASE, SET FILETYPE, SET FORMAT, SET INDEXEXT, SET MEMOEXT, SET PCEDIT, SET PCEXACT, SET PCFILTER, SET PCGRAPHICS, SET PCKEYS, SET PCLOCKING, SET PCSAYS, SET PCUNIQUE
Description
The SET PCPICTURE command allows for dBASE compatibility with the handling of the decimal portion of numeric data in picture statements. When PCPICTURE is set ON, if a picture statement has fewer decimal places than the actual variable or field, the extra decimal places are truncated. If PCPICTURE is OFF, then the numeric data is properly rounded. This command has been added to aid in the porting of applications that use this feature. By default, PCPICTURE is OFF.
Example
num = 34.675 set pcpicture on @ 0,0 say num picture "99.9" 34.6 set pcpicture off @ 0,0 say num picture "99.9" 34.7
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
