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.