Difference between revisions of "SET PCPICTURE"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=SET PCPICTURE=
 
 
 
==Class==
 
==Class==
 
Xbase Compatibility
 
Xbase Compatibility
Line 14: Line 12:
  
 
==See Also==
 
==See Also==
[[@...SAY]], [[APPEND]], [[CHANGE]], [[CREATE SCREEN]], [[EDIT]], [[MODIFY SCREEN]], [[CEILING()]], [[EDITFIELD()]], [[FILETYPE()]], [[FLOOR()]], [[FMT()]], [[INDEXEXT()]], [[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]], [[DB_FOXPLUSBUGS]], [[DB_FOXPROKEYS]], [[DB_SAMBA]]
+
[[@...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