Data Conversion Error

[Oran Shapitka]

Your right Mike.  I forgot to include the NCONVERT in the Item statement.

Oran

> -----Original Message-----
> From: owner-powerh-l@sphere.swau.edu
> [mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Michel Rioux
> Sent: Thursday, January 28, 1999 1:33 PM
> To: Robert J.M. Edis; powerh-l@lists.swau.edu
> Subject: Re: Data Conversion Error
>
>
> Bob.....
>
> By using     NCONVERT(incoming_field)
> in your assignment of new_filed gives the same result as the original
> question.
>
> MiKe
> -----Original Message-----
> From: Robert J.M. Edis <Robert.Edis@creatcomp.com>
> To: 'powerh-l@lists.swau.edu' <powerh-l@lists.swau.edu>
> Date: Friday, January 29, 1999 3:24 PM
> Subject: RE: Data Conversion Error
>
>
> >From the original message the data type of the field must be
> alpha-numeric.
> >Therefore the code should be:
> >
> > item new_field = NCONVERT(incoming_field)  &
> >   if incoming_field >= "-999999" and incoming_field <=  "999999"
> >else 0
> >
> >But, is the data right or left justified? Zero or blank filled? What
> happens
> >if the data value is 9AB31?
> >
> >The solution is not really that easy programmatically.  You should really
> >purge the records of the non-numeric data first and make sure it
> is either
> >all left justified or zero filled.  It could mean testing each byte for a
> >numeric character first.  E.g.
> >
> >DEFINE d_digits CHAR*10 = "0123456789"
> >DEFINE d_nonnum CHAR*01 = "T" &
> >  IF 0 EQ INDEX(d_digits,incoming_field[1]) &
> >  OR 0 EQ INDEX(d_digits,incoming_field[2]) &
> >  ...
> >  ELSE "F"
> >ITEM new_field = NCONVERT(incoming_field)   &
> >  IF d_nonnum NE "T" ELSE 0
> >
> >Blue
> >PowerHouse consultant
> >Rhode Island, USA
> >
> >Disclaimer:
> >The opinions and ideas expressed in this message are my own and have no
> >relationship to my current employer, Initial Technical Staffing,
> its client
> >CCI, or any of CCI's clients.
> >
> >
> >
> > -----Original Message-----
> > From: Oran Shapitka [SMTP:oran@intertechsystems.com]
> > Sent: Friday, January 29, 1999 2:44 PM
> > To: Cindy Lomas; powerh-l@lists.swau.edu
> > Subject: RE: Data Conversion Error
> >
> > 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.
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = = = = =
> >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.
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.