Difference between revisions of "SET PCPICTURE"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Truncate extra decimal places for dBASE compatibility | Truncate extra decimal places for dBASE compatibility | ||
| Line 14: | Line 8: | ||
==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 25: | Line 19: | ||
num = 34.675 | num = 34.675 | ||
set pcpicture on | set pcpicture on | ||
| − | @ 0,0 say num picture 99.9 | + | @ 0,0 say num picture "99.9" |
34.6 | 34.6 | ||
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> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|PCPICTURE]] | [[Category:Set_Commands|PCPICTURE]] | ||
Latest revision as of 16:59, 23 November 2009
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 Server, Recital
