Difference between revisions of "TRANSFORM()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
| − | + | Expressions and Type Conversion | |
| Line 39: | Line 36: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Expressions and Type Conversion]] | ||
| + | [[Category:Expressions and Type Conversion Functions]] | ||
Revision as of 15:52, 2 June 2009
Class
Expressions and Type Conversion
Purpose
Function to perform picture formatting
Syntax
TRANSFORM(<exp>, <expC>)
See Also
Description
The TRANSFORM() function allows formatting of <exp> using a picture string <expC> in a similar way to the @...GET command. TRANSFORM() returns a character string formatted as requested. TRANSFORM() is particularly useful for redefining field widths when formatting reports or forms.
From version 9.3.3 onwards, the TRANSFORM() function can be used to return a numeric as a hexadecimal.
Example
total = 3001.23 ? transform(total, "$$$$$9.99") $3001.23 ? transform((0x1a * 2),"@0") 0x00000034
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
