Strange Results:

Terry Pickering pickering@myself.com
Thu, 12 Aug 1999 13:45:59 -0700



John - I know what the problem was, and corrected it quickly.

I just think that some sort on warning such as "data conversion" or showing
the field has overflowed was appropriate (it did not give any such notice).
I doubt very many of us actually look in the dictionary every time we
define a temporary item. Usually you get some kind of notice when you run
the report or in the output. But in this case because the amount is
NEGATIVE it does not give the data conversion error. If you take the
"negative" sign off the data, you do get the error.

See below...

> DEFINE AMT-YTD-BUDGET NUMERIC*11 = parm prompt "Amount: "
> DEFINE T-BUDGET1 NUMERIC*11 = AMT-YTD-BUDGET
> DEFINE T-BUDGET2 INT*8      = AMT-YTD-BUDGET
> DEFINE T-BUDGET3 INT*10     = AMT-YTD-BUDGET
> 
> REPORT &
>   TAB 1  AMT-YTD-BUDGET PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
-2 &
>   TAB 15 T-BUDGET1      PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
-2 &
>   TAB 30 T-BUDGET2      PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
-2 &
>   TAB 45 T-BUDGET3      PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
-2 &
> SKIP
> 
> go

Amount: -3098000000
08/12/1999          Eugene School District HRIS System-TEST            PAGE
  1

AMT-YTD-BUDGET  T-BUDGET1      T-BUDGET2      T-BUDGET3

 -30,980,000   -30,980,000     11,969,673    -30,980,000

?

Records selected: 0
Lines printed:    3
Pages printed:    1

> go

Amount: 3098000000
08/12/1999          Eugene School District HRIS System-TEST            PAGE
  1

AMT-YTD-BUDGET  T-BUDGET1      T-BUDGET2      T-BUDGET3

  30,980,000    30,980,000                    30,980,000



?

Records selected: 0
Lines printed:    3
Pages printed:    1

*W* ** Data conversion errors: 1

> 


Still......


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Terry Pickering        Consultant Extraordinare
Monday and Friday        Tuesday - Thursday
Portland                 Eugene
(503) 245-7178           (541) 687-3416
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.