Failure of Select with data conversion error

[Jeff Hoffman]

FYI

Further to my previous posting:

Now testing the results of an IF test on a 'define' statement:

File_1 contains 

key (char*1)    suspect_field (zoned*3)
 1                   100
 2                   200
 3                   0x0
 4                   010
 5                   300



acc file_1
def test_f char*5 = "BAD" if suspect_field <= 100 else "GOOD"
rep key suspect_field test_f
go

 key     suspect_field      test f
  1           100             BAD 
  2           200            GOOD
  3          ####                
  4            10             BAD
  5           300            GOOD

Records selected: 5
*W* ** Data conversion errors: 2

NOTE: If tested failed, did not set test_f to either GOOD or BAD.



+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
+ Jeff Hoffman                         + e-mail: J.Hoffman@cchs.usyd.EDU.AU +
+ Director                             +                                    +
+ WoniCon Pty Ltd                      +                           ,-_|\    +
+ 21 Prices Circuit                    +  voice: +61 2 9542 1527  /     \   +
+ Woronora    NSW     2141             +    fax: +61 2 9521 3979  \_,-._*   +
+ AUSTRALIA                            +                               v    +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.