Data access error on an indexed subfile.
Robert Mills
robert.mills@windsong-services.co.uk
Tue, 14 May 2002 12:51:45 +0100
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01C1FB3D.B8D22080
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C1FB3D.B8D22080"
------_=_NextPart_001_01C1FB3D.B8D22080
Content-Type: text/plain;
charset="iso-8859-1"
Greetings,
Environment: PH839C running under MPE/iX 6.5 on an HP e3000.
Just created a default quick screen to edit some data in an indexed subfile:
:qdesign
>screen foo
>file *sa055k1
>gen
>go
On entering find mode it displayed the following:
Data access error. (SA055K1*01)
THE FILE MUST BE LOCKED BEFORE ISSUING THIS INTRINSIC (FSERR 179)
I then tried again with a couple of other indexed subfiles. One worked and
the other did not... puzzled I am. A qshow of the files revealed that my
first file, SA055K1, had a repeating primary index and the others had a
unique primary index.
Any idea's what's going on as I don't remember having this problem with
PH729.
regards,
uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
Robert W.Mills, Systems Development Manager, Windsong Services
Electron House, Cray Avenue, St. Mary Cray, Kent BR5 3PN, ENGLAND
Tel: +44 (0)1689.870622 x 3005 Fax: +44 (0)1689 899026
robert.mills@windsong-services.co.uk
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
The thoughts, comments, and opinions expressed herein are mine.
They do not reflect those of my employer, nor anyone else.
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
***Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipients and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
------_=_NextPart_001_01C1FB3D.B8D22080
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<STYLE>
BODY
{
FONT-SIZE: 10pt; MARGIN-LEFT: 50px; COLOR: #000000; BACKGROUND-REPEAT: repeat-y; FONT-FAMILY: Comic Sans MS; BACKGROUND-COLOR: #ffffff
}
</STYLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY
style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: Comic Sans MS; BACKGROUND-COLOR: #ffffff"
bgColor=#ffffff background=cid:840522811@14052002-2b59>
<DIV><SPAN class=840522811-14052002>Greetings,</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002>Environment: PH839C running under MPE/iX 6.5
on an HP e3000.</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002>Just created a default quick screen to
edit some data in an indexed subfile:</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002>
<DIV><SPAN class=840522811-14052002>:qdesign</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>>screen foo</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>>file *sa055k1</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>>gen</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>>go</SPAN></DIV></SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN><SPAN
class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002> On entering find mode it displayed the
following:</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002>Data access error.
(SA055K1*01)</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>THE FILE MUST BE LOCKED BEFORE ISSUING THIS
INTRINSIC (FSERR 179)</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002></SPAN><SPAN class=840522811-14052002>I then
tried again with a couple of other indexed subfiles. One worked and
the other did not... puzzled I am. A qshow of the files revealed that my
first file, SA055K1, had a repeating primary index and the others had a unique
primary index.</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN><SPAN
class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002></SPAN><SPAN class=840522811-14052002>Any
idea's what's going on as I don't remember having this problem with
PH729.</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">regards,<BR><BR></SPAN>
<CENTER><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Wingdings">uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
</SPAN><BR><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">Robert
W.Mills, Systems Development Manager, Windsong Services<BR>Electron House, Cray
Avenue, St. Mary Cray, Kent BR5 3PN, ENGLAND<BR>Tel: +44 (0)1689.870622 x 3005
Fax: +44 (0)1689 899026<BR>robert.mills@windsong-services.co.uk </SPAN><BR><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Wingdings">vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
</SPAN><BR><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: 'Comic Sans MS'">The
thoughts, comments, and opinions expressed herein are mine.<BR>They do not
reflect those of my employer, nor anyone else. </SPAN><BR><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Wingdings">vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
</SPAN><BR><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: 'Comic Sans MS'">***Confidentiality Notice:
This e-mail message, including any attachments, is for the sole use of the
intended recipients and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. </SPAN>
<P></P></CENTER><FONT face="Comic Sans MS" size=3>
<DIV></DIV></FONT></BODY></HTML>
------_=_NextPart_001_01C1FB3D.B8D22080--
------_=_NextPart_000_01C1FB3D.B8D22080
Content-Type: image/jpeg;
name="Spiral Bound.jpg"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="Spiral Bound.jpg"
Content-ID: <840522811@14052002-2b59>
/9j/4AAQSkZJRgABAgEASABIAAD/7QSyUGhvdG9zaG9wIDMuMAA4QklNA+kAAAAAAHgAAwAAAEgA
SAAAAAADBgJS//f/9wMPAlsDRwUoA/wAAgAAAEgASAAAAAAC2AIoAAEAAABkAAAAAQADAwMAAAAB
Jw8AAQABAAAAAAAAAAAAAAAAYAgAGQGQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA4
QklNA+0AAAAAABAASAAAAAEAAQBIAAAAAQABOEJJTQPzAAAAAAAIAAAAAAAAAAA4QklNBAoAAAAA
AAEAADhCSU0nEAAAAAAACgABAAAAAAAAAAI4QklNA/UAAAAAAEgAL2ZmAAEAbGZmAAYAAAAAAAEA
L2ZmAAEAoZmaAAYAAAAAAAEAMgAAAAEAWgAAAAYAAAAAAAEANQAAAAEALQAAAAYAAAAAAAE4QklN
A/gAAAAAAHAAAP////////////////////////////8D6AAAAAD/////////////////////////
////A+gAAAAA/////////////////////////////wPoAAAAAP//////////////////////////
//8D6AAAOEJJTQQAAAAAAAACAAA4QklNBAIAAAAAAAIAADhCSU0ECAAAAAAAEAAAAAEAAAJAAAAC
QAAAAAA4QklNBAkAAAAAAqIAAAABAAAAgAAAAAIAAAGAAAADAAAAAoYAGAAB/9j/4AAQSkZJRgAB
AgEASABIAAD//gAnRmlsZSB3cml0dGVuIGJ5IEFkb2JlIFBob3Rvc2hvcKggNC4wAP/uAA5BZG9i
ZQBkgAAAAAH/2wCEAAwICAgJCAwJCQwRCwoLERUPDAwPFRgTExUTExgRDAwMDAwMEQwMDAwMDAwM
DAwMDAwMDAwMDAwMDAwMDAwMDAwBDQsLDQ4NEA4OEBQODg4UFA4ODg4UEQwMDAwMEREMDAwMDAwR
DAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDP/AABEIAAIAgAMBIgACEQEDEQH/3QAEAAj/xAE/
AAABBQEBAQEBAQAAAAAAAAADAAECBAUGBwgJCgsBAAEFAQEBAQEBAAAAAAAAAAEAAgMEBQYHCAkK
CxAAAQQBAwIEAgUHBggFAwwzAQACEQMEIRIxBUFRYRMicYEyBhSRobFCIyQVUsFiMzRygtFDByWS
U/Dh8WNzNRaisoMmRJNUZEXCo3Q2F9JV4mXys4TD03Xj80YnlKSFtJXE1OT0pbXF1eX1VmZ2hpam
tsbW5vY3R1dnd4eXp7fH1+f3EQACAgECBAQDBAUGBwcGBTUBAAIRAyExEgRBUWFxIhMFMoGRFKGx
QiPBUtHwMyRi4XKCkkNTFWNzNPElBhaisoMHJjXC0kSTVKMXZEVVNnRl4vKzhMPTdePzRpSkhbSV
xNTk9KW1xdXl9VZmdoaWprbG1ub2JzdHV2d3h5ent8f/2gAMAwEAAhEDEQA/APROif0Kv6X81T9L
j+ar/m/5K0F8rJJIfqlJfKySKn6pSXyskkp+qUl8rJJKfqlJfKySSn6pSXyskkp+qUl8rJJKfqlJ
fKySSn//2ThCSU0EBgAAAAAABwABAAAAAQEA//4AJ0ZpbGUgd3JpdHRlbiBieSBBZG9iZSBQaG90
b3Nob3CoIDQuMAD/7gAOQWRvYmUAZIAAAAAB/9sAhAAMCAgNCQ0VDAwVGhQQFBogGxoaGyAiFxcX
FxciEQwMDAwMDBEMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMAQ0NDREOERsRERsUDg4OFBQO
Dg4OFBEMDAwMDBERDAwMDAwMEQwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAz/wAARCAAYBaAD
ASIAAhEBAxEB/90ABABa/8QBPwAAAQUBAQEBAQEAAAAAAAAAAwABAgQFBgcICQoLAQABBQEBAQEB
AQAAAAAAAAABAAIDBAUGBwgJCgsQAAEEAQMCBAIFBwYIBQMMMwEAAhEDBCESMQVBUWETInGBMgYU
kaGxQiMkFVLBYjM0coLRQwclklPw4fFjczUWorKDJkSTVGRFwqN0NhfSVeJl8rOEw9N14/NGJ5Sk
hbSVxNTk9KW1xdXl9VZmdoaWprbG1ub2N0dXZ3eHl6e3x9fn9xEAAgIBAgQEAwQFBgcHBgU1AQAC
EQMhMRIEQVFhcSITBTKBkRShsUIjwVLR8DMkYuFygpJDUxVjczTxJQYWorKDByY1wtJEk1SjF2RF
VTZ0ZeLys4TD03Xj80aUpIW0lcTU5PSltcXV5fVWZnaGlqa2xtbm9ic3R1dnd4eXp7fH/9oADAMB
AAIRAxEAPwCv0T+n4/8AxrP+qavW15J0U/r+P/xrP+qavWg8eKElsWSHZfXWYe4A+ZUMjIFTJBE/
Fc1kXbg63mJP+amk0uesGqdc19Sup2ZrLmWGQxwLR4B35v8A0V0qKlJJJIqUkkkkpSSSSSlJJJJK
UkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSS
SSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJ
KUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpS
SSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJ
JKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkp
SSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJ
JJKUkkkkpSSSSSn/0J9G6oKn04zKKXOdYA6x7d1kOP8Ag/3Hs/MXY/sOl/0hYfCT/wCQavnZJArQ
/S1HTXVN21+weYa7/vqzcroeQ+Q3XcYOn/mbF89pIaJfpboXRK+k1uDQPUsILyONPotZ/JatRfKq
SSX6qSXyqkip+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ
KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp
+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6
qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqp
JfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl
8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXy
qkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKq
SSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ
KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp
+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6
qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn/2Q==
------_=_NextPart_000_01C1FB3D.B8D22080--