Data Conversion Error

[Oran Shapitka]

Use an IF structure to test to value of the incoming field.  If it is
non-numeric, assign a value of zero, otherwise use the value from the
incoming field.

Example:

item new_field =    &
  incoming_field  if incoming_field >= -999999 and   &
                     incoming_field <=  999999  else &
  0

Note set your 99999's to the size of the incoming field.


Oran Shapitka, ISP
Intertech Business Systems, Inc.
1564, 10303 Jasper Ave
Edmonton, AB  T5J 3N6  Canada

Email:	oran@intertechsystems.com
Voice:	(780) 413-0400
Fax:		(780) 413-0398


> -----Original Message-----
> From: owner-powerh-l@sphere.swau.edu
> [mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Cindy Lomas
> Sent: Friday, January 29, 1999 11:41 AM
> To: powerh-l@lists.swau.edu
> Subject: Data Conversion Error
>
>
>
> I am attempting to use QTP to initialize a numeric data item that contains
> non-numeric data. Some of the records contain valid numeric data in the
> field where others (1000's) do not. How do I initialize only the fields
> that are not numeric? I keep getting a data conversion error.
>
> Can anyone help?
>
> Cindy Lomas
> Dairy Farmers of Ontario
> Supervisor, Systems Development
> clomas@milk.org
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = = = =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.