FormatNumber Performance in QTP

Robert Mills robert.mills@windsong-services.co.uk
Thu, 27 Sep 2001 11:42:03 +0100


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C14741.0BA23270
Content-Type: text/plain;
	charset="iso-8859-1"

Hi fellow list members,

We are about to release 8.39C into our production environment (it replaces
8.19D7).

Currently in QTP we have been using the following code to convert numeric
fields to edited character fields:

  Define d-AMOUNT-1            Character *15                         &
       = Ascii(LEDG-VALUE-GROSS Of CM000EX1,15)

  Define d-CURRENCY-AMOUNT     Character *16                         &
       = d-AMOUNT-1[1:13]                                            &
       + "."                                                         &
       + d-AMOUNT-1[14:2]

When we have upgraded to 8.39, we can replace the above two (2) defines with
the following:

  Define d-CURRENCY-AMOUNT      Character *16                        &
       = FormatNumber(LEDG-VALUE-GROSS Of CM000EX1,"0000000000000.00")

Apart from making the programs more easily readable is there any performance
advantage in doing this change?

regards,
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
|Robert W.Mills (Systems Development Manager) |
|Windsong Services, St. Mary Cray, ENGLAND    |
|Tel  : +44 (0)1689 870622 x3005              |
|Fax  : +44 (0)1689 899026                    |
|Email: Robert.Mills@windsong-services.co.uk  |
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+



------_=_NextPart_001_01C14741.0BA23270
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">



 FormatNumber Performance in QTP



Hi fellow list members,

We are about to release 8.39C into our production = environment (it replaces 8.19D7).

Currently in QTP we have been using the following = code to convert numeric fields to edited character fields:

  Define = d-AMOUNT-1          &n= bsp; Character = *15           &nb= sp;           &nb= sp; &
       =3D = Ascii(LEDG-VALUE-GROSS Of CM000EX1,15)

  Define = d-CURRENCY-AMOUNT     Character = *16           &nb= sp;           &nb= sp; &
       =3D = d-AMOUNT-1[1:13]         &n= bsp;           &n= bsp;           &n= bsp;          &
       + = "."          = ;            = ;            = ;            = ;           = &
       + = d-AMOUNT-1[14:2]

When we have upgraded to 8.39, we can replace the = above two (2) defines with the following:

  Define = d-CURRENCY-AMOUNT      Character = *16           &nb= sp;            = &
       =3D = FormatNumber(LEDG-VALUE-GROSS Of = CM000EX1,"0000000000000.00")

Apart from making the programs more easily readable = is there any performance advantage in doing this change?

regards,
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
|Robert W.Mills (Systems Development Manager) = |
|Windsong Services, St. Mary Cray, = ENGLAND    |
|Tel  : +44 (0)1689 870622 = x3005           &= nbsp;  |
|Fax  : +44 (0)1689 = 899026           =          |
|Email: Robert.Mills@windsong-services.co.uk  = |
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+


------_=_NextPart_001_01C14741.0BA23270--