Difference between revisions of "SET PCPICTURE"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET PCPICTURE=
 
 
==Class==
 
Xbase Compatibility
 
 
 
 
==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, 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 22: Line 16:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
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</pre>
+
       34.7
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 +
[[Category:Documentation]]
 +
[[Category:Commands]]
 +
[[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