Misunderstood a bit.
R all shows the { or } sign chars for zero, A for +1 etc,but when you are adding, changing data, you should key a leading + or minus, not use the { , } A for +1 etc. If changing a field, you need to enclose in " ".
NOTE THAT IF you do a report and specify detail fields, if you don't supply a sign spec in the edit patterns, negative signs can be omitted and mislead you.
jp
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of aHash
Sent: Tuesday, 20 November 2007 6:44 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] Image Query question
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??
>It does that - it's showing as zoned.
>
>Try looking at the record with R ALL,-
>
>Then you should see that your 0 is in fact intact.
>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|