HP3000-L Archives

November 2007, Week 3

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Roy Brown <[log in to unmask]>
Reply To:
Roy Brown <[log in to unmask]>
Date:
Mon, 19 Nov 2007 19:56:21 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (71 lines)
In message <[log in to unmask]>, aHash 
<[log in to unmask]> writes
>I am copy pasting the error I get. Even in R ALL it shows { . I understand
>it is 0.
>Bu It wont let me add the same way the detail record.
>
>>F WO-MAST.EM-UNIT-NO=F9 AND WM-START-DATE="20061027" AND
>>>WM-END-DATE="20071031" AND WM-STATUS="C"
>USING SERIAL READ
>1  ENTRIES QUALIFIED
>>R ALL
>
>
>
>
>WM-WO-NO         =602816{
>EM-UNIT-NO       =F9
>LM-LOC-NO        =0001
>WM-START-DATE    =20061027
>WM-START-TIME    =0746
>WM-END-DATE      =20071031
>WM-END-TIME      =0746
>WM-LAST-ACT-DTE  =20071031
>WM-METER         =005615H
>WM-LABOR-HRS     =000000{
>WM-PARTS-COST    =0000160676{
>WM-COMM-COST     =0000000000{
>WM-STATUS        =C
>WM-LABOR-COST    =0000000000{
>WO-REP-CAT       =N
>WM-LAST-PRT      =
>WM-PRT-STAT      =
>WM-METER-2       =000000{
>WM-C-DATE        =20071115
>WM-SCHED         =N
>WM-DOWN-TIME     =008856{
>
>> UPDATE ADD,ACT-WO-DET
>EM-UNIT-NO      =>>F9
>WM-WO-NO        =>>602816{
>LM-LOC-NO       =>>0001
>MISSING SEARCH KEY VALUE FOR WM-WO-NO IN MASTER WO-MAST
>
>==============|  ENTRY CANNOT BE ADDED  |==============
>
>
>EM-UNIT-NO      =>>F9
>WM-WO-NO        =>>602816A
>NUMBER SPECIFIED IS TOO LARGE/SMALL FOR DATA ITEM TYPE: P8
>
>What I am doing wrong??

Firstly, take my earlier advice:

>>Try looking at the record with R ALL,-

(the ',-' is part of what you should type here)

>>Then you should see that your 0 is in fact intact.

Secondly, when adding the detail record, type 6028160, not 602816(

It only displays like that; it doesn't really look like that.

-- 
Roy Brown        'Have nothing in your houses that you do not know to be
Kelmscott Ltd     useful, or believe to be beautiful'  William Morris

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2